BR122 – Online batch invoice process
- System
- AC Billing Revenue (BR)
- Type
- Batch program
- Updates
- 33 tables
- References
- 59 tables
BR122 (Online batch invoice process) is a Lawson AC Billing Revenue batch program. It updates ACACTIVITY, ACBILL, ACBILLX, ACCEILINGX, ACCLGTRANS, ACCNTRACT, ACFEEBAL, ACFEEDTL and 25 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACBILLTOX, ACBLMAST, ACCATGRP, ACCATGRPX, ACCATSUM and 51 more.
About BR122
Run Billing Calculation (BR120) to calculate the billable activity amountsyou want to include on a client's invoice. - Use the Activity page to identify the activities to be included on theinvoice and the run options (update and status). You can run this program by activity group list, activity group, activity, or activity list. - Use the Customer page to identify the company, customer, and contract. - Use the Other Options page to further classify the activities arecalculating billable amounts for. - Use the Output Options to specify output options. **Process at a Glance 1. Run Billing Calculation (this form) 2. Run Billing Invoice Reporting to review the invoice 3. Create the invoice using Invoice Print and Interface (BR121). You can runthis program concurrently with BR120. 4. Interface records to Accounts Receivable are automatically created by thisprogram. Use AR97.1 to correct any errors to these interface records. **Processing Effect This program lets you to create invoices and credit memos that have bothpositive and negative lines. If the activity account category net balance is positive, the lines print on an invoice. If the net balance is negative, the lines print on a credit memo. Journal entries made from the billing process post the billed or unbilledtransaction back into Project And Activity Accounting. When the program is run, 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 unbilled field, the entry is applied to the unbilled account category up to the balance. Any remaining balance is then applied to the billed account category. If a balance exists in the billed field, the entire balance is applied to the billed account category. The Update option lets you choose whether to create the invoice (and creditmemo) interface records and update the activities you selected with the new billing calculations, or to view a report of the calculations that will be performed when you choose to update. When Project And Activity Accounting invoices are interfaced into AccountsReceivable, they are summarized by activity account category. The Lawson Accounts Receivable system does not allow mixed (positive and negative) line items on an invoice or a credit memo. Pass through billing is not updated to the billed amount and is notcalculated against the maximum for the billing parameters. Pass through billing always posts to the unbilled account.
More information: Use Suppress Unit Totals and Suppress Units and Rates on the Other Optionspage to prevent unit totals and/or rates from appearing on the invoice.
Updated files (33)
| Table | Description | System |
|---|---|---|
| ACACTIVITY | Activity | 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 |
| ACHISTGM | Invoice GM | BR |
| ACHISTHDR | Invoice Header | 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 |
| ARPROCLEVL | Accounts Receivable Proc Level | 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 |
| 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 (59)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACBILLTOX | Activity Bill To Detail | BR |
| ACBLMAST | Activity Billing Balances | BR |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | 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 |
| ACHISTCLG | Billing Overage | BR |
| ACHISTDTL | Invoice Detail | 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 |
| ACSRVCLOC | This file maintains a service location for tax purposes. | BR |
| 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 |
| 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 |
| GLSYSTEM | General Ledger Company | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| INSTREGN | Intrastat Region Code | TX |
| NATACCT | Accounts Receivable Natl Acct | AR |
| NATBALANCE | AR National Account Balance | AR |
| OECUST | Customer Order Processing | AR |
| STATICCUST | AR Ovrd Credit Trans Review | AR |
| TXTAXRATE | Tax Rate | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (24)
ACAC, ACTA, API4, ARLL, BRIP, GLCC, IFAC, IFAU, IFCU, IFFC, IFGT, IFIM, IFJR, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, SLFD, SLSB, SLSE, SLSS, SLSU