Hello experts,

the situation is as follows:
When I'm trying to confirm Sales Order(Manual) and click on button "Generate Advice" occur the following massage: "Insufficient inventory for item P21253 in warehouse 804". In session whwmd4100m100 for this item
On hand:30 m, allcated 30 m.

Anybody have any idea how to solve this problem?

Thank you in advanced!
Borislav

Hi,

Check in the Planned Inventory Transactions for that item if there are any planned issue transactions.

There can be Outbound advice's which are not yet picked, there might be some Warehouse Orders which are not yet processed, there might be some production orders to which the material is allocated but not issued i.e. in the to be issued state.

If everything is fine, use Rebuild Planned Inventory Transactions sessions to correct the inconsistencies.

Hi Bhushan,

thank you for your quick reply,
when I checked in the Planned Inventory Transaction I saw only the same order line 920 in the same Sales(Manual) WHO008265 that can't confirm.
I have run the session that you told me Rebuild Planned Inventory Transactions (whinp1200m000) but nothing happens.:confused:


Reagrds,
Borislav

Hi,

Ok I got it. Delete the outbound advice, create new line, when you go to lot code field, do a zoom and select a lot. Go to transaction date and select a transaction date where inventory exists.

It happens because, on the date-time you have given on the outbound line, no inventory exists. Change the date and its done.

HI Bhushan,

I understand you, but the date-time that I have given is 30.03.2013
inventory exists on 26.06.2009
For this item quantity was 33 m, with sales (manual) WHO008265 I issue only 3 m with date 30.03.2013, but another 30 m I can't.

Hi,

Check the date in Stock Point inventory and use the same date and time.

Hi Bhushan,

I tried what you told me but again nothing happens.:confused:


Regards,
Borislav

Hi,

When you create a new line in Outbound advice and zoom to the lot code, get a screen shot and attach it. Check the date and time for that lot and also check what is the inventory in hand, blocked, allocated. If its still showing quantity in allocated after deleting the present line, there might be some pending advice's.

Also, try running check and repair inventory in simulate mode and see if it shows any inconsistencies.

HI Bhushan,

Before I created a new line in outbound advice the inventory for this item in session whwmd4100m00 is:
on hand - 30 ; economic - 30;
after created a new line :
on hand - 30 ; allocated - 30;
(you can see in a attched file)

I hope I've explained properly.

Regards,
Borislav

Hi,

You create a new line. Now, create an Outbound advice. Make sure you can view Lot & Inventory Date fields. Now, create a new Outbound advice. Don't use "Generate Outbound" instead create it manually.Select a lot and check its inventory date and quantity in session Stock Point Inventory (whinr1540m000) and put the same date and quantity in your Outbound advice line.

You might be missing something. Also try check and repair inventory session and run it in Simulate mode.

Hi Bhushan,

I done what you told me, and when I click on the "Release" button occur the following message:"Outbound order line (Sales (Manual), WHO008265 - 1/920-1): Negative inventory not allowed".

I saw the check repair inventory session, but I've never used it before. What did mean "Simulate mode",. without check "Update Mode"?

Reagrds,
Borislav

Hi,

Check and repair checks for the inconsistent data in a few inventory tables and gives you are report if there are any inconsistent entries. If you run it in simulate mode, it will not correct the inventory in those tables but only give you the report about it. If you run in update mode, the data in the tables will be changed.

I will advice you to run it in simulate mode first.

Also, check these things once again:-

1. Check if there are any Outbound advice's against that item in session Outbound Advices (whinh4525m000)
2. If yes, delete them and recheck the stock point inventory for the item if its showing allocated or not.
3. If no, try creating a new advice as I mentioned with proper lot code and inventory date appearing in the stock point inventory for the item and lot.
If its still showing allocated inventory in stock point inventory for the item and lot, run the session check and repair inventory for the item and the warehouse in simulate and see if prints any report.

A way to run it is as shown in the snapshot.

Hi Bhushan,

I checked everything you told me and finally I decided to run the session "Check and Repair Inventory" in update mode and correct differences. Тhen allow me to process the order.:)

Тhanks for your advice, it was very helpfull to me!!

Best Regards,
Borislav

Glad that it worked. :)