Hi NAV experts,
Just wanted to start a discussion on the interrelationship among Sales Order, Requisition Worksheet and Purchase Order. I was wondering if any one of you ever came across this business requirement.
This is not uncommon in wholesale sector, where indent Sales Orders are received from retailers after the selling period and Purchase Orders are raised and placed to a few vendors/factories locally or overseas.
Our company is in the fashion (color and size) industry and we handle at least 3000 new UPC/EAN-13 bar codes every season (250 styles * 8 sizes * 2 colorways). The Req. Worksheet, while a good place to plan purchases based on actual demand (Sales Orders), it can only be used to manually enter quantity and Req. Lines are strictly copied from Sales Lines. Navision seems to have assumed a one-to-one mapping down to the lines when calculating plans, which is very time-consuming for users if the quantity has to be manually adjusted in every line. Considering we have over 120 customers and we usually create 3 to 4 Sales Orders for each customer (for different Shipment Dates) and each order has on average 50 line items/item variants.
We invested in Navision hoping that it would at least be smart enough to provide some sort of order consolidation functionality at a mouse click, only to discover there is none.
What we were after was a conceptually very simple solution - to be able to raise Purchase Orders based on Sales Orders. This makes sense because Sales Orders + Sales Forecast always drive Purchase Orders and it is definitely not a company-specific requirement.
In the end we had to implement an algorithm in a codeunit which can combine quantities of the same Item in Sales Lines into a single Requisition Line before we Make [Purchase] Order.
Is there any powerful feature in Navision we haven’t discovered yet?