Hello All,
I have got requirement to add Customer or Vendor name in Ledger Transaction List report. GL->Reports-> Transactions -> Ledger Transaction List Report.
This report fetches data from all the type of journals and i want to show customer/vendor based on transaction belongs to whomever.
Can someone please guide how to get customer/vendor here on this report?
*This post is locked for comments
Hi VDY,
Here's my 2 cents:
You are right that LedgerPostingType is big, but you would only be having few entries in GeneralJournalAccountEntry.
Check all the postingtypes present (run in SSMS or create x++ query), "select distinct postingtype from GeneralJournalAccountEntry" and then figure out your conditions to edit in ReportDP class.
You have to edit ReportDP class, (ui,contract,controller if required), ReportTmp table and SSRS report to achieve the customization.
Hi VDY,
You could apply filters to the report to get the data you are looking for.
The report basically shows you what you can identify when you are opening a voucher and then click transaction origin but it shows this for all kind of transactions selected/filtered.
You can check if this report works out for you.
If it does not, you have to create something that fits your requirements better.
Best regards,
Ludwig
Hi Hossein,
Thanks for your suggestion. I have looked into Transaction Origin report and it just use the same subledgervoucher and accountingdate to identify custtrans , vendTrans etc.
My question is how does it know if it's credit note or expense or any other kind of transaction?
Don't we need to use PostingType field from GeneralJournalAccountEntry table to make a join to CustTrans only for those types that belongs to Customer transactions?
If so, How to determine which are related to customer and which are related to Vendor from so many PostingTypes in the Enum LedgerPostingType?
GL->Reports-> Reconciliation-> Specification-> Transaction origin
You may need a report which considers information from different modules. For example: One report that contains the financial transactions of a purchase order linked to a project.
The Transaction origin report can assist in achieving this requirement.
Hi Crispin,
my requirement is to cover all the ledger accounts and is not limited to expense ledger accounts only. Credit note also needs be covered. Voucher may have more than one vendor and i am ok to show first vendor that it returns.
Hi Vdy,
Alternatively, test if the transaction origin report might help. It is available in the GL report reconciliation section and should show you the customer/vendor together with the voucher.
Best regards
Ludwig
Hi VDY,
Management Reporter is able to have the customer and vendor as attribute. Would it be possible to use this tool? If not, you have to check per transaction if there is a customer or vendor transaction and from that transaction use the account number or get the name. This would for sure slow down the processing of this report. For that reason, use a duplicate of the report to customize.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,399
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
