AC170 - Revenue Calculation Use AC170 (Revenue Calculation) to calculate revenue for the activities you select. Revenue is calculated at the level you specify for all revenue-recognizing activities of an activity group. The balance on the revenue level activity is evaluated to determine whether there is a balance in the billed or unbilled fields. If a balance exists in the billed field, the entry is applied to the billed account category up to the balance. Any remaining balance is then applied to the unbilled account category. If a balance exists in the unbilled field, the entire balance is applied to the unbilled account category. Pass through revenue is not included in the billed or unbilled balances. Pass through revenue always posts to the unbilled account. Note: When the revenue method is Percent Complete (Method B - Gross Margin) or Completed Contract (Method B - Gross Margin) and you define the revenue accounts as an account and subaccount rather than a General Ledger code, revenue is calculated using the Activity Management GL Accnt Unit Master file cost balances instead of the total cost amount from the Percent Complete file. The gross margin calculation for revenue recognition is based on the following formulas: Gross Margin = Gross Profit / Contract Amount Revenue = 1 / (1 - Gross Margin ) x Costs to Date Updated Files ACACTIVITY - Updates the Total Revenue and Total Loss fields on this file. ACGLTOTREV - Updates the Total Revenue and Total Loss fields on this file. ACTRANS - This is the primary file maintained by this program. Creates revenue and offsetting entries to post to activities. CKPOINT - Used for restart capability. MXLISTHDR - Updates the Last Build Time and Last Build Date fields on this file. MXLISTMBR - Updates the new activities included in the list. SYSTEMCODE - This file is used by a common routine that is used by this program. Referenced Files ACACCTCAT - References this file to validate the account category. ACACCTCATX - References this file to validate that the account category is assigned to the activity group or activity. Also, references this file to validate billing parameters. ACACTGRP - References this file to validate the activity group. ACACTMXVAL - References this file to validate activity attributes and values. ACACTSEG - ACAMCODE - This file is used by a common routine that is used by this program. ACASSIGN - This file is used by a common routine that is used by this program. ACBILL - References this file to determine the offset account(s) for the revenue entry. ACBILLX - References this file to determine the offset account(s) for the revenue entry. ACBUDDTL - References this file to retrieve annual budget and future years budget balances for activity budgets. ACCAL - References this file to validate the calendar. ACCALX - References this file to validate period and period end dates for the calendar. ACCONSOL - References this file to retrieve year-to-date budget and actual amounts and calculate life-to-date budget and actual amounts for summary-level activities in activity group currency. ACCONSOLX - References this file to retrieve period-to-date budget and actual amounts for summary-level activities in activity group currency. ACCUSTOMER - References this file to validate the activity customer. ACGLCODE - References this file to retrieve the company, accounting unit, account and sub account for the GL code. ACGLMAST - References this file to retrieve year-to-date actual amounts and calculate life-to-date actual amounts by company and accounting unit for summary-level activities in activity group currency. ACGLMASTX - References this file to retrieve period-to-date actual amounts by company and accounting unit for summary-level activities in activity group currency. ACLEVEL - References this file to determine if the activity is summary level or posting. ACMASTER - References this file to retrieve year-to-date actual amounts and calculate life-to-date actual amounts for posting-level activities in activity group currency. ACMASTERX - References this file to retrieve period-to-date actual amounts for posting-level activities in activity group currency. ACPERCCMPL - References this file to validate the activity percent complete. ACREVENUE - References this file to determine accounts to post revenue entries to. ACREVENUEX - References this file to determine accounts to post revenue entries to. ACRPTGRP - ACRPTGRPX - References this file to validate account categories in the group. ACSTATUS - References this file to validate that the status is valid for revenue recognition. GLADDRESS - This file is used by a common routine that is used by this program. GLCHART - This file is used by a common routine that is used by this program. GLCODES - This file is used by a common routine that is used by this program. GLINTCO - This file is used by a common routine that is used by this program. GLSYSTEM - References this file to validate the company in the Lawson General Ledger system. MXCATDEF - This file is used by a common routine that is used by this program. MXELEMENT - This file is used by a common routine that is used by this program. MXLISTDTL - References this file to validate list parameters. MXOBJCAT - This file is used by a common routine that is used by this program. WFSETUP - INVOKED Programs IFAC ACAC IFCR IFSG IFCU IFAU SLSE SLSU IFFC IFGT IFCC IFOB IFRS IFSC SLSB SLTV IFJR SLFD |