You use this program to generate a report of journals created from transactions posted using the AR Invoice Posting, AR Initial Invoice Capture, AR Finance Charge Calculation, Sales Order Entry, Document Print and AR Post Permanent Entries programs.
These journals are created by the AR Invoice GL Integration program. The AR Invoice Register serves as an audit trail of Accounts Receivable invoice transactions processed.
This report can be run at any time and as often as required.
| Field | Description | ||||
|---|---|---|---|---|---|
| Options | |||||
| New page per register | Select this to print the details for each register on a separate page. | ||||
| Highlight missing invoices |
Select this to print an error message on the report if any invoice numbers are found to be out of sequence (see Missing Invoice Numbers). When you select this option, the invoices included in the report are sequenced by invoice number to identify those invoice numbers that are out of sequence.
|
||||
| Reprint | |||||
| Reprint | Select this to reprint registers that were previously
printed. You can only reprint invoice registers for as long as you are retaining Sales transaction summary records and Sales transaction detail records (Accounts Receivable Setup - History tab). Invoice registers are deleted as part of the Purge function of the AR Period End program. |
||||
| Field | Description |
|---|---|
| Register number selection | Indicate the transaction journal number(s) you want to reprint. |
| Period selection | |
| Period | Indicate the period, within the year indicated, for which you want to reprint the registers. |
| Year | Indicate the year for which you want to reprint the registers. |
| Branch selection | Indicate the Accounts Receivable branches for which you want to reprint the journals. |
These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).
![[Note]](images/note.png)
|
|
|
Although invoices processed using the AR Initial Invoice Capture program are included in the invoice register, no corresponding General Ledger journals are created for them by the AR Invoice GL Integration program. Therefore, to balance the AR Invoice Register totals to the AR Sales Distribution report, you must exclude registers for these invoices. |
|
If you selected the option to highlight missing invoices on the report, then an error message is printed when invoice numbers are found to be out of sequence.
Following are reasons why invoice numbers may be out of sequence or may not have been printed on the report:
-
The value in the Next invoice field is changed (Accounts Receivable Setup - Numbering tab).
For example: The next invoice number is currently set to 1000. This means that 100 is the number that must be allocated to the next invoice which is generated. If this value is manually changed to 1005, then the system uses 1005 as the next invoice number and will indicate that invoices 1000 to 1004 are missing.
-
If the option: Order Release - Automatic invoice numbering is set to Yes (Sales Order Setup - Numbering tab), then an invoice number is automatically assigned when you release a sales order. If you then cancel an order that is in a status of 8 (ready to invoice) and which already has an invoice number assigned to it, then the invoice number is not re-allocated to another sales order. This means that the invoice number never appears on the AR Invoice Register or the Sales Turnover.
-
If the option: Order number moved to invoice number is selected (Sales Order Setup - General 3 tab) then the sales order number is used as the invoice number. Subsequent cancellation of an order results in missing invoice numbers.
-
If the option: Request when order released from status 4 is set to Invoice (Sales Order Setup - General 3 tab) then the invoice number is requested at the time of releasing an order that is in a status of 4 (if automatic numbering is not used (Sales Order Setup - Numbering tab)). If the status of the order is then changed from 8 to 9 manually without completing the invoice process, then the invoice number is defined as missing.
- If the setup option: Request when order released from status 4 is not selected for Invoice, (Sales Order Setup - General 3 tab), and the option: Order release - automatic invoice numbering is set to Yes (Sales Order Setup - Numbering tab), then an invoice number is assigned to the order when the order status is changed from 4 to 8. If you change the order status from 8 to 9 (instead of cancelling the order), then missing invoice numbers occur.
-
The multi-period accounting facility allows you to post financial transactions into the current and previous two periods. When the transactions are generated using the AR Invoice Posting and Document Print programs, they are assigned invoice numbers based on the setup options selected (Sales Order Setup and Accounts Receivable Setup). Invoice Registers are created per operator, for the financial period/year into which the transactions are posted.
For example, if automatic invoice numbering is used and there are several operators posting invoices concurrently into the current month and into previous month 1, then separate Invoice Registers are produced for each period. In this scenario, especially if the operators are invoicing on-line, it is possible that missing invoice numbers are reported on some of the Invoice Registers because of the sequence in which the operators posted transactions into the current month and previous month 1.
-
If you are using device printing with Print Preview deselected, then in some cases the invoice may only have been partially printed or a failure occurred while the invoice process is in the update phase and no invoice number was allocated to the sales order.
A message is printed on these invoices and the event Invoice process failed during document print (Event Management) can be used to make you aware of this having occurred.
The following section describes the sequence of events that occur when printing invoices:
-
Sales Order Invoicing Process - printing invoices online.
An order is created and released using Sales Order Entry. When the Print invoice option is selected on the End Order screen, the following occurs:
- The order is closed.
- The Document Print program is loaded with instructions to process the invoice for the selected order.
- The appropriate printer is selected, and initialised.
- The order is validated and, if accepted, the order header status is set to '0', in process.
- If an invoice number is already allocated to the order, then it is validated. If not, the next invoice number is allocated according to the setup options in Sales Orders and Accounts Receivable.
- The invoice is validated and printed.
- The reprint file is created as the printing occurs, but the invoice in the reprint file remains in a status of Z which means that it cannot be accessed by any other process.
-
If any errors occur in this process, then:
-
for windows printing:
- the invoice is discarded without printing
- the reprint information is removed
- the order returned to its original status
- an error is returned to the SO Entry process
-
for device printing:
- an attempt is made to print an error status on the device
- an email can be sent if the event Invoice process failed during document print (Event Management) is defined
- the reprint information is removed
- the order is returned to its original status
- an error is returned to the SO Entry process
-
-