web
You’re offline. This is a read only version of the page.
close
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 GP (Archived) / Differences between In...
Microsoft Dynamics GP (Archived)

Differences between Inventory and GL

(0) ShareShare
ReportReport
Posted on by MSOBKY 84

Hi,

I have customer work on GP 2010 which have Issue in two warehouses and that the smart list for Inventory, Financial and Warehouse Account summery provide with same values and the Inventory reports which related to activity (standard and customized ) provide with different value per period.

they use FIFO Periodic

although we check all transaction posted and related to inventory and matched with GL  in smart list and they didn't make any change in their cost also we conduct check links

other warehouses is working well without any Differences

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi,

    You don't mention it, but have you tried to run a reconcile against the Inventory module.. ? often times the inventory gets out of balance due to some operations in GP and than the inventory value doesn't match with the financials.

  • Ken Roy Profile Picture
    Ken Roy 490 on at

    If you are using the Manufacturing module, the routine Reconcile to GL doesn't always work.  

  • MSOBKY Profile Picture
    MSOBKY 84 on at

    at the beginning customer using Manufacturing module

    also I run the GL reconcile and still the numbers as is

    beside that i tried to run reconcile for inventory module but not working I get message that i can not complete the process while invoices are being posted    

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    This is correct..

    You can only run the Inventory Reconcile if no users is in any window related to inventory (purchasing, sales, inventory, mfg, etc..).

    The best, if you have a large inventory, is to run the reconcile outside of business hours.

    We do typically run this during a scheduled job at night when nobody is logged into GP.

    With an inventory of about 14k in our main company, it takes about 60-75 min to complete.

    PS: if you have a very large inventory, you can split the reconcile by using a defined range of items..

  • MSOBKY Profile Picture
    MSOBKY 84 on at

    I run the Inventory reconcile and still the number as is

    and I have a critical situation  with the customer and i don't know how to handle that issue

  • Ken Roy Profile Picture
    Ken Roy 490 on at

    If this is a critical situation, I would open a ticket with Microsoft Support.  

    In my case, I've had the Stock Status reports for an Inventory account not match the GL code for that account.  I've found that comparing the Distribution History Report by date and Audit Code in Inventory Control against the same GL code and Date In Detailed Trial Balance Financial Report.  This can be difficult if you don't know the exact date or narrow the date range down.  

  • Rosemary Profile Picture
    Rosemary 10 on at

    Hi,

    If the Reconcile didn't highlight anything, just a couple of questions, did they run a Financial Trial Balance and match what is there with the sub ledger?

    Is there a Historical Inventory Trial Balance in GP 2010?

    From what you said, there is an account for the warehouse?

    In terms of operations what is different with the warehouse that balances compared with the ones that doesn't?

    Regards,

    Rosemary

  • MSOBKY Profile Picture
    MSOBKY 84 on at

    Financial Trial Balance is equal with the GL in inquiry, smart list but not equal with the inventory reports-Activity-such as Historical Stock Status

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Have you checked out this thread ?

    community.dynamics.com/.../110575

    HSS & HITB are 2 different ways of getting your inventory value, but one might be inaccurate against the GL TB..

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    Beat is giving some good advice here.  The reference to Mahmoud's article is a good place to start.  We had a tough situation a few years back, and I wound up writing the following blog article about the issue.  It covers how to identify inconsistencies and what resolutions we used to clean them up.  The Reconcile was the first step in the process:

    redbeardblogging.blogspot.com/.../hitb-quanity-on-hand-vs-inventory.html

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans