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

Linking Posted Purchase Invoice Lines to their associated general ledger postings

(0) Share

Report

Posted on by johnbeech

Hello! I am looking to build a report that shows direct material price variance by item throughout history. In order to do this accurately, I need to be able to link the general ledger entries posted to the direct material price variance account to their associated posted purchase invoice line (in the circumstance the entry was derived from a purchase invoice). This will allow me to derive the item information, which is what I am interested in.

If I attempt to do this report using the posted purchase invoice lines data directly, then I run the risk of not calculating the correct purchase price variance for a historical purchase invoice because we may have changed the standard in the meantime.

I am fairly new to using business central data, but it seems this should be possible since the standard cost is at an item level and the posting into that account occurs at the item level. I have only found ways to link the data through the document # (aka the posted purchase invoice).

Any help or guidance is much appreciated! Thanks!

All responses (2)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report
RE: Linking Posted Purchase Invoice Lines to their associated general ledger postings

John,

Have you tried running the Inventory - Cost Variance report, for Standard Cost Costing Method. When you filter on Purchase Entries you can see the Invoice document and Vendor.

Report shows Variances recorded for Inventory Transactions. Suitable for items with standard costing

Report only considers Item Ledger Entries of type: Purchase and Positive Adjustments

When taking values from Purchase entries

Filter Item Ledger Entries to Entry Type: Purchase

Navigate to the Value Entries

3. Filter Value Entries where Document Type: Posted Purchase Invoice

Filter entries when Entry Type: Direct Cost

Take the Cost per unit from the entry

Hope this helps.

Thanks,

Steve
Suggested answer

Marco Mels on at

Like (0)

Report

RE: Linking Posted Purchase Invoice Lines to their associated general ledger postings

Hello,

We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

dynamicsuser.net/.../developers

I will open this up to the community in case they have something to add.

Thanks.