Sales Order Line Amortization Schedule Detail
Navigation
SO Line Amortization Schedules
Fields
Shipper Line: The Shipper and Line Number to which the given amortization schedule applies.
Customer: The Billing Customer on the Sales Order for the amortization of the given shipment.
Product: The Product that is to be amortized. Note that a Product must be an "Amortization Candidate" (set on the RS Product Master) to generate an amortization schedule (in conjunction with SO Order Type).
Sales Contract: When a Sales Order is associated with a Sales Contract (optional), this will be set to the Sales Contract referenced on the Sales Order Header for which this Amortization Schedule applies.
Quantity Sold: The quantity "packed" (when using Pick/Pack/Ship for fulfillment) or shipped (when using Consolidated fulfillment). This quantity is the basis for calculating the amortization amount.
Shipment Date: The date that this shipment was packaged (Pick/Pack/Ship fulfillment) or shipped (Consolidated fulfillment).
Total Sales Amount: The total value of the Shipper Line, which is calculated as the 'Quantity Sold' (packaged and/or shipped) times the SO Line price.
Sales Amount Transferred: The amount already "amortized" (by running SO Line Amortization Processing).
Sales Amount Remaining: The difference between the 'Total Amount Sold' and the 'Sales Amount Transferred', represents the amount remaining to be amortized.
Planned Total Months: The number of months over which the given sale will be amortized. When using Contracts, this value defaults to the Contract Term (in months). When not using Contracts, this value must be manually set.
Number of Months Amortized: The number of months over which the amortization of this sale has already been amortized.
Current Number of Months Remaining: The number of months remaining for the sale to be fully amortized. If desired, the amortization can be accelerated or slowed by changing this value. The user can change this at any time. On the next amortization run, the Sales Amount and COGS Amount Remaining will be divided by the Current Number of Months Remaining to calculate the amount to be transferred (with the Current Number of Months Remaining being decremented by one after each transfer). To flush out all remaining balances on the next run, set the Current Number of Months Remaining to 1.
Amortization Completed: When checked, indicates that the given sale has been fully amortized. Auto set to TRUE when Sales Amount Transferred is equal to Total Sales Amount and COGS Amount Transferred is equal to Total COGS Amount.
Amortization Cancelled: When checked, any future amortization will be canceled. Canceling an Amortization Schedule causes it to be bypassed in all future amortization process runs. It is assumed by the system that any unprocessed amounts are being manually adjusted directly in the financial system. The cancellation process can be reversed, and so could be used as a temporary hold as well.
Sales Account: The default Sales (Revenue) Account for the given Product being amortized. This is the Sub Ledger Account (aka Mfg Account) to be credited when this SO Line Amortization Schedule is processed (adjusting the amount in the Deferred Sales Account).
Deferred Sales Account: The Sub Ledger Account (aka Mfg Account) is initially credited when an amortized shipment is made. Note that the GL Type for this account is Unearned Revenue.
COGS Account: The default COGS Account for the given Product being amortized. This is the Sub Ledger Account (aka Mfg Account) to be debited when this SO Line Amortization Schedule is processed (adjusting the amount in the Deferred COGS Account).
Deferred COGS Account: The Sub Ledger Account (aka Mfg Account) is initially debited when an amortized shipment is made. Note that the GL Type for this account is Deferred Cost.
Starting Month: The first month that amortization will begin.
Starting Year: The year associated with the ‘Starting Month’.
IMPORTANT The Starting Month and Starting Year are allowed to be up to 6 periods in the past. To allow the Starting Month and Starting Year to be less than 6 periods in the past, the user needs to create a Custom Setting 'amort_monthsbefore' with an appropriate value (less than 6). After the value change, it is the user's responsibility to run the previous month's amortizations before running the current month.
Last Processed Month: The last month in which prior amortization has occurred.
Last Processed Year: The year associated with the ‘Last Processed Month’.
Planned Ending Month: The last month of amortization where the sale is fully amortized, based on ‘Current Number of Months Remaining’.
Planned Ending Year: The year associated with the ‘Planned Ending Month’.
Per Unit Sales Amount: The Unit Price of the given sale, which is the ‘Total Sales Amount’ divided by the number of units shipped.
Per Unit COGS Amount: The “unit” cost value of the given sale, which is the ‘Total COGS Amount’ divided by the number of units shipped.
Override Sales Amount for Next Transfer: Entering a value in this field (other than zero) overrides the system-calculated amount to be transferred in the next amortization run. Additionally, entering a value here will cause any prior periods that have not been processed to be bypassed. This field is reset to zero after each amortization run.
Override COGS Amount for Next Transfer: Entering a value in this field (other than zero) overrides the system-calculated amount to be transferred in the next amortization run. Additionally, entering a value here will cause any prior periods that have not been processed to be bypassed. This field is reset to zero after each amortization run.
Comment for Next Transaction: Any text entered here will be written to the changing audit (where for example it can be used to explain the reason for canceling) and also written to the amortization run transaction. This field is cleared after each amortization run.
Sales Invoice Line: A link to the associated Sales Order Invoice Line.
From Order Line Credit (Negative Value): This field defines the amortization amount from the Invoice Line as negative. The amount has been set as positive, and the Debit and Credits will be reversed upon amortization.
NOTE If the 'Order Line Credit' on Sales Order Invoice Line record is TRUE, this field 'From Order Line Credit (Negative Value)' will be set to True, otherwise, it will be set to False.
Sales Order Line Amortization Txns Related List
This section displays related Sales Order Line Amortization Transactions generated when running SO Line Amortization Processing.
Sales Order Line Amortization Audits Related List
This section displays related Sales Order Line Amortization Audit records generated when changes are made to the Sales Order Line Amortization Schedules.
SEE ALSO
Amortization
Sales Order Line Amortization
Sales Order Line Amortization Processing
