BR140 – Billing and Revenue Backout
- System
- AC Billing Revenue (BR)
- Type
- Batch program
- Updates
- 42 tables
- References
- 83 tables
BR140 (Billing and Revenue Backout) is a Lawson AC Billing Revenue batch program. It updates ACACTIVITY, ACASNROLE, ACBILL, ACBILLX, ACBLMAST, ACCEILINGX, ACCLGTRANS, ACCNTRACT and 34 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTMXVAL, ACADDLCNTR, ACAMCODE, ACASNROLE, ACASSIGN and 75 more.
About BR140
Run Billing and Revenue Backout (BR140) to cancel billing and reverse revenue at the activity level. Billing and Revenue Backout (BR140) creates a credit memo to cancel billing, reverses revenue, and creates AC and GLentries to reflect that the billing and revenue were reversed for the activity. If BR140 is run for a Contract activity that is also an award activity with cost share information (defined on GM01.2), and invoicing has occurred, BR140 will clear the cost share invoice and amount fields for the activity. If the eligible billing amounts are later re-billed, the cost share amounts are recalculated at that time, and will print on the new custom invoice as a Current cost share amount rather than a Life amount.
Updated files (42)
| 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 |
| ACBLMAST | Activity Billing Balances | BR |
| ACCEILINGX | Activity Ceiling Detail | BR |
| ACCLGTRANS | Ceiling Level Transactions | 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 |
| ACHISTDTL | Invoice Detail | BR |
| ACINVAUDIT | No description in the Lawson data dictionary | 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 |
| ACRETAIN | No description in the Lawson data dictionary | BR |
| ACRETAINX | No description in the Lawson data dictionary | BR |
| ACRETNG | Activity Bill Retention | BR |
| ACRETNGX | Activity Bill Retention Detail | BR |
| ACTRANS | Activity Transaction | AC |
| ACTRANSERR | No description in the Lawson data dictionary | BR |
| ADDRDATA | Address Code | IF |
| 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 |
| GMCOSTSHR | Grant Management Cost Share | GM |
| GMPGMINC | Grant Program Income | GM |
| 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 |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
Referenced files (83)
| 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 |
| 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 |
| ACCNTRACTX | Activity Contract Detail | BR |
| 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 |
| ACHISTHDR | Invoice Header | BR |
| ACHISTTAX | Invoice Tax Detail | BR |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| ACINVORD | No description in the Lawson data dictionary | BR |
| ACJOURNLCD | Activity Journal Code | BR |
| ACMASTER | Activity Balances | 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 |
| 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 |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLINTCO | General Ledger Intercompany | 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