[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: import csv transactions to gl



Hi Bill,

The journal header data should be entered in the journal upload screen (as you found in: General Journal > Import). Then a CSV is expected where the first line is a header line, naming these columns:

* accno
* debit amount
* credit amount
* source (= source reference number)
* memo (= remarks field)

basically, these are the same fields as you'd normally enter in the entry screen. "Source" is a reference to another system and the number the transaction line may have in that system.

The field separator must be a comma and the number setting (decimal and thousands separators) is the same as the one the uploading user has configured.

Off the top of my head I'm not sure if the transaction is immediately posted or should be confirmed by posting through the "Transaction Approval" menu item.


Hope that helps!

Regards,

Erik.



On Wed, Mar 1, 2017 at 2:17 AM, Bill Dika <..hidden..> wrote:
Is there any guide to accomplish the above?

I see the import function in LedgerSMB 1.5 but do not know how, nor can I find the mapping instructions so that I can import my csv transactions into Ledger SMB 1.5.

Any help would be much appreciated.

Thanks.

Bill Dika

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users




--
Bye,

Erik.

http://efficito.com -- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users