Inventory Problem

Navi_Learner

Does anyone solve this problem for me? Our current problems is when the customer orders for instance 300 pieces of one item, Physically we don't have it in stock. The orders will be shipped from factory and usually it will take about 7 days. But during this period of time, when the other customers order the same item , we don’t know the exact inventory in our warehouse and in the sytem it still shows 300 pieces until the accounting department does the invoices when they receive the order shipped from the factory several days later. So usually when we send the order to the warehouse and find out we don’t have any inventory in stock, but the order is placed. That’s a very serious problem. Does anyone know how to solve this problem. Thanks in advance!

ara3n

have you tried reserving the items?

kriki

You can also check Item Availability (Sales Order=>menubutton Line=>Item Availability by=>Period.
With this form you can see how much and when you are selling and how much and when it will arrive in the inventory.

Navi_Learner

BTW would you please tell me how to reserve the items?

Navi_Learner

We have item Availability, but the number is not correct. Any good way to solve this problem

themave

Here is how I would handle it. In version 4.0

on the sales order the line for the 300 items, enter the purchasing code of "Drop" for Drop shipment.

then on the purchase order that you create on the shipping tab, enter the "sell to customer" that is on the sales order.

then go to the order button, and select drop shipment --> get sales order. Select your sales order from the list box, and it will pull that item into the purchase order and associate it with the sales order.

you will find if you go back the sales order the Item availablity will be correct now. as the amont on the sales order and purchase order will offset each other and only any remaining inventory will show as available.