BR152 – Maintenance Invoicing

System
AC Billing Revenue (BR)
Type
Batch program
Updates
25 tables
References
82 tables

BR152 (Maintenance Invoicing) 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 74 more.

About BR152

RunMaintenance Invoicing (BR152) to calculate the billable amounts you want to include on a client's maintenance invoice. You can run this program by collection, activity group, activity, or activity list. **Process at a Glance 1. Run Maintenance Invoicing (BR152) (this form). 2. Run Billing Invoice Reporting to review the invoice. 3. Create the invoice using Invoice Print and Interface (BR121). You can run this program concurrently with BR120. 4. Run Transaction Interface (AR560) to interface records to AccountsReceivable. **Processing Effect Journal entries made from the billing process post the invoiced amounts into the billed account categories in Project Accounting. The offsettingrevenue transactions will be posted to the GL accounts specified in the AR Codeassigned to the customer's process level AR. The Update option lets you choose whether to create the invoice interface records and update the activities you selected with the new billingcalculations, or to view a report of the calculations that will be performed when you choose to update. When Project Accounting invoices are interfaced into Accounts Receivable, they are summarized by activity account category.

Updated files (25)

TableDescriptionSystem
ACASNROLEThe Assignment Role file will store the roles associated with a resource assignment.AC
ACCLGTRANSCeiling Level TransactionsBR
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
ACMILESTNXActivity Milestones DetailBR
ACMNTSCHActivity Maintenance ScheduleBR
ACMNTSCHXActivity Maintenance Sched DtlBR
ACMONITORNo description in the Lawson data dictionaryAC
ACPRMSTNXNo description in the Lawson data dictionaryBR
ACRETNGActivity Bill RetentionBR
ACRETNGXActivity Bill Retention DetailBR
ACTRANSActivity TransactionAC
ARPROCLEVLAccounts Receivable Proc LevelAR
ARREASONAccounts Receivable Reason CdAR
CKPOINTNo description in the Lawson data dictionary
CUSTEPNo description in the Lawson data dictionaryBL
IFMONITORNo description in the Lawson data dictionaryIF
MXELEMENTAttribute ElementIF
MXLISTHDRAttribute List HeaderIF
MXLISTMBRAttribute ListIF
SUBCKPOINTSubledger Check PointIF
TXCODEMASTTax Code MasterTX
TXCOMPANYTax CompanyTX
TXTAXCODETax Code MaintenanceTX
TXTAXTABLETax TableTX

Referenced files (82)

TableDescriptionSystem
ACACCTCATActivity Account CategoriesAC
ACACCTCATXAccount Category DetailAC
ACACTGRPActivity GroupAC
ACACTIVITYActivityAC
ACACTMXVALActivity List Attribute ValuesAC
ACADDLCNTRAdditional Contract InfoBR
ACAMCODEActivity AssetAC
ACASNROLEThe Assignment Role file will store the roles associated with a resource assignment.AC
ACASSIGNActivity Resource AssignmentAC
ACBILLActivity BillingBR
ACBILLTOXActivity Bill To DetailBR
ACBILLXActivity Billing DetailBR
ACBLMASTActivity Billing BalancesBR
ACCATGRPAccount Category GroupAC
ACCATGRPXAccount Category Group DetailAC
ACCATMXVALNo description in the Lawson data dictionaryAC
ACCATSUMAccount Category SummaryAC
ACCATSUMXAccount Category Summ DetailAC
ACCNTRACTActivity ContractBR
ACCTRCATGContract Category GroupBR
ACCTRCATGXContract Category Group DtlBR
ACCUSTOMERActivity CustomerBR
ACFEECDActivity Management Fee CodeBR
ACGRPMXVALThe ACGRPMXVAL file is the primary file updated by AC13.AC
ACHISTCLGBilling OverageBR
ACHISTDTLInvoice DetailBR
ACHISTHDRInvoice HeaderBR
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
ACRETAINNo description in the Lawson data dictionaryBR
ACRETAINXNo description in the Lawson data dictionaryBR
ACROLEThe Activity Management Role file stores resource roles and descriptions.AC
ACSRVCLOCThis file maintains a service location for tax purposes.BR
ACSTATUSActivity StatusAC
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
ARREASONAccounts Receivable Reason CdAR
ARREMITPayment RemittanceAR
BILLTOBill ToAR
BRCUSTAUBR Activity Customer AuditBR
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
CUSTDESCAR Group CustomerAR
EPTRANSNo description in the Lawson data dictionaryBL
GLCODESGeneral Ledger CodesIF
GLSYSTEMGeneral Ledger CompanyIF
GMAWARDGrant Management AwardGM
INSTCTRYCDIntrastat Country CodesTX
INSTREGNIntrastat Region CodeTX
MXCATDEFAttribute DefinitionIF
MXLISTDTLAttribute List DetailIF
MXOBJCATAttribute ObjectIF
NATACCTAccounts Receivable Natl AcctAR
NATBALANCEAR National Account BalanceAR
OECUSTCustomer Order ProcessingAR
STATICCUSTAR Ovrd Credit Trans ReviewAR
STRUCTURECategory StructureAC
TXTAXRATETax RateTX
WFSETUPNo description in the Lawson data dictionaryWF

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