1 Reply by steveorg

(5 replies, posted in Setup)

Pasting into mySQL is one of the methods that I was considering. I'm a little worried about missing something using the method above. What can go wrong, will. :-) I suspect that your single record per transaction in a CSV could be more bullet-proof. I have a small budget, but I can pay something for the script.

Could you point me to a DB schema that I can also use as a reference? That may give me more comfort in trying your latest suggestion.

Steve

Go to forum: Setup

2 Reply by steveorg

(5 replies, posted in Setup)

Thanks for the quick reply apmuthu.

I should have mentioned that I plan to consolidate the sales reports from all sources into one CSV and/or sql query using Excel. Putting all related items into one record is easily doable.

While I'm a champ with Excel functions, DBs and VB, I do not have the skills to "hammer out a PHP script". Is that service available? How much do you think it would cost?

Steve

Go to forum: Setup

3 Topic by steveorg

(5 replies, posted in Setup)

I'm evaluating if FrontAccounting is appropriate for my business. I like what I see, but I have concerns because I need  FrontAccounting to accommodate a couple of our efficient workflows.

The business is web based. The company manufactures products by contracting with copackers for large bulk quantities that are sufficient for several months of sales. We sell the products on our website and many marketplaces, such as Amazon.

To record sales from the marketplaces, I'd like to import csv files monthly. Each record in the csv should be able to:
- Create the sale transaction, which will include product sales, shipping sales, discounts, marketplace fees, and debit either marketplaces receivables or PayPal as a bank account.
- Properly adjust inventory levels and charge cost of sales based on quantity and SKU fields.

To record most of our checking account charges, I'd like to import csv files monthly. 85% of our checking account transactions are for postage and shipping. Instead of entering each transaction individually, we prefer to import them in bulk. Each of these imported transactions should be visible to the bank reconciliation function.

To record most bank account transfers, I'd like to import csv files monthly. Each of these imported transactions should be visible to the bank reconciliation function.

Are these imports possible with FrontAccounting? Alternatively, could I import them via SQL queries?

Thanks for all advice.

Go to forum: Setup