Small and medium business | Business Central, N...

Invoice (1306 or equivalent) to show Payment before terms with discount amount

(1) Share

Report

Posted on by LizHK

144

I have been asked to replicate something like this and add it to our invoice - as per payment terms.

If account is current and this invoice is paid within 10 days from XXXX, you may deduct a 2% discount of $--- and pay only $---. (different payment terms)

I cannot find this from the posted sales header - only payment terms but I find this from Customer Ledger Entries.

Can someone kindly guide me through the best way to achieve this through development?

I'm guessing there is no easy way and it's only achievable through AL development.

However, I'm starting to learn AL but my knowledge is very limited so if someone guide me the easiest way to achieve this, that'll be really appreciated.

Thank you,

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Suggested answer

Valentin Castravet 24,976 Super User 2024 Season 2 on at

Like (0)

Report

Invoice (1306 or equivalent) to show Payment before terms with discount amount

If the discount percentage is always constant, you can technically hardcode it directly into the layout. To do this, you can modify the RDLC layout of the report to include the text blurb shown in your screenshot. This way you won't need to use AL.

However, the best practice is to add a new field to the report dataset using AL to represent the discount percentage. This is required because as you discovered its not a standard field in the report. Once the new field is added, update the RDLC layout to include both the text blurb and the dynamically generated discount percentage field, and amount fields.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Suggested answer

Khushbu Rajvi. 5,288 on at

Like (1)

Report

Invoice (1306 or equivalent) to show Payment before terms with discount amount

To include a discount payment message on an invoice in Business Central, you'll need to calculate and display the potential payment discount based on the payment terms.

hope this helps:

https://learn.microsoft.com/en-us/training/modules/report-extensibility/

https://learn.microsoft.com/en-us/training/modules/work-with-reports/

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-report-ext-object

https://yzhums.com/1958/
Suggested answer

Jun Wang 7,459 Super User 2024 Season 2 on at

Like (0)

Report

Invoice (1306 or equivalent) to show Payment before terms with discount amount

You could have a dev to create a custom report for the sales invoice displaying the payment terms and discount.