Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Importing Outstanding Customer/Supplier Invoices
08-27-2016, 03:40 AM, (This post was last modified: 08-27-2016, 04:15 AM by R2-G.)
Importing Outstanding Customer/Supplier Invoices

Am setting up a new system and would like to import outstanding customer and supplier invoices from an old system.
I searched the forums for help and found Phil's advice as follows

1. http://weberp-accounting.1478800.n4.nabb...l#a3947378

You can import outstanding transactions into supptrans and debtortrans
See the FAQ for setting the next invoice/transaction number.

2. http://weberp-accounting.1478800.n4.nabb...84299.html

You can just import all the outstanding invoices into debtortrans and
supptrans - the FX balance outstanding on the invoice is derived by the
ovamount + ovgst +ovfreight - ovdiscount less the amount in the alloc
field. The exchange rate is also recorded against the transaction too.
You must be sure to have referential integrity intact - with customers
(debtorsmaster and custbranch) and invoices are transtype 10 credit
notes 11. You also need to enter a valid period number.

What I have a problem with is the field ID in both debtortrans and supptrans tables
can I just insert sequential numbers (1,2,3,4 etc) in the ID field on the csv file with
the outstanding transactions to be imported ?

Thanks in advance



This is now solved,
I just found that if I omit the ID field in the input csv file, mysql inserts sequential numbers automatically


Forum Jump:

Users browsing this thread: 1 Guest(s)