Question
A transfer order is raised to replenish products from the Warehouse to the store. If enough inventory is not available, Warehouse partially fulfills the TO. The remaining items in the TO end up in back orders and remain locked to the TO. When more quantity comes into the WH, the backorders in older TOs get committed first, and thus, these newly received quantities are not available for use in newer TOs, resulting in a lot of reallocations.
Currently to avoid this, if a TO is partially fulfilled, either we have to manually edit the partially fulfilled TO and mark individual items as CLOSED for items that have 0 qty fulfilled. For items that have at least 1 qty fulfilled, NS allows to CLOSE that item line only after the IF is received (only when IR is creating). This is a very time-consuming process.
Eg: There are 10 items for an item in TO. It has 7 available and so 3 back-ordered. User fulfills for a quantity 6 and then sets a custom field value as completed when we close the order. Now there are 3 Backordered+ 1 committed qty which has to be closed but I guess Netsuite doesn’t allow to do the same unless an item receipt is created for that but for me, I would like to close the lines once the IF is created. IS there any standard way for it or any preference?
Answer
documented in SuiteAnswers 27996, a line on a transfer order can be closed only if the in-transit quantity is zero.
This is standard behavior of the system for Transfer Orders. The ability to close transfer orders even when there are quantity’s in transit is currently requested in Enhancement # 233320.