You’re offline. This is a read only version of the page.
Announcements
3,732
Hello,
Can anyone please let me know what is the relation between the Free text invoice (Custinvoicetrans) to GeneraljournalEntry table?
Hi Satish,
I wish there was an easy way to relate transactional data with ledger entries, but the truth is there is no direct 1:1 relation between any of these tables.
What you can do to get a good match is first search for CustInvoiceJour (header) using the following fields:
Then relate the fields LedgerVoucher from CustInvoiceJour with SubledgerVoucher on the GeneralJournalEntry + DefaultDimension from CustInvoiceTrans with LedgerDimension from GeneralJournalAccountEntry (using LedgerDimensionFacade::getDefaultDimensionFromLedgerDimension() in order to get a match between both fields) + LineAmount from CustInvoiceTrans and abs(AccountingCurrencyAmount) from GJAE.
This of course cannot be translated easily into an x++ query, since it uses x++ functions that don't translate to SQL, but it's the best approximation I could find.
Hope that helps.
Hi,
there is not such a relationship between these two tables. and question has some incorrect informations: free text invoices' table is custinvoicetable. its line table is custinvoiceline. please check your question and elaborate further.
Regards.
Open AOT and check each table to see the relation tab if they are mentioned.
Anyway I joined them differently you can first join GeneralJournalEntry gje to GeneralJournalAccountEntry gjae using gje.Recid=gjae.GeneralJournalEntry
Then join GeneralJournalEntry gje and CustInvoiceTrans cit using gje.subledgervoucher=cit.invoiceid and gje.subledgervoucherdataareaid=vij.dataareaid
#1
André Arnaud de Cal...
294,161
Super User 2025 Season 1
#2
Martin Dráb
232,942
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
