Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Unit Cost difference r...
Microsoft Dynamics GP (Archived)

Unit Cost difference results from Stock Count Entry

(0) ShareShare
ReportReport
Posted on by manolo 97

We run the stock count process for seven warehouses in production environment, register the counted quantities and process the batch in the Stock Count Entry Window to create variance batches in Inventory module.  We create a report from table IV30701 and compare to IV10001 (Inventory Transactions Amounts Work) and most of the items have different costs (Exhibit A). We use the calculation of variance for IV30701 for register a journal entry in GL in order to complete November closing.

Can you help us to determine what happened with the costs that are not the same? In one of the batches all negative variances take $0 cost in table IV10001, and have the correct cost in IV30701.

Exhibit A:

6320.ExhibitA.PNG


*This post is locked for comments

  • Suggested answer
    manolo Profile Picture
    manolo 97 on at
    RE: Unit Cost difference results from Stock Count Entry

    Thanks Leslie,

    This scenario was sent to Microsoft from a partner that was helping us reconcile INV with GL. Microsoft answer was the same as yours (It is how they designed GP for decrease variances created from Stock Count. Once you post the Variance Batch created by the stock count it will pull the correct cost on the next available layer which will affect the Subledger and the General Ledger. You will see the cost used on the variance decrease on Inventory reports and inquiries it just doesn’t show the cost on the variance decrease transaction until it is posted.)

    I appreciate your feedback!

     

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Unit Cost difference results from Stock Count Entry

    Hi,

    I noticed you are comparing an unposted transaction with a posted transaction. You may be showing zero cost because during setup you elected to not display the cost in a negative transaction. When the transaction is posted, the system finalizes the cost. I wouldn't be making any journal entries based on the balance in an unposted transaction.

    Kind regards,

    Leslie

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans