Post Inventory Cost to
G/L batch job, which updates the general ledger and
prints a report of the values posted.When you post inventory transactions, such as sales shipments or
purchase receipts, 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. Nor is COGS calculated in connection with a sale, unless
you have selected Automatic Cost Posting. You must post to the
general ledger separately using the
Post Inventory Cost to
G/L batch job, which updates the general ledger and
prints a report of the values 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 option in the inventory setup, then the batch job also posts the difference between the Cost Amount (Expected) and the Exp. Cost Posted to G/L fields to the interim accounts in the general ledger.
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.
If, during the posting of inventory values to the general ledger, the program encounters an error involving dimensions or dimension setup, the program overrides the error and post the entry to the general ledger, using the dimensions of the value entry.
If you would like to make sure that the program does not encounter any errors while processing the batch job, you can run the Post Invt. Cost to G/L - Test report, which shows 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.
You can specify what is included in the report by setting filters. If you do not set any filters, the report will include all your records.
On the Post Value Entry to G/L tab, fill in the standard field filters, or select additional filters. To do this, press F3, click the AssistButton and then select the relevant filter(s).
To print the report, click Print. To see the report on the screen before printing it, click Preview.
To set filters in the report, fill in the fields as follows:
Item No.: In the Filter field, you can enter an item number or a filter on the item numbers whose inventory costs you would like to post to the general ledger. If you do not enter an item number or filter in this field, the program will process all item numbers.
Posting Date: In the Filter field, you can enter the first date in the period from which item entries will be included in the batch job. 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.
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 program 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 program 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: Place a check mark in this field if you want the program 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). The report does not include a list of entries that for various reasons, such as missing setup or erroneous dimension setup, cause errors.
Posting Inventory Cost to the General Ledger
Inventory - G/L Reconciliation