web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • 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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans