Post Invt. Cost to G/L - Test Batch Job

When you post inventory transactions, such as sales shipments, purchase invoices, production output or negative adjustments, the program records the quantity and value changes to the inventory in the item ledger entries and the value entries, respectively. However, unless you have selected Automatic Cost Posting in the inventory setup, the program does not record the inventory costs in the inventory accounts in the general ledger. You must do this separately in the Post Inventory Cost to G/L batch job.

When you run the Post Inventory Cost to G/L batch job, the program might encounter errors having to do with missing setup or incompatible dimension setup. When it encounters these errors, the program either overrides or skips posting the entries. To avoid getting these errors during the actual posting of the inventory costs, you can run the Post Invt. Cost to G/L - Test report. The test report lists all the errors the program encounters during a test posting. You can then fix the errors, and run the inventory cost posting batch job knowing that all entries will be posted.

Before you run either the batch job or the test report, you should run the Adjust Cost - Item Entries batch job.

You can specify what is included in the report by setting filters. If you do not set any filters, the report will include all the value entries that are not yet posted to the general ledger.

On the Post Value Entry to G/L tab, fill in the standard field filters, or you can create additional filters. To do this, press F3, click the AssistButton and then select the relevant filter(s).

On the Options tab, select the appropriate options for how you would like to run the test report.

To print the report, click Print. To see the report on the screen before printing it, click Preview.

Fill in the fields on the request form as follows:

Post Value Entry to G/L

Item No.: In the Filter field, you can enter an item number or a filter on the item numbers that you would like to include in the test report. If you do not enter an item number or filter, all items will be included in the test report.

Posting Date: In the Filter field, you can enter the first date in the period from which item entries will be included in the test report. If you do not enter a date, all item entries will be included.

Click the up-arrow in the lower left-hand corner of the window to see the results of the filter you have defined for the table.

Options

Posting Method: The batch job can either test the posting of inventory value to the general ledger per inventory posting group or per posted value entry. If you post per entry, you achieve a detailed specification of how the inventory affects the general ledger.

Note

If you run the test report with the Per Posting Group option, and the program encounters an error, it will be difficult to determine in which entry the error occurs, since the report will only show the first entry that causes an error in the posting group. There could be more erroneous entries in the posting group. It will therefore also be more difficult to determine where all errors occur. For this reason, we recommend that you run the test report with the Per Entry option.

Document No.: In this field, you can enter a document number if you have chosen the Post per Posting Group option. The document number would appear on posted entries, if this were a real posting to the general ledger.

Show Dimensions: Place a check mark in this field to print the dimensions for each entry or posting group in the report.

Show Only Warnings: Place a check mark in this field to show only the entries that produce errors. If you do not place a check mark in this field, the report will show all entries that could be posted to the general ledger.

Related Topics

Posting Inventory Cost to the General Ledger



© 2009 Microsoft Corporation. All rights reserved.