Understanding the Localized Cardex
Use the Updating the Localized Cardex and Accounting process to update the F76H611 table with the actual costs calculated for products in progress and manufactured products. The process also makes an adjustment journal entry. Be sure to take into account the difference between the cost accounted to standard cost and the F0911 table new actual cost of the items.
You must have run the actual cost calculation process in final mode prior to running the Cardex and Accounting update process (R76H611).
The Cardex and Accounting update process updates all the records in the F76H611 table that meet these conditions:
The branch/plant of the cardex transaction belongs to a transactional company that belongs to a legal company.
Products in progress and manufactured products are processed with Method 07 as main costing method of sales and inventories.
Raw materials and resale products are not processed since they are calculated by their actual cost in the standard way.
The accounting dates of cardex transactions must be within the run period of the actual cost calculation.
Updating the localized cardex is critical because the inventory ledger obtains item movements and balances from the F76H611 table.
The program creates a journal entry to indicate the difference between the inventory value and the cost of goods sold by the cost change of the item. This example illustrates a journal entry with a value greater than that of the inventory and the AAIs used to create it:
Concept |
Debit |
Credit |
AAI |
---|---|---|---|
A1 |
X USD |
n/a |
3130 |
X1 |
X USD |
n/a |
3130 |
X2 |
X USD |
n/a |
3130 |
X4 |
X USD |
n/a |
3130 |
To Inventory Difference |
n/a |
X USD |
3910 |
Sales Cost |
X USD |
n/a |
4124 |
To Cost Difference |
n/a |
X USD |
3911 |
When you run the R76H611 program in proof mode, the system generates a PDF file containing a detail of cost differences between the F4111 table and the F76H611 table, taking into account the actual cost calculated by the process. It indicates the entries to be generated and the accounts on which the accounting charge will be performed.
When you run the program in final mode, the system generates a PDF file similar to that of the proof mode. In addition, it generates the document number and batch number and updates the F76H611 table with the actual cost. It also creates journal entries taking into account the difference in cost in the F0911 table. Then you can post the batch generated by the process.