[Resolved] Moving reserved stock between locations

Toddy_Boy

Hi Guys

I've been asked to to acheive the following and need a little assistance:

User puts on a sales line to be shipped from a location (The Warehouse). If the amount of stock available at the that location cannot fulfill the sales line then the sales line is split into a number of lines where the sales line can be filled from various locations. Then using transfer orders create new lines to represent the in transit location with stock reserved at that location for shipping, then on receipt of the transfer merge the sales lines reserving stock at the locations as we transfer.

e.g. 500 widgets are required, there is 200 in the Warehouse and 300 in the factory so the line is split into 2 seperate lines with the relevant locations, so the result would be

Qty 200 Location Warehouse
Qty 300 Location Factory

- that bit works \:D/ - reservation table confirms this


When transferring an order e.g. From Factory To Warehouse Via Train the user wants an intermediate line to be created with a location code of Train with the stock being reserved at the Train Location, so if 100 widgets are transferred then the result will be 3 lines

Qty 200 Location Warehouse
Qty 100 Location Train
Qty 200 Location Factory

Sometimes part of this works in that I can create new a line new for the Train. however, I unreserve stock at the Factory and reserve at the Train location, the reservation table still shows the stock being reserved at the Factory location ](*,)

I'm using the following method:
Transfer Order from Factory to Warehouse In-Transit Train for 50 widgets
Fully unreserve the Factory sales line using ReserveEngineManagement.CloseEntry for the sales line.
Reduce the quantity on the Factory sales line to 100 - 50.
Reserve the Factory sales line using ReserveManagement.SetSalesLine and ReserveManagement.Autoreserve.
Create a new sales line for Qty 50 at Location Train
Reserve the Train sales line as above.

I do get errors such as The Widget is not on Inventory, Reserved quantity cannot be greater than -250 and when it does work stock seems to be reserved at the Factory and not the Train even though the locations on the sales lines are correct at the time of reserving the stock.

I'm a little lost and have very little experience with Navision and could use a pointer or two as to:
1) Is my approach correct or way off base?
2) Why would these errors occur when there is enough stock in the locations?


Sorry for the long post, any help much appreciated

Steve

This has been resolved, many of the errors have been cured with microsoft hotfixes.