Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Linking Posted Purchas...
Small and medium business | Business Central, N...
Suggested answer

Linking Posted Purchase Invoice Lines to their associated general ledger postings

(0) ShareShare
ReportReport
Posted on by johnbeech 5

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! 

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    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.

    pastedimage1641219992034v1.png

    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

    1. Filter Item Ledger Entries to Entry Type: Purchase
    2. Navigate to the Value Entries
    3. 3.     Filter Value Entries where Document Type: Posted Purchase Invoice
    4. Filter entries when Entry Type: Direct Cost
    5. Take the Cost per unit from the entry

    pastedimage1641220045065v2.png

    Hope this helps.

    Thanks,

    Steve

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans