add customer/vendor in Ledger Transaction List Report

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Hossein.K 6,648 on at

Like (0)

Report

Hi VDY,

Your problem is solved?

Do you try Transaction origin report in module GL?

Was this reply helpful? Yes No
Suggested answer

Hossein.K 6,648 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
MYGz 2,199 on at

Like (0)

Report

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.

Was this reply helpful? Yes No