Net Adjust
This field displays the line item net adjustment that displays on the adjustment invoice, if not zero.
The system calculates Net Adjust as follows:
NA = NN ON
where:
- NA = Net Adjust
- NN = New Net
- ON = Old Net
An unsigned amount indicates additional payment is due from the customer. A negative amount means a refund is owed to the customer.
If after changing the New Disc, New Price and To Adjust and rounding, the Net Adjust comes out to zero, the adjustment line Item does not display on the adjustment Invoice. Also, the New Disc and New Price are not posted to the CO line item. The system effectively ignores it.
Even though the net adjustment amount is what displays on the Invoice, the actual amounts the system posts to the GL distribution when the adjustment Invoice prints, depends on how the Discount and Unit Price have changed. The amount posted to the sales account is rounded as follows:
APSA = NP OP * TA
where:
- APSA = Amount Posted to the Sales Account
- NP = New Price
- OP = Old Price
- TA = To Adjust
The amount posted to the Sales Discount Account is calculated as follows:
APSDA = NA - APSA
where:
- APSDA = Amount Posted to the Sales Discount Account NA = Net Adjust
- APSA = Amount Posted to the Sales Account
The discount value stored with the invoice history is not the new discount, but the effective discount that created the above posting is calculated as follows:
EDCP = (APSA - NA) * 100 / APSA
where:
- EDCP = Effective Discount that Created the Posting APSA = Amount Posted to the Sales Account
- NA = Net Adjust
If the unit price does not change, the system sets an unknown (?) value.