“Item Charge Assignment detail against Purchase Invoice” report development in BC D365

Item Charge Assignment detail against Purchase Invoice:

(1) In this blog we will see how to develop or fetch information of Item Charge Assignment detail against Purchase Invoice.

(2) For fetching information of Item Charge against Purchase Invoice, use Dataitems: Value Entry as IC_Value_Entry, Value Entry as PI_Value_Entry and Purch. Inv. Line as shown below.

fetching information of Item Charge against Sales Invoice
fetching information of Item Charge against Sales Invoice use Dataitems

(3) Add Export to excel functionality feature for exporting the report (already explained in the previous blog “How to export data from report to excel”) as shown.

Header Part:

Add Export to excel functionality header

Body Part:

Add Export to excel functionality feature body part

Export Data Part:

Add Export to excel functionality feature export data part

(4) After doing the above development, publish the report and run it in BC D365 as shown.

publish the report and run it in BC D365

(5) Apply filter as per the detailing and run the report as shown.

Apply filter as per the detailing and run the report in bc d365

(6) Report generated in excel as shown.

report generated in excel

Sales Invoice Report Format and Development in D365 BC
How to Check Installed and Uninstalled Extension in D365 BC
Creation and Usage of FilterPageBuilder in BC D365
How to Fix WORK DATE issue in D365 BC
How to add or show new field in existing Page in D365 BC
AL Control Statements– Microsoft Docs

Leave a Reply