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) / Would reconcile invent...
Microsoft Dynamics GP (Archived)

Would reconcile inventory create GL entries?

(0) ShareShare
ReportReport
Posted on by Deborah Bergman 1,465

I have a client that is seeing entries come in and post from Inventory after month end closing - the origination is Inventory, but no one claims to make any entries.  Could the reconcile process create automatic entries?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    Most of the reconciliation processes in Microsoft Dynamics GP ensure that the transaction details roll up nicely into the summaries and will not create GL adjusting entries. In fact, the Inventory Reconciliation Report will show you if any quantity adjustments were made, because the assumption is you will use that report to go and create inventory adjustments with it, which at that point and in effect will create GL entries reflecting the adjustments made. In summary, no automatic entries are created.

  • Tim W Profile Picture
    Tim W 2,925 on at

    You might check and see if they have been closing open PO's.  This feature (new for 2013 maybe 15?) would reverse out RNI on PO's by doing a GL entry that looked like an inventory adjustment.  Caught me well off guard when I first saw this. 

  • Suggested answer
    Ibrahim Ghalghay Profile Picture
    Ibrahim Ghalghay 115 on at

    To my knowledge, Reconciliation only matches the records to help you find errors, it does not make any change.

    It is a troubleshooting tool only. It will not make any corrections.

    Best Regards;

    Ibrahim

  • Peter Bailey Profile Picture
    Peter Bailey 84 on at

    Hi,

    I'm wondering if what you're seeing is what Mariano described in http://dynamicsgpblogster.blogspot.co.uk/2009/09/what-do-those-strage-reference-codes-in.html . "As of the release of Dynamics GP 9.0 the system will automatically generate General Ledger adjustment entries for situations where an item was sold or consumed from inventory, but its cost was later changed." At least some of these entries appear in the general ledger as series "Inventory" and again at least some of them get dated to historic periods.

    Incidentally, this behaviour is quite a nuisance for us. Does anyone know if it is possible to turn this behaviour off?

    Thanks

    Peter 

  • Peter Bailey Profile Picture
    Peter Bailey 84 on at

    To clarify my answer above, and to try to explain why I thought it might be relevant to your case -

    We have automated inventory adjustments appearing on the general ledger which we don't want. We see a number of scenarios, but the most common one for us is where an item is sold when there is negative quantity in stock. The sales invoice posts with a cost of the item. Later, someone enters a goods receipt for the same item at a different cost to that on the sales invoice. An automatic adjustment is created for the difference between the cost on the sales invoice and the cost on the goods receipt.

    Our cases are nothing to do with inventory reconcile. However they are (i) automated entries that no-one has entered and (ii) they are often (for reasons that I don't fully understand)  dated in prior months i.e. appear after processing for that month has completed. To that extent, it seemed possible that this is what you were seeing.

    I would like to turn these entries off, but have so far drawn a blank. (In our case the trigger for this is an incorrect negative inventory quantity - and these adjustments created are incorrect).

    Hope that makes more sense now.

    Thanks

    Peter

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