BR121 – Invoice Print and Interface
- System
- AC Billing Revenue (BR)
- Type
- Batch program
- Updates
- 25 tables
- References
- 83 tables
BR121 (Invoice Print and Interface) is a Lawson AC Billing Revenue batch program. It updates ACASNROLE, ACCLGTRANS, ACFEEBAL, ACFEEDTL, ACMILESTNX, ACMNTSCH, ACMNTSCHX, ACMONITOR and 17 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACACTMXVAL, ACADDLCNTR, ACAMCODE, ACASNROLE and 75 more.
About BR121
Run Invoice Print and Interface (BR121) to create an invoice, if required. In addition to the invoice, this program automatically creates history,Project Accounting and General Ledger transactions, and Accounts Receivable records. - Use the Activity page to identify the activities to be included on theinvoice and the run option (update). You can run this program by activity group list, activity group, activity, or activity list. - Use the Customer page to identify the company, customer, contract and username. - Use the Other Options page to specify invoice range and date range. - Use the Output Options to specify output options. **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 or BR121 run with Update set to Yes creates Accounts Receivable debit amounts and eitherProject 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 (25)
| Table | Description | System |
|---|---|---|
| ACASNROLE | The Assignment Role file will store the roles associated with a resource assignment. | AC |
| ACCLGTRANS | Ceiling Level Transactions | 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 (83)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | 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 |
| ACBILL | Activity Billing | BR |
| ACBILLTOX | Activity Bill To Detail | BR |
| ACBILLX | Activity Billing 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 |
| ACCNTRACT | Activity Contract | BR |
| ACCTRCATG | Contract Category Group | BR |
| ACCTRCATGX | Contract Category Group Dtl | BR |
| ACCUSTOMER | Activity Customer | BR |
| ACFEECD | Activity Management Fee Code | BR |
| 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 |
| ACINVORD | No description in the Lawson data dictionary | BR |
| 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 |
| GLCGCPY | Company Group Company | 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