Item available stock issue

(0) Share

Report

Posted on by raff

1,236

i have a finished product (item we will sell) that is showing me 3960 In stock but only 552 available due to reservations

we have checked everywhere ( transactions manage stock) but i can see nothing that is reserving this item

it is also strange that i can put a stock transfer on for this item with auto reservation, and it does not give me an error that there is insufficient stock until i go to ship the transfer, it then tells me i dont have enough stock

i am worried that maybe some one has uploaded dodgy data or changed the item code as this is a new implementation

anyone any ideas where to look or what to look at?

mal

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Raff, Have you checked any transactions of this item in other companies? Ludwig

Was this reply helpful? Yes No
venkatesh vadlamani 3,180 on at

Like (0)

Report
Copy link

Link copied!

Suggestion would be to take a DB back up on to some other test environment and run database consistency check and inventsum rebuild process

Was this reply helpful? Yes No
Verified answer

Rahul Shah 2,696 on at

Like (1)

Report
Copy link

Link copied!

It is difficult to judge what has caused this issue and sometimes we see inconsistencies in the transactions - for example on order inventory without the transaction.

In order to remove this inconsistencies, there is a in built utility under the System administration => Periodic => Database => Consistency check.

Ideally it takes longer time to get completed but you can just filter to run it for Inventory management module only.

Please have a look at this image as well : screencast.com/.../wySY6F27fn

Regards

-Rahul

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (0)

Report
Copy link

Link copied!

Look at the inventory status and look for the issue status "Reserved Physical" on a filter. Then look at reserved orders (but should not be the case as you have the physical inventory). Then look at picked (out of interest). What do you have in relation to transactions with those statuses?

Was this reply helpful? Yes No
raff 1,236 on at

Like (0)

Report
Copy link

Link copied!

hi ludwig, this product is released only to 1 company

Was this reply helpful? Yes No
raff 1,236 on at

Like (0)

Report
Copy link

Link copied!

hi Rahul

yes this process has released the reservations! thank you

but still for some reason i cant ship the transfer, which is really strange as i now have lots of available Stock!

Was this reply helpful? Yes No
Suggested answer

Rahul Shah 2,696 on at

Like (0)

Report
Copy link

Link copied!

Dear Raff,

Good to know that you were able to proceed little further.

If you have batch controlled product, you can use the batch tracing functionality to trace the blocking transactions for a particular batch or alternatively you need to review the all product transactions to see the possible transactions which may block the inventory from getting transferred.

List of possible transactions includes

- open quarantine or quality order

- manually created inventory blocking transactions

- batch disposition code

In addition inventory must be available physically in order to transfer it so any pending ordered inventory should be received first before they can actually be transferred.

I hope this helps.

Regards

-Rahul

Was this reply helpful? Yes No
raff 1,236 on at

Like (0)

Report
Copy link

Link copied!

it seems the transfer got corrupt some how

even when i deleted the problem line from the transfer, i could not ship the transfer and ax continued to complain about line 2! - which was now deleted??

any how, i setup a new transfer for the items and they have shipped ok

but we seem to have lots of reservation issues of the back of cancelled/deleted transfers!

Was this reply helpful? Yes No
Rahul Shah 2,696 on at

Like (1)

Report
Copy link

Link copied!

Dear Raff,

Can you kindly resolve this question as 'verified' if you do not need further input or help so that other members know it?

Regards

-Rahul

Was this reply helpful? Yes No