Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Purchase price Varianc...
Microsoft Dynamics NAV (Archived)

Purchase price Variance of consumed Batch No.

(0) ShareShare
ReportReport
Posted on by Community Member
Opening Balance upload and Purchase entry
Item Batch No. Quantity Entry no. Entry type Cost Amount (Actual)
x x51 200 210001 Positive 1000
x x51 300 210002 Purchase 2400
x x51 500 210003 Purchase 5500

Consumption (FIFO basis)
Item Batch No. Quantity Entry no. Entry type
x x51 400 210041 Consumption
x x51 400 210052 Consumption

We need to find  the Purchase Price Variance  of the consumed Batch no "x51"  entry no "210041" ??

 

NOTE:

  • Same Item has purchased same  batch no. for multiple times with different cost.
  • Same Item has uploaded as Opening Balance.
  • Batch no. uploaded as OB and Purchased has been consumed combined against a Production order.

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Purchase price Variance of consumed Batch No.

    In this case, you have to go long way to find out the origin entries....

    You need to customize the reports / functionalities to find out the Purchase / Opening balance entries.

    You may get all the reference from Item Application Entries. However please note that, it would be really complex development, as you need to go multiple level up with multiple applied entries.

    That is the only option, unless you use Lot Nos./ Series Nos., where it would be comparatively bit easy...

  • Community Member Profile Picture
    Community Member on at
    RE: Purchase price Variance of consumed Batch No.

    If we select the ILE on th item 210041 > Click Application Button> Applied Entries. it shows only transfer entry to the production location. (entry done just before the consumption not its origin.)

    in our case we purchase item to Receive location and system created automatic Quality Orders,

    after passing QO item will goes to RM-Stores location and the item will issued to Production location against Prod. Order and only after the item is consumed against the Production order.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Purchase price Variance of consumed Batch No.

    Hi,

    You can open Item Ledger Entry form > select Entry No. 210041 > Click Application Button> Applied Entries.

    This would open all the entries applied (Purchase, OB etc.) to this particular entry no. 210041.

    From this you can find out the various Item Ledger Entry No..

    Search this Item Ledger Entry No. and check the "Cost Amount (Actual)" field and find out the actual cost for all the applied entries..

    If you need this in single screen, you can customize some screen or report and get this done via use of Item Application Entry Table.

    Hope this helps.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,430 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans