Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BR120


BR120 - Invoice Calculation

**Form Purpose
Run Billing Calculation (BR120) to calculate the billable activity amounts
you want to include on a client's invoice.

- Use the Activity page to identify the activities to be included on the
invoice 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 are
calculating 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 run
this program concurrently with BR120.

4. Interface records to Accounts Receivable are automatically created by this
program. 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 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.

Journal entries made from the billing process post the billed or unbilled
transaction 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 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.

When Project And Activity Accounting 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.

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.

**More Information
Use Suppress Unit Totals and Suppress Units and Rates on the Other Options
page to prevent unit totals and/or rates from appearing on the invoice.




Updated Files

    ACACTIVITY -

    ACBILL     -

    ACBILLX    -

    ACCEILINGX -

    ACCLGTRANS -

    ACCNTRACT  -

    ACFEEBAL   -

    ACFEEDTL   -

    ACMILESTNX -

    ACMONITOR  -

    ACRETNG    -

    ACRETNGX   -

    ACTRANS    -

    ARPROCLEVL -

    CKPOINT    -

    CUSTEP     -

    IFMONITOR  -

    MXLISTHDR  -

    MXLISTMBR  -

    SUBCKPOINT -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -


Referenced Files

    ACACCTCAT  -

    ACACCTCATX -

    ACACTGRP   -

    ACACTMXVAL -

    ACADDLCNTR -

    ACAMCODE   -

    ACASNROLE  -

    ACASSIGN   -

    ACBILLTOX  -

    ACBLMAST   -

    ACCATGRP   -

    ACCATGRPX  -

    ACCATSUM   -

    ACCATSUMX  -

    ACCTRCATG  -

    ACCTRCATGX -

    ACCUSTOMER -

    ACFEECD    -

    ACGLCODE   -

    ACGRPMXVAL -

    ACHISTDTL  -

    ACHISTHDR  -

    ACHISTTAX  -

    ACIFACTV   -

    ACMILESTN  -

    ACPERCCMPL -

    ACRETAIN   -

    ACRETAINX  -

    ACROLE     -

    ACSRVCLOC  -

    ACSTATUS   -

    ACUOM      -

    ACWBSCODE  -

    AGINGCODE  -

    APACCRCODE -

    ARCOMP     -

    ARCUSTFLDS -

    ARCUSTGRP  -

    ARCUSTOMER -

    ARCUSTTOTS -

    ARLOCKBOX  -

    ARPAYMENT  -

    BILLTO     -

    CUCONV     -

    CURELAT    -

    CUSTDESC   -

    EPTRANS    -

    GLCODES    -

    GLSYSTEM   -

    GMAWARD    -

    INSTCTRYCD -

    INSTREGN   -

    MXCATDEF   -

    MXELEMENT  -

    MXLISTDTL  -

    MXOBJCAT   -

    NATACCT    -

    NATBALANCE -

    OECUST     -

    STATICCUST -

    TXTAXRATE  -

    WFSETUP    -


INVOKED Programs

    ACSR
    BRIP
    ACCL
    ACTA
    API4
    ACAC
    IFCU
    IFAC
    IFAU
    IFOB
    IFSG
    SLSE
    SLSU
    IFLU
    ARLL
    IFRS
    IFSC
    IFGT
    GLCC
    SLSB
    SLSS
    IFJR
    SLFD
    IFFC
    IFIM