BR130 – Revenue Calculation
- System
- AC Billing Revenue (BR)
- Type
- Batch program
- Updates
- 21 tables
- References
- 47 tables
BR130 (Revenue Calculation) is a Lawson AC Billing Revenue batch program. It updates ACACTIVITY, ACASNROLE, ACBILL, ACBILLX, ACCEILINGX, ACCNTRACT, ACCNTRCAT, ACFEEBAL and 13 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTMXVAL, ACACTSEG, ACADDLCNTR, ACAMCODE, ACASNROLE and 39 more.
About BR130
Run Revenue Calculation (BR130) to calculate revenue for the activities you select. Revenue is calculated for the method and level you specify for all revenue-recognizing activities of a contract. The balance on the revenue level activity is evaluated to determine whether there is a balance in the billed or unbilled account categories.
More information: 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 Project Accounting 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 (21)
| Table | Description | System |
|---|---|---|
| ACACTIVITY | Activity | AC |
| ACASNROLE | The Assignment Role file will store the roles associated with a resource assignment. | AC |
| ACBILL | Activity Billing | BR |
| ACBILLX | Activity Billing Detail | BR |
| ACCEILINGX | Activity Ceiling Detail | BR |
| ACCNTRACT | Activity Contract | BR |
| ACCNTRCAT | Activity Contract Category | BR |
| ACFEEBAL | The fee balance file stores cumulative costs, fee and overage which will be used in calculating the billing and revenue… | BR |
| ACFEEDTL | Activity Management Fee Detail | BR |
| ACGLTOTREV | Activity Total Revenue Amount | BR |
| ACMILESTNX | Activity Milestones Detail | BR |
| ACTRANS | Activity Transaction | AC |
| ACTRANSERR | No description in the Lawson data dictionary | BR |
| ADDRDATA | Address Code | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
| IFMONITOR | No description in the Lawson data dictionary | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| SUBCKPOINT | Subledger Check Point | IF |
| SYSTEMCODE | System Code | IF |
Referenced files (47)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTMXVAL | Activity List Attribute Values | AC |
| ACACTSEG | The Activity Management Activity Segment file stores the user analysis data associated with each activity defined in… | AC |
| ACADDLCNTR | Additional Contract Info | BR |
| ACAMCODE | Activity Asset | AC |
| ACASNROLE | The Assignment Role file will store the roles associated with a resource assignment. | AC |
| ACASSIGN | Activity Resource Assignment | AC |
| ACBUDDTL | Activity Budget | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | AC |
| ACCATMXVAL | No description in the Lawson data dictionary | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCNTRACCT | Activity Contract Accounts | BR |
| ACCNTRACTX | Activity Contract Detail | BR |
| ACCONSOL | Activity Consolidation | AC |
| ACCTRCATGX | Contract Category Group Dtl | BR |
| ACFEECD | Activity Management Fee Code | BR |
| ACGLCODE | Activity GL Codes | AC |
| ACGLMAST | AC GL Acct Unit Master | AC |
| ACGRPMXVAL | The ACGRPMXVAL file is the primary file updated by AC13. | AC |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| ACJOURNLCD | Activity Journal Code | BR |
| ACMASTER | Activity Balances | AC |
| ACMILESTN | Activity Milestones | BR |
| ACPERCCMPL | Activity Percent Complete | AC |
| ACPERCMPLX | Activity Percent Complete Dtl | AC |
| ACROLE | The Activity Management Role file stores resource roles and descriptions. | AC |
| ACSTATUS | Activity Status | AC |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLCODES | General Ledger Codes | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLSYSTEM | General Ledger Company | IF |
| GMAWARD | Grant Management Award | GM |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MXCATDEF | Attribute Definition | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| STRUCTURE | Category Structure | AC |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (23)
ACAC, ACSR, ACTA, API4, GLCC, IFAC, IFAU, IFCU, IFFC, IFGT, IFIM, IFJR, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, SLFD, SLSB, SLSE, SLSS, SLSU