Inventory Closed after New Year Transactions

(0) Share

Report

Posted on by Community Member

The users just closed inventory so, needless to say, the beginning of the year and amounts sold amounts are not correct as the 1st 2 weeks of the current year were closed with last year. Is there a way to correct those amounts? Thanks!

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

L Vail 65,271 on at

Like (0)

Report

RE: Inventory Closed after New Year Transactions

Mahmoud,

I thought the close of inventory was the same regardless of the system date. When you hit the close button it simply emptied one bucket and started another. I do not think it is date sensitive. To my knowledge, the only way to 'correct' this is to use the transaction tables to update the item quantities table ( iv00102).

I tried changing the system date, but the close results were the same in my Fabrikam test. Did you do anything else to achieve other results?

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Inventory Closed after New Year Transactions

Thank you for your response.

Unfortunately, restoring is not an option as this client has a perpetual interface that processed transactions for almost a day before they noticed the issue.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Inventory Closed after New Year Transactions

If you mean the "Quantity Sold" field gets to zero at the inventory closing, that's correct. Closing inventory will result with having this field and others to zero.

You should have considered changing the system date before closing inventory in order to exclude the "quantity sold" of the first two weeks of the new year.

If you have a recent backup, I would recommend restoring your Dynamics GP into the most recent backup just before the Inventory Closing, and changing the system date then re-closing your inventory.

Of course there are other suggestions which may consider updating the fields to exclude the quantities of the new year, but that absolutely need thorough calculation and analysis.Therefore, the restore would be the best option for me

Was this reply helpful? Yes No