Post Inventory Cost to G/L Batch Job

Records the quantity and value changes to the inventory in the item ledger entries and the value entries when you post inventory transactions, such as sales shipments or purchase receipts.

Unless you have selected the Automatic Cost Posting check box in the Inventory Setup window, inventory costs are not recorded dynamically in the general ledger, and COGS is not calculated in connection with a sale. Therefore, you must post to the general ledger manually by running the Post Inventory Cost to G/L batch job to update the general ledger and potentially print a report of the value entries that are posted.

The batch job uses value entries as its basis. To calculate the value to post, it uses the difference between the Cost Amount (Actual) field and the Cost Posted to G/L field in the value entries. If you have selected the Expected Cost Posting to G/L check box in the Inventory Setup window, then the batch job also posts the difference between the Cost Amount (Expected) field and the Exp. Cost Posted to G/L field to interim accounts in the general ledger.

Note

If you have not selected the Expected Cost Posting to G/L check box in the Inventory Setup window field, then the last section of the report will list value entries that are skipped because they represent expected costs.

Note

If the batch job encounters an error involving dimensions or dimension setup, then the batch job overrides the error and posts the entry to the general ledger using the dimensions of the value entry.

If you want to make sure that the batch job does not encounter any errors, you can run the Post Invt. Cost to G/L - Test report to see all errors that could be encountered. You can then fix the errors, and run the Post Inventory Cost to G/L batch job, knowing that it will process all entries. For more information, see Post Invt. Cost to G/L - Test.

Important

Before you use this batch job, you should run the Adjust Cost - Item Entries batch job. This ensures that, when you run this batch job, the costs that will be posted to the general ledger are up to date.

Options

Option	Description
Posting Method	The batch job can either post inventory value to the general ledger per posting group or per posted entry. If you post per entry, you achieve a detailed specification of how the inventory affects the general ledger, but you also get numerous G/L entries. If you post per posting group, the batch job creates a general ledger entry per posting date per posting group combination. This means that a general ledger entry is created for each combination of posting date, general business posting group, general product posting group, inventory posting group, and location code. In addition, the batch job creates separate general ledger entries for costs with different signs.
Document No.	In this field, you can enter a document number if you have chosen the Post per Inventory Posting Group option. The document number will appear on posted entries.
Post	Select this field if you want the batch job to post to the general ledger automatically. If you do not choose to post the inventory cost to G/L, the batch job will only print a test report showing the values that can be posted to the general ledger, and on the report will appear: Test Report (not posted).

Tip

For more information on how to work with batch jobs, see How to: Run Batch Jobs and How to: Set Filters. For assistance in finding specific pages, see Search.

See Also

Other Resources

Posting Inventory Cost to the General Ledger
Inventory - G/L Reconciliation
Expected Cost Posting to G/L