Calculating ASA
There are two ways to calculate alternate sales amounts:
-
Set ASA with SuiteScript.
With custom code, you can calculate ASA any way you want. For example, you can base ASA on the item's gross profit by subtracting the item's average cost from the item sales price.
Note:If you set alternate sales amount with scripting, the ASA for a transaction is still affected by discount or markup items.
For more information, see SuiteScript 2.x Scripting Records.
-
Calculate ASA as the first year revenue for item.
The Default Alternate Sales Amount to First Year Revenue preference automatically calculates ASA as the first year's revenue for the line item. If you do not use the Revenue Recognition feature, NetSuite considers that the sales amount entered is based on a 12 month term. In this case, the ASA is the same as the sales amount.
If you use the Revenue Recognition feature, the first year revenue is based on specific fields. These files are Rev. Rec. Start Date, Rev. Rec. End Date, and Rev. Term in Months.
For example, a line item is set to the following:
-
Sales Order Date: 1/1/2019
-
Rev. Rec. Start Date: 3/1/2019
-
Rev. Rec. End Date (either set manually or determined by the Rev. Term in Months field): 2/28/2021
-
Sales Amount: $2400
NetSuite calculates ASA as the months remaining in the first year divided by the term in months multiplied by the sales amount. For example, (10/24) * $2400. The ASA is $1000. NetSuite uses the Rev. Rec. Start Date field to determine the first year revenue term, 3/1/2019 to 12/31/2019, or 10 months. For information on the Rev. Term in Months field, see Revenue and Expense Recognition Overview.
If you add a discount line item after a line item with a 0 ASA, NetSuite does not apply the discount to the ASA. If the alternate sales amount field of the discount line item is empty, NetSuite applies the discount to the transaction ASA. If you change the alternate sales amount on a discounted line item, you may need to reapply the discount to ensure the correct ASA.