Reconciliation of adjusted costs and accounting

costs and accounting
28 Views

When you post inventory transactions, such as sales shipments, purchase invoices, or inventory adjustments, the changed item costs are recorded in the value entries. To reflect this change in inventory value in your financial statements, the adjusted costs must also be posted to the associated inventory accounts in the general ledger, such as the inventory account, the adjustment account, and the inventory posting account in the general ledger.

Unless you have selected the Automatic Cost Accounting check box in the Inventory Settings window , adjusted costs are not dynamically posted to the general ledger. Also, the inventory issue value is not calculated in relation to a sale. Therefore, you must manually post to the general ledger by running the Post Inventory Cost to General Ledger batch job to update the general ledger entries and optionally print a report of posted value entries.

 Important

Before you use this batch job, you must run the Adjust Costs: Item Entries batch job . This ensures that when you run this batch job, the costs posted to accounting are up to date. This is a cost adjustment.

To validate manually adjusted costs

Post adjusted costs to the general ledger manually by running the batch process. When you run the batch process, accounting entries are created based on value entries. To calculate the value to post, it uses the difference between the Total Cost (Actual) and Cost Posted to General Ledger fields in the value entries. If you selected the Post Expected Cost to General Ledger check box on the Inventory Setup page , the batch process also posts the difference between the Total Cost (Expected) and Expected Cost Posted to General Ledger fields to the suspense accounts in the general ledger. You can post the entries so that they are summarized by posting group.

Option  Designation

Accounting method Batch processing can post the inventory value to accounting by posting group or by posted entry. If you post by entry, you get a detailed specification of the influence of inventory on accounting, but you also get many entries. If you post by posting group, batch processing creates one accounting entry per posting date per combination of posting groups. This means that one accounting entry is created for each combination of posting dates, market posting groups, product posting groups, inventory posting groups, and warehouse codes. In addition, batch processing creates separate accounting entries for costs with a different sign.

Document number In this field, you can enter a document number if you have chosen the Validation By stock accounting group option . The document number is displayed on validated entries.

Select this field if you want the batch process to validate in accounting automatically. If you choose not to validate the costs in accounting, the batch process will only perform a test print showing the values that can be validated in accounting and the status will indicate: Test print (not validated) .

When you run this batch job, you might encounter errors related to missing configuration or incompatible dimension configuration. If the batch job finds errors in the dimension configuration, it ignores them and uses the dimensions from the value entry. For any other errors, the batch job skips posting the value entries and lists them at the end of the report in the section titled “Skip Entries.” To post these entries, you must correct the errors. For example, if you did not select the Post Expected Cost to Ledger check box in the Inventory Setup window , the last section of the report lists the value entries that are ignored because they represent expected costs.

To view the list of errors before running the validation batch job, you can generate the Validate Adjusted Costs – Test report . The test printout lists all errors detected during the validation test. You can then correct the errors and run the Validate Adjusted Costs batch job without skipping any entries.

If you simply want to preview the values that could be posted to the general ledger without actually performing the posting, you can run the Post Adjusted Costs batch jobTo do this, clear the Post field on the selection page. This way, when you run the batch job, the report is produced showing the values that are ready for posting to the general ledger, but they are not posted.

By admin

Leave a Reply

Your email address will not be published. Required fields are marked *