Invoice Register (JCR440)

Use this program to:

Print a register of all invoices for all jobs.
Build and print a general ledger distribution, if needed.
Post to accounts receivable and if the GL distribution is built, to general ledger according to the job information.
Update the sales analysis holding file according to the sales information.
Print summary or detail information.

Summary information includes invoice number, date, terms code, warehouse, salesperson/territory, job number, customer number and name, cost, billing, tax, freight and total.

Detail information includes summary information plus, for each line-item, cost type, cost code, date of transaction, units, unit of measure, cost rate/extension, billing rate/extension, memo, and document.

Register totals include the total number of invoices and the average invoice amount along with the total cost, billing, tax, freight and overall total.

Choose whether to build a General Ledger distribution, according to one of two formats, or skip the distribution altogether. The GL distribution information includes GL account number, description, customer number, name, invoice number and the amount to be debited or credited.

The Invoice Register updates the following information in each module:

Accounts Receivable	customer balances, sales history, open receivables file and sales tax file.
Sales Analysis	holding file, which includes holding invoice information to be posted to sales register and past sales analysis by later running the sales analysis Post Invoices to SA program.
General Ledger	journal entry.

Use the following fields to print and update the Invoice Register:

1. Date

Enter the Invoice Register date. The date must be within the current or next GL period. Enter (CR) defaults to the system date

GL Period

If the date entered above is within the current GL period, then this field is displayed as CURRENT with the current period and year. If the date entered above is within the next GL period, then this field is displayed as NEXT with the next period and year. (No field is necessary.)

2. Sa Period

Enter whether to post information from this register to the C-current or N-next sales analysis period. Enter (CR) defaults to C.

3. Warehouse

Enter up to 20 two-character warehouse codes to indicate the warehouse(s) for which register is to print. Only valid warehouse codes are accepted. Enter (CR) defaults to the warehouse assigned to the terminal. F3 defaults to ALL.

4. Scope

Enter whether to print S-summary or D-detail information. Enter (CR) defaults to S.

5. Correct

Enter Y or N to indicate whether or not this is the correct date and GL and SA period for the Invoice Register to post to.

If the system is set to print GL Distribution;

Check Register. OK To Print GL Distribution?

After printing the Invoice Register, verify the printout. If there is a correction to be made, enter N to exit the program. After the correction is made, the register can be rerun. If everything is correct, enter YES to continue. The program then prints the GL distribution. Once the GL distribution is printed, proceed to the next message.

Check GL Distribution. OK To Update?

After printing the GL distribution, verify the printout. If everything is correct, enter YES to continue. The program proceeds with the update. If there is a correction to be made, enter N to exit the program. After the correction is made, the entire register process begins again.

If the system is not set to print GL distribution:

Check Register. OK To Update?

After printing the Invoice Register, verify the printout. If there is a correction to be made, enter N to exit the program. After the correction is made, the register can be rerun. If everything is correct, enter YES to continue and no GL distribution will be printed. The program proceeds with the update.

Invoice Register (JCR440)

Use the following fields to print and update the Invoice Register:

If the system is set to print GL Distribution;

If the system is not set to print GL distribution:

See Also