Export General Ledger Journal Entries (End of Month) to a flat file the Send to Oracle

Kurt Wireman

Hello,

I'm using Syteline 9.00.20 on-prem and my finance team would like to export end of month G/L Journal Entries to a flat file (csv or dat) for import by an Oracle interface. Basically, they don't want to re-enter the same information twice if it can simply be exported from Syteline to Oracle at the end of each month.

Would anyone know what table(s) I need to reference to pull in the required information? Location code, account number, total debits and total credits for each account. However, I haven't found a column yet that's for debits or credits. 

Has anyone had to do something similar before? Thanks so much, I appreciate it!

monthly_proactive_com201101.pdf

Ryan Pukanski

Hi, if you are using the tables you won't get a debit or credit amount, you will only see negative and positive. If you are doing an export in Syteline, from a dataview for example, you can use the ledger IDO and it will derive what is a debit vs what is a credit as two different fields. You could also look at the IDO to see the coding to see how it determines what is debit and what is credit, my guess will be a reference to the account class.