BR450 – Activity Aging

System
AC Billing Revenue (BR)
Type
Batch program
Updates
8 tables
References
60 tables

BR450 (Activity Aging) is a Lawson AC Billing Revenue batch program. It updates ACASNROLE, ARACPIVOT, ARDISPUTE, ARPROCLEVL, CKPOINT, CUSTEP, MXLISTHDR and MXLISTMBR and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACACTMXVAL, ACADDLCNTR, ACAMCODE, ACASNROLE and 52 more.

About BR450

Run Aging Report (BR450) to print a report of unbilled activities. This report includes information such as open invoice amounts and unapplied cash associated with a contract from Accounts Receivable (AR), and hold and reason code information.

More information: You can limit the report to up to six customers, indicate a date for which you want to review aging, change the aging days and periods that default from the activities you select, and limit the report to one or more of the following activity billing components: retention, retained fees, exceeded ceilings, milestones, and retainers.

Updated files (8)

TableDescriptionSystem
ACASNROLEThe Assignment Role file will store the roles associated with a resource assignment.AC
ARACPIVOTAcct Receivables Payment TransAR
ARDISPUTEAR Disputed TransactionsAR
ARPROCLEVLAccounts Receivable Proc LevelAR
CKPOINTNo description in the Lawson data dictionary
CUSTEPNo description in the Lawson data dictionaryBL
MXLISTHDRAttribute List HeaderIF
MXLISTMBRAttribute ListIF

Referenced files (60)

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
ACBILLXActivity Billing DetailBR
ACCATGRPAccount Category GroupAC
ACCATGRPXAccount Category Group DetailAC
ACCATMXVALNo description in the Lawson data dictionaryAC
ACCATSUMAccount Category SummaryAC
ACCATSUMXAccount Category Summ DetailAC
ACCLGTRANSCeiling Level TransactionsBR
ACCNTRACTActivity ContractBR
ACCTRCATGContract Category GroupBR
ACCTRCATGXContract Category Group DtlBR
ACCUSTOMERActivity CustomerBR
ACFEEBALThe fee balance file stores cumulative costs, fee and overage which will be used in calculating the billing and revenue…BR
ACFEECDActivity Management Fee CodeBR
ACGRPMXVALThe ACGRPMXVAL file is the primary file updated by AC13.AC
ACIFACTVThis file contains activity import information from AC500 (Activity Import).AC
ACMILESTNActivity MilestonesBR
ACMILESTNXActivity Milestones DetailBR
ACRETAINNo description in the Lawson data dictionaryBR
ACRETAINXNo description in the Lawson data dictionaryBR
ACRETNGXActivity Bill Retention DetailBR
ACROLEThe Activity Management Role file stores resource roles and descriptions.AC
ACSTATUSActivity StatusAC
ACTRANSActivity TransactionAC
AGINGCODEAccounts Receivable Aging CodeAR
ARACPIVOTAcct Receivables Payment TransAR
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
ARDISPUTEAR Disputed TransactionsAR
ARLOCKBOXLock Box LocationAR
ARPAYMENTAcct Receivables PaymentAR
ARPRLAUDAR Process Level AuditAR
CUSTDESCAR Group CustomerAR
EPTRANSNo description in the Lawson data dictionaryBL
GMAWARDGrant Management AwardGM
INSTCTRYCDIntrastat Country CodesTX
MXCATDEFAttribute DefinitionIF
MXELEMENTAttribute ElementIF
MXLISTDTLAttribute List DetailIF
MXOBJCATAttribute ObjectIF
NATACCTAccounts Receivable Natl AcctAR
NATBALANCEAR National Account BalanceAR
OECUSTCustomer Order ProcessingAR
STATICCUSTAR Ovrd Credit Trans ReviewAR
STRUCTURECategory StructureAC
WFSETUPNo description in the Lawson data dictionaryWF

Program calls

Invoked programs (1)

ACSR