Report or view linking Product Purchase item charges to the respective Sales transactions that is updated

(0) Share

Report

Posted on by Ola Darwish

907

I m looking for a view or a report that links the Purchase item charges (ex. landed cost) that are recorded after the Inventory has been received and some of it sold

so for example PO 001 was received for Item ABC and sold to 3 customers (sales Invoice 1, sales invoice 2, sales invoice 3)

Then after that Item charge (landed cost) invoice came from the vendor and applied to its respective PO receipts and creating all necessary value entry and updating the cost of good sold on the already posted sales invoices.

is there a report/view that links the landed cost to the sales invoices that it has updated. so it can answer the question, landed cost invoice 1 updated which sales invoices COGS and how much did it updated each sales invoice line.

Thanks

Ola

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (1)

Verified answer

Ola Darwish 907 on at

Like (0)

Report

RE: Report or view linking Product Purchase item charges to the respective Sales transactions that is updated

Thanks Steven
Suggested answer

Community Member on at

Like (2)

Report

RE: Report or view linking Product Purchase item charges to the respective Sales transactions that is updated

Ola,

There is not perfect report showing the breakdown of the Charge(Item) to the Posted Invoice. You could create one in Jet Reports. After you post your Landed Cost to the purchase receipts, BC will record a Value Entry for the additional Direct Cost of the Item Charge.

When you sell the Item, you can see in the Value Entries, the original Cost and affiliated Landed Cost entries being posted:

Hope this helps.

Thanks,

Steve