11 Calculating Inventory Adjustment and Actual Cost for Peru
This chapter contains the following topics:
-
Section 11.1, "Understanding the Inventory Adjustment and Actual Cost Calculation Process for Peru,"
-
Section 11.3, "Entering Indirect Costs, Bill of Material Information, and Actual Costs for Peru"
11.1 Understanding the Inventory Adjustment and Actual Cost Calculation Process for Peru
Calculating inventory adjustment and actual cost includes functionality from the JD Edwards EnterpriseOne Inventory Management, JD Edwards EnterpriseOne Manufacturing, JD Edwards EnterpriseOne Product Data Management, and JD Edwards EnterpriseOne Advanced Cost Accounting systems.
For the year for which you make year-end adjustments, you must run the inventory inflation adjustment and actual cost calculation processes for raw materials and resale products.
11.1.1 Actual Costs
In order to calculate actual cost, products must comply with this setup:
| Products | Setup | Description |
|---|---|---|
| Raw materials and resale | Method 02 (Weighted Average Cost) must be set up as the main method of sales and inventories in the Item Cost File (F4105) table. | Legislation prescribes that products be valued according to their Weighted Average Cost.
The JD Edwards EnterpriseOne Inventory Management system provides this functionality. |
| Products in progress and manufactured | Method 07 (Standard Cost) must be set up as the main method of sales and inventories in the F4105 table.
Method 02 must be set up as secondary method in the F4105 table. |
Method 07 is typically used in manufacturing. The localization obtains the actual cost to weighted average cost and updates it according to Method 02. |
Additionally, these assumptions apply:
-
The actual cost calculation process is used only for discrete production and is not used for continuous production.
-
Products have the same setup in all branch/plants. The actual cost calculation is made according to the product costing level.
-
The actual cost is calculated according to Method 02 (weighted average cost).
-
Batch programs run by the actual cost process must be run from the Actual Cost Process Header program (P76H6001).
These programs and systems have been localized to meet Peruvian legal requirements for the actual cost calculation of products in progress and manufactured products:
-
JD Edwards EnterpriseOne Advanced Cost Accounting system information interface to the Item Cost Component Add-Ons (F30026) table.
-
The program that creates an actual bill of materials according to the period production in which the process is being run.
-
The Actual Cost Calculation of Products in Progress and Manufactured Products program.
-
The Localized Cardex Update program according to the actual cost calculation of products in progress and manufactured products.
-
The program that generates a journal entry by the cost difference of inventory and goods sold, between the actual cost and that registered by the system as standard cost.
Actual cost calculation by weighted average cost of WIP and FG is complex due to the large number of variables that affect the cost of a manufactured item. Variables include the materials actually used to produce the item, the labor cost used, production time, labor expenses, machinery cost, machine hours, and overheads such as electricity and power.
11.1.2 Example: Weighted Average Cost (WAC)
To calculate the actual cost of products in progress and manufactured products, it is necessary to obtain the unit cost of raw materials. This unit cost is obtained from the weighted average cost of the item according to the Actual Item AS OF File (F76H6112) table. If, for example, you want to obtain the actual cost of products in progress and manufactured products for period 11, you must obtain the weighted average cost of raw materials for period 11 from the F76H6112 table, as in this example:
| Period | Balance (quantity) | Balance (in USD) | Weighted Average Cost |
|---|---|---|---|
| Period 10 | 100 | 446 | n/a |
| Period 11 | 20 | 118 | n/a |
| Total | 120 | 564 | 4.7 |
The system calculates the unit cost of the raw material xx, the value USD 4.7 for the calculation of products in progress and manufactured products. Such value does not update the F4105 table; it is used only for the purpose of calculating the actual cost of products in progress and manufactured products. The as-of calculated unit cost was used for raw materials since the unit cost in the F4105 table at the time of the actual cost calculation is not necessarily the raw material cost corresponding to the run period.
The actual cost calculation process involves running two batches:
-
The first batch corresponds to the Actual Cost Simulation report (R76H6812).
This batch program updates the actual cost calculation and simulates those in the F30026 table, but does not update the F4105 table with the simulated cost. This batch is similar to the Cost Simulation (R30812) program and has the same processing options.
Note:
You must run the Actual Cost Simulation program when working with Method 02 (weighted average cost). It is recommended that you do not modify the processing options for the Actual Cost Simulation program. -
The second batch corresponds to the cost generation, or freezing, of actual costs obtained from the Item Actual Cost Component (R76H6835) program.
This batch may be run in proof or final mode. The final mode freezes the cost in the F30026 table, updates the F4105 table with the unit cost calculated for products in progress and manufactured products according to the 02 weighted average cost costing method, and updates the F76H6105 table. This batch is similar to the R30835 cost freezing standard program and has the same processing options though it does not update the accounting.
Note:
Both batches must be run for Method 02 (weighted average cost). It is recommended that you do not modify the processing options for the Actual Cost Simulation - Build (R76H6812) program.
It is important that the localized As Of process be run to enable the system to obtain the appropriate unit cost of raw materials.
11.1.3 Overhead Allocation
The JD Edwards EnterpriseOne standard functionality of the JD Edwards EnterpriseOne Advanced Cost Accounting system is used to calculate the tracking of indirect manufacturing costs by product. The JD Edwards Enterprise One Advanced Cost Accounting system performs overhead allocation, or cost object tracking. For this reason, the scope of this localization consists in sending the costs obtained by product through the JD Edwards EnterpriseOne Advanced Cost Accounting system to the F30026 table.
The allocation of these cost components of products in progress and manufactured products must be performed through the JD Edwards Enterprise One Advanced Cost Accounting system for the period in which the actual cost process is run:
-
Actual labor expenses
-
Actual machinery costs
-
Actual costs
All costs considered necessary can be distributed in order to obtain the cost of products in progress and manufactured products, such as electricity costs.
Depending on the setup used for the expense allocation in the JD Edwards Enterprise One Advanced Cost Accounting system, the results of the expense allocation by item is recorded in the F1602 table or in the F1642 and F16421 tables. The localization of overhead allocation consists of sending information from those files to the F30026 table.
The JD Edwards Enterprise One Advanced Cost Accounting system provides a broad functionality to perform the expense allocation per item. Through the JD Edwards Enterprise One Advanced Cost Accounting system, a unit cost must be obtained by product cost concept.
11.1.4 Prerequisites
Before you calculate inventory adjustments and actual cost, you must complete the setup tasks in these sections discussed in the Using Inventory Inflation Adjustment chapter:
Before sending overhead information to the F30026 table:
-
Verify that the overheads allocation has been performed in the JD Edwards Enterprise One Advanced Cost Accounting system.
-
Verify that overheads allocation is performed by product.
-
Verify that the relationship between account and cost type is set up.
-
Verify that the indirect cost of the actual cost process are set up.
11.1.5 Legal Requirement
According to Section 62° of the Rent Tax Act, goods valued at acquisition or production cost must uniformly apply the same valuation method or methods from year to year.
According to Section 35° of the Rent Tax Act Regulations, most companies must keep a standard cost system that valuates their goods to actual cost. The taxpayer must provide the report and the technical studies that support the application of the cost system when required by SUNAT (Superintendencia Nacional de Administración Tributaria).
11.2 Common Fields Used in This Chapter
- To/From Period
-
Enter the period which the actual cost calculation process is run.
- GI Status
-
Enter the overhead process status.
P: Proof mode.
F: Final mode.
- Bill of Materials Status
-
Enter the status of the bill of materials process.
F: Final mode.
- Actual Cost Status (CR)
-
Enter the actual cost calculation process status.
T: The status after executing the Actual Cost Simulation process.
P: Proof mode.
F: Final mode.
- Localized Cardex Status
-
Enter the status of the Updating the Localized Cardex and Accounting process.
P: Proof mode.
F: Final mode.
- WO Required Date (DRQJ field in the F4801 table)
-
Enter the date used to obtain the WO that is taken into account in the actual cost calculation process. To add the WO to the actual bill of materials calculation, the system compares the WO required date with the period selected to run the actual cost process.
- WO End Date (STRX field in the F4801 table)
-
Enter the date used to obtain the WO that is taken into account in the actual cost calculation process. To add the WO to the actual bill of materials calculation, the system compares the WO end date with the period selected to run the actual cost process.
- WO Status
-
Enter the status that WO must have in order to be taken into account in the actual cost process. If the field is left blank, the system does not use the WO status.
- Bill of Materials Type
-
Enter the value for the bill of materials that you want the system to use to create an actual bill of materials in the F3002 table.
- Bill of Materials Status
-
Enter the status of the Actual Bill of Materials process.
- ITM Cost Object Type
-
Enter the cost object type used in the actual cost process to identify a product.
- MCU Cost Object Type
-
Enter the cost object type used in the actual cost process to identify the branch/plant.
- LOCN Cost Object Type
-
Enter the cost object type used in the actual cost process to identify the location.
- LOTN Cost Object Type
-
Enter the cost object type used in the actual cost process to identify a batch.
- Costing Method
-
Costing method used for calculating the actual cost.
Important:
Enter the 02 Weighted Average Cost method required by law. - General Ledger Type
-
Enter the general ledger type of the expenses accounts derived from the JD Edwards Enterprise One Advanced Cost Accounting system.
- IE Status
-
Enter the status of the overheads process.
11.3 Entering Indirect Costs, Bill of Material Information, and Actual Costs for Peru
This section provides overviews of indirect costs, bills of material, and actual costs; lists prerequisites; lists the forms used to enter indirect costs bill of material information, and actual costs; and discusses how to Set processing options for Overheads for Actual Cost Process Header (P76H6001).
11.3.1 Understanding Indirect Costs
Records from the F1602, F1642, and F16421 tables must meet these conditions in order to be selected:
-
Every selected record must have an associated product.
The system obtains the product from the cost object where it is kept or from the Item Cost Code field.
-
Every selected record must have a valid branch/plant.
If the branch/plant is not in any cost object of the record, it must be entered manually in the screen header.
-
Every selected record must have an associated cost in the period column where the actual cost is being processed.
For example, if period 12, 2003 is being processed, the 721431 item must have an associated cost for period 12.
-
The account/cost type relationship must be set up.
The records you select through this application are sent to the F76H6002 and F76H6003 tables. After the system updates these tables, select either Indirect Cost Proof Mode or Indirect Cost Final Mode from the Work With Item Cost Component WF form. If you select proof mode, the F76H6004 table is updated. If you select final mode, the F76H6004 and F30026 tables are updated.
11.3.2 Understanding Actual Bills of Material
Generate the actual bill of materials of the items manufactured within the period in which the actual cost calculation process is run, thus obtaining the actual consumptions of their components.
Any product in progress or product manufactured by a standard procedure has a specific bill of materials that indicates the component quantities needed to manufacture a certain item. Standard bills of materials are located in the F3002 table and typically have a bill type of M.
The actual bill of materials calculation process completes the F3002 and F76H6008 tables and generates a PDF file containing a detailed list of units manufactured by item.
|
Note: The actual bill of materials generation may be run as many times as necessary, provided the last actual cost calculation process has not been run. Each new process run deletes the records generated in the F3002 table for the specified bill type and also deletes the record in the F76H6008 table. |
To calculate the actual bill of materials, all products in progress and manufactured products production entries from work orders that meet these conditions:
-
Selected work order branch/plants must belong to a transactional company that belongs to a legal company.
-
The required date (DRQJ field from the F4801 table) or work order end date (STRX field from the F4801 table) is compared with the actual cost process run in the period. Work order dates are selected for the calculation provided they are within the period.
-
Work orders meet the status entered into the actual cost process header.
-
Selected work orders meet the document type and work order type specified in the setup.
-
Products with a stock type different from R in the Item Master are taken into account.
Note:
To calculate the actual bill of materials, the system converts everything to the primary unit of measure (UM).
11.3.3 Understanding Actual Costs
Run the cost simulation to verify the costs that have been generated thus far. Then, run the Actual Cost Generation process in proof or final mode. When you run the process in final mode, it updates the F76H6007, F30026, and F4105 tables according to Method 02 (Weighted Average Cost).
11.3.4 Prerequisites
Before generating the actual bill of materials:
-
Verify the actual bill of materials generation process setup.
-
Verify that the indirect cost calculation has been performed.
-
Verify that the order type and allowed WO type relationship is set up.
11.3.5 Forms Used for Entering Indirect Costs, Bill of Material Information, and Actual Costs
| Form Name | Form ID | Navigation | Usage |
|---|---|---|---|
| Work with Actual Cost Process | W76H6001A | Actual Cost (G76P31), Actual Cost Process Header. | View and select existing records. |
| Actual Cost Process | W76H6001B | Click Add on the Work with Actual Cost Process form. | Add indirect cost, bill of material, and actual cost information. |
| Work With Item Actual Cost File | W76H6105A | On Actual Cost Process, select Actual Cost from the Form menu.
Select Actual Cost Simulation from the Row menu to run cost simulation. Select Actual Cost Generation to run cost generation in either proof or final mode. |
Run the cost simulation and generation to enter actual costs. |
| Manufactured Items | W76H6008A | On Actual Cost Process, select Actual BOM from the Form menu. Select Actual BOM Gen. from the Form menu | Generate an actual bill of materials. |
| Bill of Material | W76H6008B | Select Bill of Material from the Row menu on the Manufactured Items form. | Inquire on the actual bill of materials that you generated. |
| Work With Item Cost Component WF | W76H6002F | On Actual Cost Process, select Indirect Cost from the Form menu. | Select costs to update. |
| Cost Analyzer Balances Selection | W76H6002B | Select Balances Selection from the Form menu on the Work With Item Cost Component WF form. | Select the records from the F1602 table to update.
Update records interactively or by batch mode. |
| Rates Selection | W76H6002C | Select Rates Selection from the Form menu on the Work With Item Cost Component WF form. | Select F1642 and F16421 records to update.
Update records interactively or by batch mode. |
11.3.6 Setting Processing Options for Overheads for Actual Cost Process Header (P76H6001)
Processing options enable you to specify the default processing for programs and reports.
11.3.6.1 Indirect Cost
- ITM Cost Object Type
-
Enter the cost object type used by the actual cost process to identify a product.
- MCU Cost Object Type
-
Enter the cost object type used by the actual cost process to identify the branch/plant.
- LOCN Cost Object Type
-
Enter the cost object type used by the actual cost process to identify the location.
- LOTN Cost Object Type
-
Enter the cost object type used by the actual cost process to identify a batch.
- Costing Method
-
Enter the costing method used for calculating the actual cost.
Important:
Enter the method 02 Weighted Average Cost required by the legislation. - Ledger Type
-
Enter the general ledger type of the expenses accounts derived from the JD Edwards EnterpriseOne Advanced Cost Accounting system.
11.3.6.2 Actual Bill of Material
- 1. Work Order Selection Date
-
Enter the date to use for the work order. Values are:
1: Required date.
2: End date.
This date is used to obtain the WO that is taken into account in the actual cost calculation process. To add the WO to the actual bill of materials calculation, the system compares the date entered by the user with the period selected to run the actual cost process.
- 2. WO Status
-
The status that WO must have in order to be taken into account in the actual cost process. If you leave this field blank, the system does not use the WO status.
- Bill of Materials Type
-
The system creates an actual bill of materials in the F3002 table using the value in this field.
11.3.6.3 GL Generation
- Doc Type
-
Enter the document type to be used to indicate journal entries.
You should enter a special document type in order to differentiate movements by the actual cost difference.
- Ledger Type
-
Enter the GL type to identify where journal entries generated by cost difference should be sent.
- Batch Type
-
Enter the batch type that you want to use to generate journal entries. The recommended value is N.
11.4 Updating the Localized Cardex for Peru
This section provides an overview of the localized cardex and lists the forms used to update the localized cardex.
11.4.1 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.
11.4.2 Form Used to Update the Localized Cardex
| Form Name | Form ID | Navigation | Usage |
|---|---|---|---|
| Work with Actual Cost Process | W76H6001A | Actual Cost menu (G76P31), Actual Cost Process Header. | Locate existing records. |
| Actual Cost Process | W76H6001B | Click Add on the Work with Actual Cost Process form. | Enter information required to update the cardex. |
| Cardex at Actual Cost | W76H611B | On Actual Cost Process, select Cardex to Actual Cost from the Form menu. Select to run in either proof or final mode from the Form menu. | Update the localized cardex. |
11.5 Printing the Inventory Ledger for Peru
This section provides an overview of the inventory ledger and discusses how to:
-
Run the Inventory Ledger by Units (R76P6540) program.
-
Run the Inventory Ledger by Amounts (R76P6545) program.
-
Set processing options for Inventory Ledger.
11.5.1 Understanding the Inventory Ledger
The objective of the inventory ledger is to reflect for each item the initial balance, the inventory movements, and the final balance for the period. All movements are valued according to their unit. You must run total cost, indirect cost, and actual cost processes in final mode in order to run this process. The report may be run as many times as necessary. You can run the inventory ledger by units (R76P6540) or by amounts (R76P6545).
To generate inventory ledgers, the process goes through the F76H6112 and the cardex F76H611 according to processing options and data selection parameters.
11.5.1.1 Data Selection
In addition to selecting by legal company (using a processing option), use data selection to specify whether the ledger is for one or many plants, for one or many items, or for one or many values of the category code defined in the processing option.
If you do not enter data selection, the report lists all inventory movements for those plants that make part of the transactional companies of the legal company selected in the processing option.
The report is divided into sections:
-
Plant.
-
Product type (raw material, product in progress, manufactured product and resale product).
-
Item code.
-
Initial and final balance for cuts and total level.
11.5.1.2 Inventory Ledger
According to Peruvian legislation, an inventory ledger must be generated on an annual basis at the closing of each business year. You can generate an inventory ledger after:
-
The actual cost and inventory adjustment processes have been run in final mode.
-
The localized As Of generating (R76H6542) program and the localized As Of generating (R76H397) program for previous years have been run.
In order to issue an inventory ledger you should perform these tasks:
-
Set up items.
-
Run the Localized As Of Generating program.
-
Generate Initial Balance in the Localized As Of.
-
Run the Actual Cost process in final mode.
-
Run the indirect cost process in final mode.
-
Issue the inventory ledger.
11.5.2 Printing the Inventory Ledger by Units (R76P6540) (Release 9.1 Update)
The Inventory Ledger by Units report layout is in the format prescribed by Peruvian legal reporting requirements. See an example of the report layout at the end of this section. The following table lists the column numbers and description of the reporting fields in the report layout examples.
| Column Name | Explanation |
|---|---|
| Date | GL Date field, retrieved from the F76H611 table. |
| Type | Retrieved from UDC table 76P/DT. |
| Serial | The first digits of the Invoice Number field. In the case of purchases, the system retrieves this value from the F0411 table. In the case of sales, the system retrieves it from the F03B11 table. In the case of operation cardex, the serial is blank. |
| Number | Invoice Number field (without the serial) from the F0411 or F03B11 table. In the case of Cardex operations, the system retrieves this number from the F76H611 table. |
| Operation Type | Retrieved from UDC table 76P/OT. |
| Input | Quantity order in the case of purchases, retrieved from the F76H611 table. |
| Output | Quantity order in the case of sales, retrieved from the F76H611 table. |
| Final Balance | Initial balance plus the quantity of order. |
11.5.3 Running the Inventory Ledger by Units (Release 9.1 Update)
Select Inventory (G76P41), Inventory Ledger by Units.
11.5.4 Printing the Inventory Ledger by Amounts (R76P6545) (Release 9.1 Update)
The Inventory Ledger by Amounts report layout is in the format prescribed by Peruvian legal reporting requirements. See an example of the report layout at the end of this section. The following table lists the column numbers and description of the reporting fields in the report layout examples.
| Column Name | Explanation |
|---|---|
| Date | GL Date field, retrieved from the F76H611 table. |
| Type | Retrieved from UDC table 76P/DT. |
| Serial | The first digits of the Invoice Number field. In the case of purchases, the system retrieves this value from the F0411 table. In the case of sales, the system retrieves it from the F03B11 table. In the case of operation cardex, the serial is blank. |
| Number | Invoice Number field (without the serial) from the F0411 or F03B11 table. In the case of Cardex operations, the system retrieves this number from the F76H611 table. |
| Operation Type | Retrieved from UDC table 76P/OT. |
| Input | In the case of purchases, quantity, unit cost and extended cost, retrieved from the F76H611 table. |
| Output | In the case of sales, quantity, unit cost and extended cost, retrieved from the F76H611 table. |
| Final Balance | Initial balance plus the quantity, unit cost and extended cost of order. |
11.5.5 Running the Inventory Ledger by Amounts (Release 9.1 Update)
Select Inventory (G76P41), Inventory Ledger by Amounts.
11.5.6 Setting Processing Options for Inventory Ledger (Release 9.1 Update)
Processing options enable you to specify the default processing for programs and reports.
11.5.6.1 General
- 1. Legal Company
-
Enter the address book number of the company to be reported as the legal company.
- 2. Century
-
Enter the century to run the report in.
- 3. From Fiscal Year
-
Enter the year from which it is to be reported.
- 4. From Period
-
Enter the period from which it is to be reported.
- 5. To Fiscal Year
-
Enter the period to which it is to be reported.
- 6. To Period
-
Enter the period to which it is to be reported.
- 7. Category Code
-
Enter the category code number (6 to 10) used to differentiate the product type. The default number is 6.
Enter the category code used to define the document type and whether it is manufactured or sold. This value is calculated by item/plant. Coding defines control divisions in the report.
- 8. Mode
-
Enter 1 to run the program in final mode. Leave this processing option blank to run the program in proof mode. In proof mode, the system generates the report, but does not update any tables.
- 9. Begin Balance Op. Type
-
Enter the default operation type used for begin balance.
11.6 Calculating Inventory Inflation Adjustments for Raw Materials and Resale Goods for Peru
This section provides an overview of inventory adjustment for raw materials and resale goods, and discusses how to:
-
Generate the Localized As Of report.
-
Set processing options for the Localized As Of report.
-
Generate the Initial Balance in the Localized As Of report.
11.6.1 Understanding Inventory Adjustments for Raw Materials and Resale Goods
You must run the inventory inflation adjustments for raw materials annually at year end. The processes are based on these assumptions:
-
The stock of raw materials or resale products existing at the end of the balance is adjusted to its replacement cost to the specified date.
-
The stock of raw materials must be set up in the system by Method 02 (weighted average cost) as the primary costing method.
Goods must be valued by the weighted average cost as required by government regulations.
-
The replacement cost calculation is treated differently for domestic and imported origin raw material or resale products.
-
All companies define the business year as January through December.
11.6.1.1 Setting Up Item Coding
You must set up the country of origin for each branch/plant relationship to determine whether it is an imported or domestic item.
If the country of origin is different from the country code defined by the company, the item is imported. If they are equal, the item is domestic.
11.6.1.2 AAIs for Inflation Adjustments
Set up the 3910 and 3911 AAIs.
11.6.1.3 Indexes
Inventory adjustment maintains the inflation adjustment indexes. Indexes are identified by a code, for example, adjustment code in UDC (76A/CA).
|
Note: Indexes must not be changed or deleted after they are used for an adjustment. |
11.6.1.4 Exchange Rates
Exchange rates are a standard function of the JD Edwards EnterpriseOne Inventory Management system.
|
Note: Exchange rates must not be changed nor deleted after they are used for an adjustment. |
11.6.1.5 The Item Ledger As Of Record Generation Report
The Item Ledger As Of Record Generation report (R76H6542) is based on the F76H611 table and generates the As Of transactions in the F76H6112 table.
You must run this report whenever the F76H611 table has been changed, as the F76H6112 table is used for the inventory adjustment calculation.
This report summarizes parallel cardex movements (the F76H611 table) by period in the F76H6112 table.
11.6.1.6 The Create Missing As OF Record Report
The Create Missing As OF Record report (R76H397) generates records in the F76H6112 table and is based on the F76H611 table.
This report adds records to new fiscal year beginnings that have not had any stock movement during the year. It generates a record in the F76H6112 table for the new fiscal year and completes the initial balance fields with the same quantity and amount that corresponds to the previous balance.
11.6.2 Generating the Item Ledger As Of Record Generation Report
Use one of these navigation:
-
Select Inventory Inflation Adjustment (G76H39), Item Ledger As Of Record Generation.
-
Select Inventory Inflation Adjustment (G76P39), Item Ledger As Of Record Generation.
11.6.3 Setting Processing Options for Item Ledger As Of Record Generation (R76H6542)
Processing options enable you to specify the default processing for programs and reports.
11.6.3.1 General
- Generation
-
Enter 1 to regenerate all the F41112 table. If you leave this field blank, the table is updated with any transaction of the F4111 table that has not been processed yet in the As Of generation. Select the document to generate.
- Regeneration Option
-
Enter 1 to print a final report. If you leave this field blank, the report is printed only if there are errors.
11.6.4 Generating the Create Missing As-Of Record Report
Select Inventory Inflation Adjustment (G76P39), Create Missing As Of Record.
11.6.5 Processing Options for Create Missing As-Of Record Report (R76H397)
Processing options enable you to specify the default processing for programs and reports.
11.6.5.1 General
- Century
-
Enter the two-digit century for which you run the report.
- Fiscal Year
-
Enter the two-digit year for which you run the report.