1,455
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
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
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
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
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (