Problem Statement:
When using NetSuite 3 way matching, partial receipts/bills and multiple Vendor Bills against a single PO is not supported. What alternatives do the NetSuite Employees suggest? Is scripting the only option?
Explanation:
This limitation is covered in the enhancement request logged on Enhancement # 412077: 3 Way Match Vendor Bill Approval Workflow > Match Bill to Receipt = T > Bill Purchase Order that is partially Received > Discrepancy between the Quantity on Bill and Item Receipt exceeds the Item Quantity Tolerance limit.
Upon checking the enhancement request details, there are no other documented workarounds aside from receiving all the items in PO and billing only once.
For instances like these where the workaround will not be applicable to you, the next suggestion would be to explore custom solutions through SuiteScripts and/or SuiteFlows.
Solution from oracle community:
“We were able to create a process and script where we allowed 1 line with a single receipt that would match. So if a po has 20 lines, it can have 20 receipts – 1 receipt per line – and we were able to get the 3 way match to work. For my client, this process worked.”