RE: Accounting Journal Entries SQL
Ok, a little update:
I’ve connected Transactions, Transaction_Lines, Accounts, Accounting_Periods, Accounting_Books, Subsidaries, Departments, Companies…
Now I am looking on how to “bring” a customer account to the revenue line.
So, if the JE is:
DEBIT Customer Account 123
CREDIT VAT Account 999
CREDIT Revenue Account 444
I want to be able to bring to the line 3 customer account 123 from the first line.
I wonder if there is already the Customer Account characteristic ON LINE 3 (Revenues) somewhere …? Maybe another table?
I know SAP has it (KUNNR in BSEG), Priority has it… What about NS?