You can recalculate a cost price in the secondary currency in the same way that the cost price is recalculated in the default currency. However, inventory recalculation and closing in the secondary currency are performed separately from the inventory closing in the default currency.

At the end of the reporting period, you can recalculate the issue cost price in the secondary currency by using any of the following five models:

  • FIFO

  • LIFO

  • LIFO on the order date

  • Weighted average cost price

  • Weighted average cost price on the order date

  1. Click Inventory management> Setup> Inventory> Inventory model groups.

  2. Press CTRL+N to create a new inventory model group.

  3. Click the Inventory modeltab.

  4. In the Inventory modelfield, select the inventory model.

  5. In the Inventory model (cur.)field, select the inventory model.

    Note Note

    The recalculation model for the item cost price in the secondary currency is selected based on the value in the Inventory Model (Cur.)field in the inventory model group that was selected for the item.

  6. On the Setuptab, select the Financial negative inventorycheck box.

  7. Click Inventory management> Setup> Dimension> Dimension groupto set the inventory dimension for each dimension group.

  8. Click Inventory management> Setup> Parameters.

  9. Click the Number sequencestab.

  10. Select the number sequence code for Settlement transaction No, Adjustments vouchers in currency, Closing voucher in currency, and Inventory - Settlement Transaction Number.

  11. Click Inventory management> Periodic> Closing and adjustment in currency> Recalculationto recalculate the cost price in the secondary currency.

  12. In the Recalculate inventory up tofield, enter the recalculation date.

  13. Select the Update ledgercheck box to activate the parameter if the recalculation results are to be reflected in ledger accounts.

  14. In the Specificationfield, select the specification to determine the level of detail that will be posted to the general ledger:

    • Total– Post the sum values for each unique ledger account as a total figure.

    • Item group– Post the sum values for each unique item group in the general ledger.

    • Item number– Post the value for each unique item in the general ledger.

  15. In the Notefield, enter any comments about the recalculation session.

  16. Click Selectto set up additional selection criteria for the current recalculation, if needed.

  17. Click the Generaltab.

  18. In the Maximum throughputsfield, view the number of recalculation iterations.

    Note Note

    During inventory recalculation/closing, inventory transactions are settled beginning with receipt of the inventory receipt and ending with dispatch of the inventory. Transactions are settled for a combination of inventory dimensions with the Financial Inventoryparameter.

  19. In the Minimum throughput adjustmentfield, view the maximum adjustment of the throughput.

    Note Note

    If the adjustment amount for the transaction does not exceed the set parameter, an additional iteration will not be performed.

  20. In the Minimum Percentage of the Quantity Being Settledfield, enter the percentage for the quantity being settled for the weighted average model only.

    Note Note

    If the percentage ratio between issue and receipt is less than what is indicated, the settlement quantity will be increased to the minimum.

  21. In the Minimum Settlement Amountfield, indicate the minimum settlement amount for the weighted average model only.

    Note Note

    If the percentage ratio between issue and receipt is less than what is indicated, the settlement quantity will be increased to the minimum.

  22. Select the Run Recalculation after Closingcheck box to perform an inventory recalculation for the current date after inventory closing on a set date.

    Note Note

    When the account correspondence parameter is activated, cost price adjustment transactions are posted in the ledger cumulatively. When the check box is cleared, it is possible to post transactions for groups or items, depending on the selections made in the Specificationfield.

  23. Click ?Kto recalculate the cost price in the secondary currency.

    Note Note

    After the recalculation, inventory transactions are updated, and any adjustment amounts are allocated to ledger accounts. The amount of the cost price adjustment in currency is saved in the Transactions on itemform ( Inventory management> Item details> Transactions> Updatetab). All recalculation sessions are displayed in the Closing and adjustment – Secondary currency.