This report is generated by rental billing runs (preliminary and final), equipment billing runs, general invoicing billing runs and A/P voucher updates. Legacy key invoice billing runs will also generate the report.
The report details the following for each stock number processed in the run:
STOCK#
BR
ORD# (Invoice#)
CUS#
CONTRACT#
G/L ACC (typically the revenue account)
CGT (Complete Goods Type aka Application Type associated with the account)
AMOUNT
ERROR CONDITIONS
Note: The invoices that are due to be processed are created during the beginning of the rental billing run. If the run encounters an error (i.e. rent debited greater than total rent, etc.) the billing run is cancelled. The contract with the error and the reason for the error will appear on the REN005 report. Although the invoices have been created, the posting has not been completed. The invoices will not appear on the customer A/R or in invoice history until the contracts with the errors have been corrected and another billing run has been processed. Note that equipment, general invoicing and A/P Voucher Update runs may also be held up.
There are four critical error conditions listed below that may be generated by the runs, however a number of other less important errors may be generated:
0133 Adjustment would cause a net book value less than zero
Cause:
A transaction is being processed that is crediting an equipment inventory and/or write down account. The credit would cause the stock number being used to have a net book value less than zero.
Net book value is calculated as supplier invoice amount plus all inventory adjustments (eg. work orders) plus all write downs (write downs are usually credits). The net book value can be seen on the equipment profile.
Recovery:
Reduce the amount of the credit to keep the net book value greater than 0.
0138 Over allowance not equal to original invoice over allowance
Cause:
An invoice is being processed that is crediting an equipment over allowance account (a reversal of a previous sale invoice) and the amount being credited does not match the amount debited on the original sale invoice. The original over allowance amount can be displayed using the equipment profile screen.
Recovery:
Make sure the over allowance amount being credited is equal to the amount debited on the original sale invoice.
0143 Rental credit amount is greater than Life to Date Rental Income
Cause:
An invoice is being processed that is debiting a rental sale account and the stock# being used would have a total rental sale amount greater than zero if this debit were allowed.
For example, more rental sales are being debited than were previously credited to this stock#. The rental amount can be displayed using the Equipment Profile screen. This may also be a conversion issue for users who are relatively new to the system. Please contact support if this is suspected as files may need to be edited.
Recovery:
Reduce the amount of the debit to keep the total rental sale amount less than or equal to zero, or use a different G/L account.
0151 This adjustment causes a current cost less than zero
Cause:
A transaction is being processed that is crediting an equipment inventory account. The stock number being used with that credit would have a current cost less than zero if this credit were allowed. The current cost can be displayed using the equipment profile screen.
A transaction is being processed that is crediting a fixed asset account. The asset number being used with that credit would have a purchase amount less than zero if this credit were allowed. The purchase amount can be displayed using the fixed asset profile screen.
Recovery:
Reduce the amount of the credit to keep the current cost for stock numbers (purchase amount for accounts) greater than or equal to zero, or use a different G/L account.
EMAIL NOTIFICATION
There is an email notification in the REN005 program when the four errors above have been detected on the report. The email is sent to the address in the BACKUP table. There is no option to deactivate this email.