LedgerSMB
The foundation for your business
Fork me on GitHub
[ledgersmb-users] GL transaction upload template
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ledgersmb-users] GL transaction upload template



Hi Louis,


On Sun, Dec 29, 2019 at 4:20 PM <..hidden..> wrote:
Hi Erik
I decided to start fresh and used the docker compose file rather than trying to find the exact problem. The file didnt like the network settings.  I had to indent the last line then it worked.

All up and running.

Great news!
 
One last question,  where can I find the template csv file to upload transactions?

To be honest, I found the template to be missing. However, the format is the following:

1st line are the headers, 2nd line and further are the lines of the GL you want to upload (assuming that's what you meant by "upload transactions"). The format of the numbers in the upload is the same as the configured preference for the user doing the upload.

accno: the account number (in the various account selectors, this is the part appearing before the '--'; ie. '5001--Expenses' then accno is '5001')
debit: functional currency amount debit on this line (formatted according to user preference)
credit: functional amount credit on this line (formatted according to user preference)
curr: 3-letter currency indicator for the currency on this line
debit_fx: debit amount on this line in transaction currency (transaction currencies may be foreign currencies)
credit_fx: credit amount on this line in transaction currency
source: identifier or reference value for the transaction in the "source" system; this may be a transaction ID in your bank statement
memo: comment or note specific to this line

I'm sure you miss header data, like "transaction date" etc. That data is entered and submitted from the upload screen itself.


If you have any more questions, don't hesitate to ask!



--
Bye,

Erik.

http://efficito.com -- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.
_______________________________________________
users mailing list -- ..hidden..
To unsubscribe send an email to ..hidden..