Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Variance inventory account

Posted on by 455

Hello friends, can you help me whit this?:

When i post a batch from SOP whit many documents, the GL creates two batches. One of this batches uses the variance account and record some of the documents in the batch, i knew this account fixes transaction variances in a phisycal count. But i don't know why GP separates this SOP batch in the GL?

Thanks

*This post is locked for comments

  • Edgar Figueroa Profile Picture
    Edgar Figueroa 455 on at
    Re: Re: Re: Re: Variance inventory account

    We try what you tell us, but the problem continues.

    The accounts setup in the Inventory Card window are the same for the inventory offset account and the variance account.

    We also note that there is two adjustment transaction at the end of the year (One of them with positive quantities, an the other one with negative quantities and the same cost). I don't know if this may cause the problem? Because when we post a sales batch, the system generate the purchases receipt update report and there is where indicate the DG journal entry.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Re: Re: Variance inventory account

    First thing to try--remove the enhancement and see if the strange posting still occur.  You need to edit the Dynamics.SET file.  Make a backup first.  Reduce the number at the top by one.  In the first section, find the pair of lines that refer to your enhancement and delete them.  In the bottom section, find the three lines that refer to your enhancement and delete them.

    If the problem is fixed, call the enhancement vendor. 

    If not, then look at the accounts setup in the Inventory Card/Accounts window.  Tell me what they are...

  • Edgar Figueroa Profile Picture
    Edgar Figueroa 455 on at
    Re: Re: Variance inventory account

    Thanks, we are using version 10, whit SP2.  There is some third party programs installed. The SOP Setup window is configurated with de posting accounts from the item. The accounts are set correctly.

    This issue started like one month ago.

     I'll try to look the information in those books.

     

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Variance inventory account

    What version of GP are you using (V8, 9, 10?) and what service pack?  Also, do you have any third party programs installed?

    Un-modified GP gets it's SOP posting accounts from either the customer card or the item card depending on a setting in the SOP Setup window.  How is that set?  Look at the accounts associated with the customer or item (depending on the setting in SOP Setup) and look at the fields that hold the variance account.  Are these accounts set correctly?

    If there are no accounts in the cards, then GP pulls the accounts from Posting Accounts Setup in Administration.  Are these setup correctly?

     

    Post back the answers to these questions so we can help you better.  You may also want to look at two of our books that explain how SOP uses GL accounts:  Inventory Flow and Posting and Understanding Sales Order Processing.  Visit our web site to check them out.

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans