You will find new currency fields on the Sales Order (SO) and Sales Order Line (SOL) that calculate the balance due for invoices and proformas. See the table below.  

One new field to take note of is the Overall Total. It was added to hold the full amount of the Order or Item. Previously, if a Subscription Plan was had Installments present, the Sales Order and Sales Order Line used to have the first installment price (Total field) and there was no indicator of the “Overall Total”. The new Overall Total field now provides the full amount of the Order or Item. The existing Total field on the SO and SOL still holds the installment amount.

Page Contents:

Balance Due Calculations:

Balance Due Calculations are defined below

Invoice Balance Due

Receipt Balance Due

Overall Total
+ Amount Refunded
+ Credit Notes and Adjustment

(-) Credits Applied

(-) Amount Paid

Overall Total 

(-) Credits Applied

(-) Amount Paid

Balance Due Calculations Explained:

Sales Order and Sales Order Line Summary

The fields on the Sales Order summarize all parent Sales Order Lines’ balance due calculation fields (i.e. The Amount Paid field on the Sales Order summarizes the Amount Paid on all Sales Order Lines).  

More importantly, the Sales Order Line’s Balance Due calculation is the result of all functions that have happened to the Sales Order Line.  For example, the Amount Paid field summarizes all Receipts related to the Sales Order Line.  

With this in mind, you should NOT manually update these fields.  These fields will calculate payments applied, adjustments, credits applied, and refunds.  If they have not been calculated correctly, it is possible that the functional records that these fields summarize have not been posted. So, always check the related records first to see if they are correct.

Adjustments

Adjustment Lines that have a parent Sales Order Line (positive or negative balance) will update the Adjustment field on the parent Sales Order Line as the system assumes this is an adjustment to the parent line.  As a result, the Adjustment Line will not calculate the balance due on its record but on the parent record.

Adjustment Lines without a parent (positive balance) will behave like a new Add On Item to the invoice. It will calculate the balance due on its record.

Currency Fields Schema Updates:

Object

Fields

Sales Order

  • Subtotal (Currency)

  • Overall Total (Currency)

  • Amount Paid (Currency)

  • Amount Refunded (Currency)

  • Credits Applied (Currency)

  • Balance Due (Formula)

Sales Order Line

  • Subtotal (Currency) 

  • Overall Total (Currency) 

  • Amount Paid (Currency) 

  • Amount Refunded (Currency) 

  • Credits Applied (Currency)

  • Balance Due (Currency) 

Previous Vs Today’s Behavior

Previously

Today

Balance due was calculated only on the Invoice and Invoice Line objects

Balance due is calculated on the Sales Order and Sales Order Lines objects.

Related Pages:

Installments: Functionality Update

Installments: Display Update

Schema Updates