Finance Charge to Invoice Report

(4) Share

Report

Posted on by dmt747400

106

I need to generate a report from Business central that shows what finance charges go to which invoice. Once of the steps in the "instructions" says to locate the "Applies-To ID" this field is not in my Detailed Customer Ledger Entries. Here are the instructions I have below.

Download Detailed Customer Ledger Entries
Download Customer Ledger Entries
In the Detailed Customer Ledger Entries locate
1. Entry No.
2. Document No.
3. Applies-to ID
In the Customer Ledger Entries locate
1. Document No
2. Amount
3. Remaining Amount
Create a Relationship
1. Click Data, Get Data, Combine Queries
2. Merge the two tables using Applies-to ID = Document No.

I can even stress how urgent this is on our end, so any assistance would be appreciated.

Thanks

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

YUN ZHU 95,763 Super User 2025 Season 2 on at

Like (2)

Report

Hi, You may consider using Excel Layout, so that you can use formulas in Excel to complete it according to your needs.

https://learn.microsoft.com/en-us/dynamics365/business-central/ui-excel-report-layouts?wt.mc_id=DX-MVP-5004336&tabs=any-report

Thanks.

ZHU

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,390 Most Valuable Professional on at

Like (1)

Report

Hi

You could rely on the query object for this.

Dynamics 365 Business Central: How to use a query to create a report dataset (Creating Report with Query) | Dynamics 365 Lab

How Do I: Create a Report based upon a Query? – think about IT

Best

GR

Was this reply helpful? Yes No
Verified answer

Steven Renders 5,672 Moderator on at

Like (2)

Report

The link between Detailed Cust. Ledg. Entry and Cust. Ledger Entry is:

Cust. Ledger Entry No. in Detailed Cust. Ledg. Entry and Entry. No in Cust. Ledger Entry

The Applies-to ID is in the Cust. Ledger Entry table.

Was this reply helpful? Yes No
dmt747400 106 on at

Like (0)

Report

So, Steven Renders response answered my question but excel wont merge the two workbooks.

The other two suggestions I am sure will work as well, but I am not a programmer. I find it insane that BC does not have a simple and common quarry like this built in.

Thanks for your suggestions, but I am going to have to do this by hand. Yeah Microsuck

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

We have a preview feature for Excel reports. Please check them out, as they can be really helpful for this kind of analysis

https://learn.microsoft.com/en-us/dynamics365/business-central/ui-excel-report-layouts?tabs=any-report

Thanks

Ramesh

Was this reply helpful? Yes No