This chapter contains these topics:
Update your account balances with amounts from journal entries by posting the journal entries to the general ledger. After posting, the system provides several reports that you can use to view the journal entries that have been posted.
From Manufacturing Systems (G3), choose Manufacturing Accounting
From Manufacturing Accounting (G3116), choose Post General Journal
You can only run one post at a time. You must ensure that all post menu selections are routed to the same job queue and that the job queue only allows one job to process at a time.
Caution:JD Edwards World strongly recommends that you do not customize the post program.
The post is the third step of the JD Edwards World three-tier process. The post itself consists of two phases, the pre-post process and the post process.
The pre-post process consists of several elements:
|Selection||The Post General Journal program selects unposted, approved transactions with a batch type 0 and other criteria specified in the processing options. These transactions come from the Account Ledger table (F0911).|
|Detail edit||The program edits each transaction to determine whether:
|Batch edit||The program edits each batch to ensure that it is approved and in balance. If the program finds any errors, it does not post the batch.|
|Posting Edit report||This report lists all batch errors that have occurred. It prints in batch sequence.|
|Error conditions||If any transaction in the batch is in error, the program places the entire batch in error, which prevents it from posting.|
Note:You should not make changes to the accounts, automatic accounting instructions (AAIs), intercompany settlements, general accounting constants, or processing options when you run the post.
Posts transactions to the Account Balances table (F0902) and marks each transaction and the batch header as posted in the Account Ledger table and the Batch Control table (F0011)
Changes the batch status for the Batch Control table to D
Marks each transaction with a status of P (posted)
Creates reversing entries, if requested
Generates two reports:
Posting Journal report, which lists the transactions posted to the Account Balances and the Account Ledger tables
Detailed Post Error report, which lists the detail transactions in a batch if there is a balancing error.
Verify that the batch has an approved status. See Section 19.1, "Reviewing General Ledger Batches."
Verify that the post is submitted to a single-threaded job queue.
Each time you run Post General Journal, the program generates the Posting Edit Report. This report lists errors detected during the post. If the program finds errors, it does not post the batch. You must correct all errors in order for the batch to be posted.
|Batch not approved for posting||This error message is caused by a batch with a pending or error status.|
|Account not set up in Account Master table (F0901)||Two situations can cause this error message:
|Batch journal entries out-of-balance||This error message occurs when debits do not equal credits. If the out-of-balance journal entry was entered in error, correct the error and post the batch again.
Other situations can cause a journal entry to be out-of-balance. For example:
Each time you run Post General Journal, the program generates the Posting Journal report during the post process. This report lists the transactions posted to the Account Balances and Account Ledger tables.
From Inventory Reports (G41111), choose Inventory Integrity Reports
From Inventory Integrity Reports (G41113), choose Item Ledger/Account Integrity
The lines that print are summary lines, that is, the amounts on a line represent the total for a specific document type, document number, and key company. No other total lines print. You can run this report as many times as needed because no tables are updated.
If you use summarized journal entries for work orders, the program uses the Work Order Cross-Reference table (F3106) to locate the material issue transactions (IM), completions (IC), and scrap transactions (IS) against those summarized work orders.
The system uses next numbering for the GL doc number rather than using the work order number. The system implements Work Order Cross-Reference (P3106) in order to cross-reference the work order number to the G/L document number. You can review this cross-reference on the Work Order Processing menu (G3116), using the GL Review by WO Number menu (option 22).
Following is a grid of the files and fields that are relevant to manufacturing work order cross-referencing:
|Batch Number||Updated in field (ICU) in Cardex, Work Order Cross Ref and G/L Detail are generated with Next Number Product Code = 00, Use(positioned line) = 1.|
|Document Number||Updated in field (DOC) in Cardex and G/L Detail are generated with Next Numbers, Product Code =09, Use = 2.|
If you determine that there is not a true integrity issue between the F4111 and F0911 files, but the report is showing a discrepancy, do the following:
Determine which number (per the report) is inaccurate by reviewing the related Cardex transaction and journal entry.
If the Item Ledger (F4111) amount is wrong, check the data selection and sequencing. Try testing with the exact setup from the demo version.
If the Account Ledger (F0911) amount is wrong, check the UDC table 41/IN and the related AAI table setup.
Section 18.1, "Creating Journal Entries" for more information on summarized journal entries.
From Master Directory II (G1), choose World Writer Reporting
From World Writer Reporting (G82), choose Manufacturing
These reports help you review your production costs and variances. You might want to run them before you run Journal Entries for Variances, or you can run them after Journal Entries for Variances to verify the accuracy of the journal entries.
Complete the following tasks:
Review Work Order Activity (Amounts)
Review Work Order Activity (Units)
Review Engineering Variance
Review Planned Variance (to Current)
Review Planned Variance (to Standard)
Review Material Usage Variances
Review Efficiency Variances
Review Total/WIP and Other Variances
Review Open Work Order Valuation
Review Completed Work Order Valuation
Review Work Order Amount Variances
Review Variance Flag Exceptions
This report lists standard, current, planned, actual, and completed amounts of work orders.
This report lists work orders and their planned variances (standard amounts compared to planned amounts). These variances are informational only. Journal entries are not created from these amounts. Journal entries for planned variances come from comparing current amounts to planned amounts.
This report shows the standard, actual, completed, and outstanding balance of amounts by cost component and item for your open work orders. The program calculates the total for each type of cost by work order and a grand total of each cost for all of the work orders listed.
This report shows the standard, actual, completed, and outstanding balance amounts by cost component and item for your completed work orders. The Journal Entries for Work in Process or Completions and Journal Entries for Variances programs have already been run for these work orders. The program calculates the total for each type of cost by work order and a grand total of each cost for all of the work orders listed.
This report allows you to view Variance Flag Exceptions which are work order statuses greater than 96 but Variance Flag is not equal to 3.