AC115 - Billing Calculation Run AC115 (Billing Calculation) to calculate billings for the activity groups or activities you select. You can select activities individually or in activity lists. AC115 creates invoice (and credit memo) interface records. Use BL520 (Billing Interface) to interface them into the Billing system. AC115 allows you to create invoices and credit memos that have both positive 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. When Activity Management invoices are interfaced into Accounts Receivable, 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. Journal entries made from the billing process post the billed or unbilled transaction back into Activity Management. 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. Pass through billing is not updated to the billed amount and is not calculated against the maximum for the billing parameters. Pass through billing always posts to the unbilled account. The Update option lets you choose whether to create the invoice (and credit memo) 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. Updated Files ACACTIVITY - Updates the Total Billed field on this file. Maintains the total billed to determine the relationship between amount billed and revenue recognized, and to determine whether to use billing asset or liability accounts for the offset to billing and revenue entries. ACBILL - Updates the Total Billed field on this file. Maintains this amount field to determine if the maximum billed has been reached for the billing activity record. ACCUSTOMER - Updates the Invoice Prefix, Invoice Number, and Bill-To Address fields on this file for the current run of this program. Used when printing multiple activities on an invoice. The Invoice Detail field determines if multiple activities or a single activity are printed on a billing invoice. ACMILESTNX - Updates the Status field on this file. Maintains if the milestone has been billed. ACTRANS - Updates the Billed and Bill Date fields on this file. For all billing methods other than milestone, the Activity Management cost transactions are flagged as billed and updated with the billed date. CKPOINT - Used for restart capability. ICCOMPANY - Edits the company data and returns the number of decimals associated with the company. MXLISTHDR - Updates the last build date and time on this file, if the list needs to be rebuilt. MXLISTMBR - Adds and deletes activities included in the list, if the list needs to be rebuilt. OECOMPANY - Updates the last invoice number used on this file, if you are invoicing by company. OEINVCTYPE - Updates the Invoice Used flag on this file. OEPROCLEV - Updates the last invoice number used on this file, if you are invoicing by company and process level. OIINVCCOMM - This is one of the primary files maintained by this program. This file maintains invoice comments records. Comments with a line number are specific to that line. Comments with a blank or spaces instead of a line number apply to the invoice as a whole. OIINVCLINE - This is one of the primary files maintained by this program. This file maintains invoice line detail. Information maintained at the line level includes activity, account category, labor attribute, billable amount, billing rate, units, and total billed. OIINVOICE - This is one of the primary files maintained by this program. This file maintains invoice header information, including the customer. Referenced Files ACACCTCAT - References this file to validate the account category. ACACTGRP - References this file to validate the activity group. ACACTMXVAL - References this file to validate the activity attributes and values. ACAMCODE - References this file to validate the asset code assigned to the activity. ACASSIGN - References this file to validate the resource assigned to the activity as the manager. ACBILLX - References this file to validate billing parameters at the activity and account category level. ACCOMMENTS - References this file to retrieve activity comments, if comments are attached to the invoices. ACGLCODE - References this file to validate GL codes. ACLEVEL - References this file to determine if the activity is summary or posting-level. Also uses this file to access the activity hierarchy when the billing method is defined at a summary level. ACMILESTN - References this file to validate milestone type. ACPERCCMPL - References this file for milestone type Percent Complete. References the activity milestone record for the as-of-date to determine if the activity meets the percent complete milestone. ACRESOURCE - References this file to validate person or equipment resources defined within Activity Management. ACREVENUE - ACRPTGRP - ACSTATUS - References this file to validate if the activity status code allows billing. ACUOM - References this file to validate the UOM code and to determine if it is a labor or non-labor billing. AGINGCODE - This file is accessed by an Accounts Receivable common routine used by this program. AMASSET - This file is accessed by a common routine used by this program. APCPYVND - This file is accessed by a common routine used by this program. APHLDINV - This file is accessed by a common routine used by this program. APVENCLASS - This file is accessed by a common routine used by this program. APVENMAST - References this file to validate vendor resources in the Lawson Accounts Payable system. ARADJUST - This file is accessed by a common routine used by this program. ARCOMP - This file is accessed by a common routine used by this program. ARCUSTFLDS - This file is accessed by a common routine used by this program. ARCUSTGRP - This file is accessed by a common routine used by this program. ARCUSTOMER - References this file to validate the customer in the Lawson Accounts Receivable system. ARCUSTTOTS - This file is accessed by a common routine used by this program. ARITRANS - This file is accessed by a common routine used by this program. ARLOCKBOX - This file is accessed by a common routine used by this program. AROIHDR - This file is accessed by a common routine used by this program. AROITEMS - This file is accessed by a common routine used by this program. ARPAYMENT - This file is accessed by a common routine used by this program. CUSTDESC - This file is accessed by a common routine used by this program. EMPLOYEE - References this file to validate employee resources in the Lawson Human Resources system. HRSECLEV - This file is accessed by a common routine used by this program. INSTCTRYCD - MXCATDEF - This file is accessed by a common routine used by this program. MXELEMENT - This file is accessed by a common routine used by this program. MXLISTDTL - References this file to retrieve the activities included in the list. MXOBJCAT - This file is accessed by a common routine used by this program. NATACCT - This file is accessed by a common routine used by this program. NATBALANCE - This file is accessed by a common routine used by this program. OECUST - References this file to validate the activity customer in the Lawson Billing system. OEREASON - References this file to validate the credit memo reason code in the Lawson Billing system. PRSYSTEM - References this file to validate that the company exists in the Lawson Payroll system. STATICCUST - This file is accessed by a common routine used by this program. WFSETUP - INVOKED Programs HRFN IFCC IFCU IFCR IFSG |