We are using Navision for Warehouse/Inventory management. We want to integrate Navision with our custom-build Manufacturing system (.Net web-application) in order to record parts consumption.
We have set up NAS, MSMQ and managed to get it all working. We now need to develop a function in Navision which takes a list of Item No. with quantities and bin code and records the fact given items were consumed from the given bin. How can we do that?
Should we post an entry into Item Journal?
Should we post an entry into Physical inventory Journal?
What entry type should we use? Negative Adjustment?
We do not have Production Orders in Navision and our Bins require picks.
Thank you for you attention and we would appreciate any advice/comment/information
I don’t know exactly this case but I know many implementations that are used to implemented 3PL. In those case don’t matter costing since products all have zero value cost. Probably this one of the cases. I guess [^o)]
I have managed to modify the code to post into Warehouse Journal and now it all seems to work. I have created 2 procedures - one to post part consumption and another to get item quantity using Warehouse entry. When I record part consumption using one procedure I can observe correct quantity decrement using another procedure.
However adjustments made in Warehouse Journal are not registered in the Item Ledger automatically. I am not quite sure what is affected as a result of that. Should I extend my procedure to register warehouse adjustments in item ledger when part is consumed? Or should these adjustments be registered manually?
Regarding costing. We repair phones and the cost of the repair does not depend on which parts were used. There are fixed prices for different repair types and some of the more expensive repairs have to be authorised with the customer first. Navision is not involved in that. We use Navision to keep track of parts and order new parts when necessary.