Hi Experts,
I would like to ask the best way to setup a sales order approval
workflow related to the customer credit limit.
Parameters/Scenario:
1. Customer shared with multiple subsidiary, so I created a custom field to store the credit limit value per subsidiary.
2. Only select invoices/open sales orders are considered when comparing the credit limit. We based it off on Department, so if open invoice/open sales order has department A or B then capture the unpaid balance/unbilled amount then sum that up with the other sales transactions that has the same criteria.
3. Example: Customer Credit Limit: 1000
Scenario 1:
Invoice 1010, Department B, remaining balance: 500
Invoice 1020, Department B, remaining balance: 450
Unbilled SO5, Department A: 25
Unbilled SO10, Department C: 100
Total Open/Unbilled: 975
New Sales Order – SO25, Department A: 100
Upon saving, SO25 will be pending approval – for credit check approval
Scenario 2:
Unbilled SO35, Department A: 25
Unbilled SO40, Department A: 100
Invoice 1040, Department B, remaining balance: 300
Invoice 1050, Department B, remaining balance: 450
Total Open/Unbilled: 875
New Sales Order – SO50, Department A: 100
Upon saving, SO50 will be Approved
My main concern is how do I create the comparison since I am not using the standard customer balances fields.
Here are a couple of things I have done so far:
- I created the saved search to filter the transaction based on department
- I created a custom transaction body field that sources the value from the saved search created in 1. Store value is false, Available Filter is set to Customer/Project: Internal ID
- It displays the value of all Sales Order/Invoice regardless of customer.
- So now I can't make the comparison work as it is pulling the wrong dollar value for unbilled SO/open Invoices.