Hi Team,
We have the following scenario and would appreciate your thoughts on how best to handle it.
A customer has a Credit Note with a total value of approximately $100,000. The customer has requested that we allocate the credit as follows:
- $20,000 against an invoice generated in Salesforce.
- $80,000 against an invoice generated in an external system outside Salesforce.
Since the $80,000 invoice is not recorded in Salesforce, how can we account for this amount so that it is reduced to zero and the total credit allocation reconciles to $100,000?
We would prefer to avoid creating dummy invoices in Salesforce solely for allocation purposes.
What alternative approaches or standard Salesforce functionalities can we use to achieve this requirement while maintaining accurate credit allocation and financial reconciliation?
Thanks in advance for your suggestions and recommendations.
As far as I know, standard Salesforce Billing only lets you allocate a credit note to invoices (or invoice lines) that exist in Salesforce. So there’s no out-of-the-box way to apply the $80,000 against an external invoice and have it drop to zero.
Here’s what I’d do without dummy invoices:
- Split the credit. Issue two credit notes instead of one: $20,000 and $80,000. Allocate the $20,000 one to the Salesforce invoice as usual. Treat the $80,000 one as belonging to the external invoice.
- Track the external allocation on the credit note. Add a couple of custom fields on the $80,000 credit note, such as “Applied Externally” (checkbox) and “External Invoice Number”. That way the balance is clearly accounted for and reporting can exclude it from open credits.
- Let the system that owns the invoice do the reduction. If the external system is the source of truth for that invoice, the credit should be applied there. Salesforce just holds the record of the credit and where it went. If you want this automated, an integration or Flow can push the allocation to the external system and update the fields above.
I’d go with option 1 combined with option 2. It keeps the Salesforce allocation clean and gives finance a clear audit trail without inventing invoices.
Hope this helps! If it does, please mark it as the best answer.
