FrontAccounting forum — Batch Import of Sales Invoices from CSV file

Re: Batch Import of Sales Invoices from CSV file

null@example.com (apmuthu) — Mon, 11 May 2015 12:42:36 +0000

Re: Batch Import of Sales Invoices from CSV file

null@example.com (MarkAndrew) — Mon, 11 May 2015 11:37:10 +0000

Hi
where do I find the temlate.
Mark

Hi,
I have updated the extension Import Transactions to incorporate Sales Orders / Invoices. A spreadsheet template is available for both credit invoices and cash invoices. Invoices may be multiline or singleline. The templates use a combination of service and product items. Each invoice / order is defined by the reference number used.
Regards
Ross

Re: Batch Import of Sales Invoices from CSV file

null@example.com (apmuthu) — Sun, 10 May 2015 17:46:45 +0000

The last line in templates/payment_en_GB.csv has an extra comma at the very end that needs to be removed.

REF2,16/12/14,Paid Creditor Control account 2100,220,2100,0,,,1,1,,

should be

REF2,16/12/14,Paid Creditor Control account 2100,220,2100,0,,,1,1,

Re: Batch Import of Sales Invoices from CSV file

null@example.com (raddison) — Sun, 10 May 2015 16:07:19 +0000

Regards
Ross

Re: Batch Import of Sales Invoices from CSV file

null@example.com (itronics) — Tue, 23 Sep 2014 08:47:10 +0000

There is no ready solution fulfilling your requirements, but you can try developing another extension for FA, starting form code used in another FA module with similar functionality like Items Import or Import Multi Journal Entries.
Janusz

Re: Batch Import of Sales Invoices from CSV file

null@example.com (apmuthu) — Mon, 22 Sep 2014 14:31:25 +0000

A trigger on the bespoke database to populate records in the FA db might be another way out.

Re: Batch Import of Sales Invoices from CSV file

null@example.com (malcrf) — Mon, 22 Sep 2014 13:31:13 +0000

I was really looking for something simpler, but thanks

Re: Batch Import of Sales Invoices from CSV file

null@example.com (apmuthu) — Mon, 22 Sep 2014 12:27:01 +0000

To stay within FA, use Quick Entries or use the TextCart Extension. Otherwise:

1. Take a backup of FA
2. Post a typical entry thru the FA web interface
3. take another backup of FA
4. Compare the backups using tools like WinMerge
5. Skip the normal audit trail and logging entries and focus on the meat of the insert / updates
6. Make a template out of the insert / update sqls making the timestamp entries NOW() where appropriate (and likewise for current date)
7. Export the record variables from your manual invoice system
8. Mailmerge with the sql template created in 6
9 upload the mailmerged sql statements in a MySQL client or append them to the backup and then restore it.
10. Make sure no entries are made / changed in FA in the meanwhile.

Batch Import of Sales Invoices from CSV file

null@example.com (malcrf) — Mon, 22 Sep 2014 10:55:13 +0000

We have to use a bespoke system to generate our sales invoices because there are some things unique to our business, but at the moment we are manually keying these into FrontAccounting.

As far as I can see a Direct Invoice in Front Accounting inserts/updates 10 tables, and I was rather hoping someone might have already done something for importing a large batch of Sales Invoices into FrontAccounting.

Any assistance gratefully received