This appendix contains these topics:
The following table lists the standard procedures that should be used by companies before month-end reporting is completed. The table represents a series of control reports and balance verification programs with a brief description of each and the frequency with which J.D. Edwards recommends the procedures be executed.
Procedure | Program | Description | Frequency |
---|---|---|---|
Verify that document numbers are in sequence | P74099 (World) | The Sequential Number report highlights any interruption in the document number sequence and general accounting registration date sequence. | Daily |
Print a listing of all unposted accounting batches | P007011 (World) | The Unposted Batches Integrity Test highlights any unposted batches. The posting of all accounting batches is a prerequisite for the subsequent balance verifications. | Weekly |
Verify that batch detail and batch header information match | P007021 (World) | The Transactions to Batch Headers Integrity Test highlights any mismatch between batch headers and the individual transactions within the batch. Mismatches might include transactions for which there is no batch header, or posted transactions that belong to unposted batches. | Weekly |
Balance A/R against G/L | P03701 (World) | Run the A/R to G/L by Batch Integrity Test to check the balance between the A/R Ledger (F0311) and the General Ledger (F0911) by batch number.
The program also highlights anomalous situations regarding the payment status, such as payment status P against open amounts. If the A/R and General Ledgers are out of balance, the Customer Total by G/L Class Report (P09450) can be used an additional verification tool. |
Weekly |
Balance A/R against G/L by accounting class | P037001 (World) | Run the A/R to G/L by Accounting Class Integrity Test to match the A/R ledger (F0311) to the Account Balances file (F0902) by accounting class. | Weekly |
Balance A/P against G/L | P04701 (World) | Run the A/P Original Documents to G/L by Batch Integrity Test to check the balance between the A/P Ledger (F0411) and the General Ledger (F0911) by batch number.
The program also highlights anomalous situations regarding the payment status, such as payment status P against open amounts. If the A/P and General Ledgers are out of balance, the Suppliers Total by G/L Class report (P09450) can be used as an additional verification tool. NOTE: If the Bolla Doganale are entered as prepaid documents, the ledger and the Customs debit account might be out of balance. |
Weekly |
Balance A/P against G/L by accounting class | P047001 (World) | Run the A/P Originals to G/L by Batch Integrity Test to match the A/P Ledger (F0411) to the Account Balances file (F0902) by offset account. | Weekly |
Print Trial Balance reports | P7409C3 (World) P7409C4 (World) | By object.subsidiary By category code 21, 22, 23 | Monthly |
Print Monthly IVA reports | P004051 (World) | Run a version of the Italian A/R - A/P IVA Tax Report for EU IVA purchases to list the currency amounts of your invoices. Run other versions of the report to print the rest of your IVA ledgers. | Per tax regulations |
The following table lists other periodic activities that J.D. Edwards recommends for daily operations. The table represents a series of control reports and verification programs with a brief description of each and the frequency with which J.D. Edwards recommends the procedures be executed.
Procedure | Program | Description | Frequency |
---|---|---|---|
Clean control headers | P007031 (World) | Run the Batch to Detail/Out of Balance Integrity Report to delete batch headers from the Batch Control Records file (F0011) with no transactions.
NOTE: If you do not want to erase the headers of certain types of batches even though no transaction details exist for the batch, enter X in the Description-2 field of the user defined codes table 98/IT against the batch type that should not be deleted. The program also updates any batch header to D (posted) if the individual transactions in the batch have already been posted, and indicates any out-of-balance batches. |
Every night |
Update Supplier Master Table | P04802 (World) | Run the Global Update A/P Records with A/B Information program to update the Accounts Payable Ledger based on the information in the Supplier Master file (F0401).
The program updates the following data: First ten category codes of the master table Parent company Alpha name |
Every night |
Update the A/R Master table | P03802 (World) | Run the Update A/R from Address Book program to update the Accounts Receivable Ledger (F0311) based on the information in the A/R Master table.
The program updates the following data: First ten category codes of the master table Parent company Alpha name |
Every night |
Update of Master Table word search table | P01820 (World) | Run the Refresh Query Search Word Files program to update the word search table of the Master Table. | Every night |
Update the chart of accounts word search table | P09BDWRD (World) | Run the Build Word Search File program to update the Chart of Accounts Word Search table. | Monthly, and any time the chart of accounts is changed |
Update the menu search table | J980090 (World) | Run the Build Menu Search File program to update the Menu Word Search table. | Before going live, and any time existing menus are changed or new menus are added |