BR151 – Product Invoicing

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

BR151 (Product 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 75 more.

About BR151

Run Product Invoicing (BR151) to calculate the billable activity amounts youwant to include on a client's product invoice. You can run this program by activity group list, activity group, activity, oractivity list. **Processing Effect Journal entries made from the billing process post the invoiced amounts into the billed account categories in Project Accounting. The offsetting 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.

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
ACGLCODE	Activity GL Codes	AC
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
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
GLCODES	General Ledger Codes	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