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)

TableDescriptionSystem
ACACTIVITYActivityAC
ACBILLActivity BillingBR
ACBILLXActivity Billing DetailBR
ACCEILINGXActivity Ceiling DetailBR
ACCLGTRANSCeiling Level TransactionsBR
ACCNTRACTActivity ContractBR
ACFEEBALThe fee balance file stores cumulative costs, fee and overage which will be used in calculating the billing and revenue…BR
ACFEEDTLActivity Management Fee DetailBR
ACHISTGMInvoice GMBR
ACHISTHDRInvoice HeaderBR
ACINVAUDITNo description in the Lawson data dictionaryBR
ACMILESTNXActivity Milestones DetailBR
ACMNTSCHActivity Maintenance ScheduleBR
ACMNTSCHXActivity Maintenance Sched DtlBR
ACMONITORNo description in the Lawson data dictionaryAC
ACPRMSTNXNo description in the Lawson data dictionaryBR
ACRETAINNo description in the Lawson data dictionaryBR
ACRETAINXNo description in the Lawson data dictionaryBR
ACRETNGActivity Bill RetentionBR
ACRETNGXActivity Bill Retention DetailBR
ACTRANSActivity TransactionAC
ARPROCLEVLAccounts Receivable Proc LevelAR
CKPOINTNo description in the Lawson data dictionary
CUSTEPNo description in the Lawson data dictionaryBL
GMCOSTSHRGrant Management Cost ShareGM
GMPGMINCGrant Program IncomeGM
IFMONITORNo description in the Lawson data dictionaryIF
MXELEMENTAttribute ElementIF
SUBCKPOINTSubledger Check PointIF
TXCODEMASTTax Code MasterTX
TXCOMPANYTax CompanyTX
TXTAXCODETax Code MaintenanceTX
TXTAXTABLETax TableTX

Referenced files (59)

TableDescriptionSystem
ACACCTCATActivity Account CategoriesAC
ACACCTCATXAccount Category DetailAC
ACACTGRPActivity GroupAC
ACBILLTOXActivity Bill To DetailBR
ACBLMASTActivity Billing BalancesBR
ACCATGRPAccount Category GroupAC
ACCATGRPXAccount Category Group DetailAC
ACCATSUMAccount Category SummaryAC
ACCATSUMXAccount Category Summ DetailAC
ACCTRCATGContract Category GroupBR
ACCTRCATGXContract Category Group DtlBR
ACCUSTOMERActivity CustomerBR
ACFEECDActivity Management Fee CodeBR
ACHISTCLGBilling OverageBR
ACHISTDTLInvoice DetailBR
ACHISTTAXInvoice Tax DetailBR
ACIFACTVThis file contains activity import information from AC500 (Activity Import).AC
ACMILESTNActivity MilestonesBR
ACMNTHDRActivity Maintenance HeaderBR
ACMNTSCHXActivity Maintenance Sched DtlBR
ACPERCCMPLActivity Percent CompleteAC
ACPRMSTNNo description in the Lawson data dictionaryBR
ACPROADJNo description in the Lawson data dictionaryBR
ACPRODDTLActivity Product DetailBR
ACPRODHDRActivity Product HeaderBR
ACPRODINVProduct Invoice CancellationBR
ACPRODTAXNo description in the Lawson data dictionaryBR
ACPROFORMANo description in the Lawson data dictionaryBR
ACSRVCLOCThis file maintains a service location for tax purposes.BR
ACUOMActivity Unit of MeasureAC
ACWBSCODENo description in the Lawson data dictionaryBR
AGINGCODEAccounts Receivable Aging CodeAR
APACCRCODEInvoice Accrual CodeAP
ARCOMPAccounts Receivable CompanyAR
ARCOMPAUDAR Company AuditAR
ARCUSTFLDSAR Customer User FieldsAR
ARCUSTGRPAccounts Receivable Cust GroupAR
ARCUSTOMERAR Company CustomerAR
ARCUSTTOTSAR Customer PL InclusionsAR
ARDICTNo description in the Lawson data dictionaryAR
ARLOCKBOXLock Box LocationAR
ARPAYMENTAcct Receivables PaymentAR
ARPRLAUDAR Process Level AuditAR
ARREMITPayment RemittanceAR
BILLTOBill ToAR
BRCUSTAUBR Activity Customer AuditBR
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
CUSTDESCAR Group CustomerAR
EPTRANSNo description in the Lawson data dictionaryBL
GLSYSTEMGeneral Ledger CompanyIF
INSTCTRYCDIntrastat Country CodesTX
INSTREGNIntrastat Region CodeTX
NATACCTAccounts Receivable Natl AcctAR
NATBALANCEAR National Account BalanceAR
OECUSTCustomer Order ProcessingAR
STATICCUSTAR Ovrd Credit Trans ReviewAR
TXTAXRATETax RateTX
WFSETUPNo description in the Lawson data dictionaryWF

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