Hi everyone, I have one following requirement/problem: “*If one Project has multiple Sales Orders and the customer makes a lump-sum payment, we cannot allocate the payment received against a specific Sales Order.*”
Our understanding is that the transaction flow is: Project → Sales Order → Invoice → Customer Payment
For example, suppose a Project has:
• SO-001 → ₹10,000 → Invoice-001
• SO-002 → ₹15,000 → Invoice-002
• SO-003 → ₹25,000 → Invoice-003
If the customer makes a lump-sum payment of ₹20,000 without specifying which SO the payment is for, the payment is applied at the Invoice level, but there is no direct way to identify/allocate the payment back to the relevant Sales Order(s). We are trying to understand the best way to handle this requirement in NetSuite.
One approach we are considering is to store the related Sales Order number on each Invoice in a custom field, and then make that SO reference available in the Customer Payment → Apply sublist next to each Invoice. This would allow users to see which SO each payment application relates to.
However, we are not sure whether this is the best approach, or whether there is a better standard NetSuite functionality, configuration, or customization that can handle this scenario. What would be the recommended approach to solve this requirement? How have others handled similar cases where a lump-sum payment needs to be associated/allocated back to the relevant Sales Order(s) when multiple SOs exist under the same Project?