Inventory closing does not settle all tranactions

(0) Share

Report

Posted on by thojen

A product has onhand quantity = 0. All transactions are financially updated. When closing the inventory the value is adjusted to approx. 100.000 EUR which obviously is wrong as it should be zero also. Inventory model is FIFO, but not all receipts are settled. The inventory value equals the cost value of the not settled receipts. This issue has appeared after the new whs has been implemented and only in a whs enabled warehouse.

Has anybody else had issues with the inventory closing when using WHS? My guess is That the whs work transactions are not beeing handled correctly by the inventory closing.

*This post is locked for comments

All responses (8)

Answers (0)

Guy Terry 28,626 Super User 2024 Season 2 on at

Like (0)

Report

RE: Inventory closing does not settle all tranactions

Hi Thomas,

Thanks for the update. I'm not sure why it helped fix your inventory cost, because my assumption was that the transactions affected by Pre-closing are not important for inventory valuation!
thojen 80 on at

Like (0)

Report

RE: Inventory closing does not settle all tranactions

It looks like you are right about the pre-closing job, and that it has an important function.

I realized, that when I cancel the erroneous inventory closings the inventory transactions for the WHS work were actually not reopened. I made a small job to set ValueOpen to yes on these transactions and ran the pre-closing job and a inventory closing again. Now the value is 0 it is supposed to, so it must be the pre-closing job that made the difference.

Thanks a lot for guiding me to this very important job.

Kind regards

Thomas
thojen 80 on at

Like (0)

Report

RE: Inventory closing does not settle all tranactions

Hi Guy,

Only InventLocationId, InventSiteId and InventBatchId are included in the Financial inventory. In the onhand inquiry I see a cost value and no quantities, when these dimensions are enabled.

I have verified that all inventdim records with licenseplate og statusid have a correct and non-null SHA1HASH value, so that not the reason.
Guy Terry 28,626 Super User 2024 Season 2 on at

Like (0)

Report

RE: Inventory closing does not settle all tranactions

Hi Thomas,

As far as I can tell, the 'Pre-closing' option was added at the same time that the parameter 'Activate closing of non-financial transfers' was removed from Inventory management parameters. Now, any non-financial transfers are ignored by 'Closing', and they can be closed by the 'Pre-closing' job. So you say that some transactions are not getting closed. If they are non-financial transfers, they should be closed by the 'Pre-closing' job. However, you said it makes no difference.

Can you look at the Storage and Tracking dimension groups for the item. Make a note of which dimensions have 'Financial inventory' ticked. Then go to the On-hand inquiry and use Dimension display to enable the dimensions which have Financial inventory ticked. Enable only these dimensions, and enable all of them. (You should also enable any product dimensions that are active on the item). Then look at the On-hand for that item. Do you still see lines with a value?
thojen 80 on at

Like (0)

Report

RE: Inventory closing does not settle all tranactions

Hi André,

The setup of the items were changed when WHS was implemented. Storage dimension Group changed, WHS enabled, reservation and UOM hierarchies added etc. Before items were changed the existing warehouse was cleared totally, inventory closed, and after enabling WHS, the onhand quantities was imported to a journal using a new inventlocationid. The physical warehouse was obviously the same :-)

Kind regards

Thomas
thojen 80 on at

Like (0)

Report

RE: Inventory closing does not settle all tranactions

Hi Guy,

I have cancelled all invntory closings back to the WHS implementation, run the pre-closing job, and made a new inventory closing. It didn't change anything.

Do you know what this pre-closing job should do? I can't find any information about it. I suppose it's a CU9 feature??

Kind regards

Thomas
André Arnaud de Cal... 291,431 Super User 2024 Season 2 on at

Like (0)

Report

RE: Inventory closing does not settle all tranactions

Hi thojen,

Can you also indicate if the setup of your items with this problem were changed due to the implementation of the new WHS? I assume you mean that the WHS software was used and you are not referring to a new physical warehouse?
Guy Terry 28,626 Super User 2024 Season 2 on at

Like (0)

Report

RE: Inventory closing does not settle all tranactions

Did you run 'Pre-closing'? You can find it on the 'Closing and adjustment' form.