BR120 – Invoice Calculation
- System
- AC Billing Revenue (BR)
- Type
- Batch program
- Updates
- 30 tables
- References
- 79 tables
BR120 (Invoice Calculation) is a Lawson AC Billing Revenue batch program. It updates ACACTIVITY, ACASNROLE, ACBILL, ACBILLX, ACCEILINGX, ACCLGTRANS, ACCNTRACT, ACFEEBAL and 22 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTMXVAL, ACADDLCNTR, ACAMCODE, ACASNROLE, ACASSIGN and 71 more.
About BR120
Run Billing Calculation (BR120) to construct invoices based on activity billing parameters and posted transactions. - Use the Activity page to identify the activities to invoice and the runoptions (update and status). You can run this program by activity group list, activity group, activity, or activity list. - (Optional) Use the Customer page to select the company, customer, andcontract. - Use the Other Options page to further classify the billable amountsincluded and other invoice options. - Use the Output Options page to specify certain reports to include in theoutput and whether to print invoice comments. **Processing Effect General Ledger and Project Accounting journal entry records are automatically created by running this program with the Update field set to Yes. Billing Calculation (BR120) with a status of Processed creates Accounts Receivable debit amounts and either Project Accounting Billed/Unearned or Earned/Unbilled credits. If you are recognizing revenue before youcalculate the bill, Earned/Unbilled credits are created. If you calculate the billbefore you recognize revenue, Billed/Unearned credits are created.
Updated files (30)
| 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 |
| ACCLGTRANS | Ceiling Level Transactions | BR |
| ACCNTRACT | Activity Contract | 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 |
| ACMILESTNX | Activity Milestones Detail | BR |
| ACMNTSCH | Activity Maintenance Schedule | BR |
| ACMNTSCHX | Activity Maintenance Sched Dtl | BR |
| ACMONITOR | No description in the Lawson data dictionary | AC |
| ACPRMSTNX | No description in the Lawson data dictionary | BR |
| ACRETNG | Activity Bill Retention | BR |
| ACRETNGX | Activity Bill Retention Detail | BR |
| ACTRANS | Activity Transaction | AC |
| ARPROCLEVL | Accounts Receivable Proc Level | AR |
| ARREASON | Accounts Receivable Reason Cd | AR |
| CKPOINT | No description in the Lawson data dictionary | — |
| CUSTEP | No description in the Lawson data dictionary | BL |
| 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 |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
Referenced files (79)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTMXVAL | Activity List Attribute Values | 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 |
| ACBILLTOX | Activity Bill To Detail | BR |
| ACBLMAST | Activity Billing Balances | BR |
| 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 |
| ACCTRCATG | Contract Category Group | BR |
| ACCTRCATGX | Contract Category Group Dtl | BR |
| ACCUSTOMER | Activity Customer | BR |
| ACFEECD | Activity Management Fee Code | BR |
| ACGLCODE | Activity GL Codes | AC |
| ACGRPMXVAL | The ACGRPMXVAL file is the primary file updated by AC13. | AC |
| ACHISTCLG | Billing Overage | BR |
| ACHISTDTL | Invoice Detail | BR |
| ACHISTHDR | Invoice Header | BR |
| ACHISTTAX | Invoice Tax Detail | BR |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| ACMILESTN | Activity Milestones | BR |
| ACMNTHDR | Activity Maintenance Header | BR |
| ACMNTSCHX | Activity Maintenance Sched Dtl | BR |
| ACPERCCMPL | Activity Percent Complete | AC |
| ACPRMSTN | No description in the Lawson data dictionary | BR |
| ACPROADJ | No description in the Lawson data dictionary | BR |
| ACPRODDTL | Activity Product Detail | BR |
| ACPRODHDR | Activity Product Header | BR |
| ACPRODINV | Product Invoice Cancellation | BR |
| ACPRODTAX | No description in the Lawson data dictionary | BR |
| ACPROFORMA | No description in the Lawson data dictionary | BR |
| ACRETAIN | No description in the Lawson data dictionary | BR |
| ACRETAINX | No description in the Lawson data dictionary | BR |
| ACROLE | The Activity Management Role file stores resource roles and descriptions. | AC |
| ACSRVCLOC | This file maintains a service location for tax purposes. | BR |
| ACSTATUS | Activity Status | AC |
| ACUOM | Activity Unit of Measure | AC |
| ACWBSCODE | No description in the Lawson data dictionary | BR |
| AGINGCODE | Accounts Receivable Aging Code | AR |
| APACCRCODE | Invoice Accrual Code | AP |
| ARCOMP | Accounts Receivable Company | AR |
| ARCOMPAUD | AR Company Audit | AR |
| ARCUSTFLDS | AR Customer User Fields | AR |
| ARCUSTGRP | Accounts Receivable Cust Group | AR |
| ARCUSTOMER | AR Company Customer | AR |
| ARCUSTTOTS | AR Customer PL Inclusions | AR |
| ARDICT | No description in the Lawson data dictionary | AR |
| ARLOCKBOX | Lock Box Location | AR |
| ARPAYMENT | Acct Receivables Payment | AR |
| ARPRLAUD | AR Process Level Audit | AR |
| ARREASON | Accounts Receivable Reason Cd | AR |
| ARREMIT | Payment Remittance | AR |
| BILLTO | Bill To | AR |
| BRCUSTAU | BR Activity Customer Audit | BR |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| CUSTDESC | AR Group Customer | AR |
| EPTRANS | No description in the Lawson data dictionary | BL |
| GLCODES | General Ledger Codes | IF |
| GLSYSTEM | General Ledger Company | IF |
| GMAWARD | Grant Management Award | GM |
| INSTCTRYCD | Intrastat Country Codes | TX |
| INSTREGN | Intrastat Region Code | TX |
| MXCATDEF | Attribute Definition | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| NATACCT | Accounts Receivable Natl Acct | AR |
| NATBALANCE | AR National Account Balance | AR |
| OECUST | Customer Order Processing | AR |
| STATICCUST | AR Ovrd Credit Trans Review | AR |
| STRUCTURE | Category Structure | AC |
| TXTAXRATE | Tax Rate | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (25)
ACAC, ACSR, ACTA, API4, ARLL, BRIP, GLCC, IFAC, IFAU, IFCU, IFFC, IFGT, IFIM, IFJR, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, SLFD, SLSB, SLSE, SLSS, SLSU