You’re offline. This is a read only version of the page.
i want to add a financial dimension as a column for the grid on the customer transactions page.
I think one approach is by connecting the CustTrans table and the GeneralJournalAccountEntry table on "CreatedTransactionID". This will give me LedgerAccount. I can extract the financial dimensions from LedgerAccount. but I am not sure how to make the connections to at least show the correct ledger account.
I tried to add GeneralJournalAccountEntry to the form CustTrans as a datasource and put the field "LedgerAccount" but it shows up blank. I want it to show the first ledgeraccount value that shows up if I click "Voucher" for any of the transcations on the CustTrans form.
Hi hrgohil,
What is the exact business requirement here? For one CustTrans records, there can be multiple accounting entries. So, this will give you multiple records with different ledger accounts. Why do you just take the first ledger account value? The customer transaction does also have financial dimensions. Isn't this already sufficient?
Share
Report
All responses (
Answers (
300,911
