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

Important: To update the cardex and accounting, run the R76H611 batch program in proof or final mode. The proof mode may be run as many times as needed. The final mode cannot be changed. The R76H611 batch program has no processing options and must be run from the P76H6001 program.

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.