web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Inventory Reconciliati...
Microsoft Dynamics GP (Archived)

Inventory Reconciliation with GL

(0) ShareShare
ReportReport
Posted on by babubaskaran@outloo... 12

Hello There I am trying to reconcile my Inventory balance with GL and each time I am getting big and small difference.  The table I am using IV10200 in order to get transaction wise inventory balance and we are using FIFO Perpetual Valuation method.  I am not sure where I am going wrong.  Thanks in advance :-)

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Babu

    I would have a lot to say about this issue. To get a clean inventory with no corruption, several steps are required to match inventory internally and externally. Although, I will include the way to match inventory versus General Ledger specifically regardless of all associated factors.

    • In GP 2013, the reconcile utility matches inventory versus GL on an inventory account level. Otherwise, the following script on GP Essentials Blog - Inventory versus General Ledger  Shall do the job and retrieve all potentially match and unmatched journal entries per inventory account number.
  • Community Member Profile Picture
    Community Member on at

    Babu, you didn't say what version of GP you are using.  We use the HITB report which pulls data from the SEE30303 table in GP2010.  -Trevor

  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    You can take the hard way or the easy way. The best reconciliation tool in the market is The Close by Reporting Central.

    reporting-central.com/the-closer

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Mahmoud, that's great we use GP 10 version so I will try the script and let you know.  I tried HITB but it didnt help much.  I Marino i will look into the reporting central and check the same.  Thanks to all of you.

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    There is one major issue with average and/or any of the Perpetual methods, selling below zero.  If you have a sale waiting and the shelf is empty, the product arrives and is shipped and invoiced before it is received, your inventory will go negative.  As it does, GL is credited for the last known cost of the items from the item master.  The PO receipt will then set a new cost entirely and debit GL at the new cost.

  • AndreaIES Profile Picture
    AndreaIES 1,005 on at

    Mahomoud,

    I tried the SQL view to compare the IV to GL and I think I don't know how to read it. I was expecting to see the comparison between IV transaction and GL entries. I see all the JE# and other info for all transactions that affected the IV account but I don't see the IV side.


    How can I add to that swl view of yours the IV transaction header info (Type, document number, date, site, etc.)? I appreciate your reply.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    The comparison should be made on a journal entry bases, that's the link between the GL and IV.

    You can take the un-matched  journals and look for inventory-associated details such as location, document type, document number ...etc from the SEE30303 table (inventory table)

    Your feedback is highly appreciated,

  • AndreaIES Profile Picture
    AndreaIES 1,005 on at

    Based on this screenshot below. What are the unmatched Journal entries? Is it not matching for any? If is all GL information, how can I look for the IV items associated? I consider this greatly helpful but I need to understand how to get the differences.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    The journals on the left side of the screen shot (35361704, 35201542 ...etc) exist in GL with no source documents in the inventory module. To track them down, you can either check them manually from (Inquiry > Financial > Journal Entry inquiry)

    Or you can check them in the GL20000 (Open Year Journals).

    On the other hand, you have two records in the inventory module with no associated journals on the GL level, you may check the document details such as document number, type, item, cost, location ..etc by running the script below:

    SELECT * FROM SEE30303 WHERE JRNENTRY = 0 and IVIVINDX = 1618


    Your feedback is highly appreciated,

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

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans