Defining a Revaluation Profile

  1. Select Inventory Revaluation Profile (IRP) from SunSystems to access the Inventory Revaluation Profile form.
  2. Specify this information:
    Invntry Revaluatn Profile Code
    The unique identifying code for the profile.
    Status
    The status.
    Description
    The description.
    Current Prd Rcpt Ldg Iface Dfn
    This is required if the Current Perd Ldgr Iface Option is set to Use Specified Ledger Interface Definitions. It is used to create ledger postings for current period receipts.
    Current Prd Iss Ldg Iface Dfn
    This is required if the Current Perd Ldgr Iface Option is set to Use Specified Ledger Interface Definitions. It defaults to the Current Prd Rcpt Ldg Iface Dfn setting and is used to create ledger postings for current period issues.
    User Defined Cost Df'n Code
    The User Defined Cost Definition to be used for the revaluation. When the revaluation is posted, the new standard costs are derived from the User Defined Cost set associated with the revaluation.
    User Dfnd Cost Relative Period
    Different User Defined Cost values can be set up for different periods. This value is used to calculate the period used to obtain the User Defined costs. This value is relative to the revaluation period that will be entered when the revaluation is run.
    Item Code Selection Option

    You can define which items are to be included in the revaluation profile using this field.

    Options are:

    • All Items - includes all items in the revaluation.
    • Select by Ranges of Items - enables you to define ranges of items to be included in the revaluation. If you select this option, you can then specify the range on the profile using the Item Selection action. The user can override this selection during the revaluation process. If you do not specify the range on the profile, the user does so during the revaluation process.
    Note: To include items in the revaluation, ensure the Exclude from Inventory Revaluation check box on the Item Master record is not checked.
    Revaluation Pstg Perd Option

    You must specify a revaluation period which is used for posting the revaluation transactions. This includes all accounting periods up to and including this revaluation period, and all accounting periods after the revaluation period are considered as current period.

    Options are:

    • Same as Original Transaction
    • Relative to Current Ledger Period - see the Current Prd Pstg Relative Prd field below
    • Relative to Revaluation Period - see the Revaluation Pstg Relative Period field below
    Revaluation Pstg Relative Period
    If you have set the Revaluation Pstg Period Option to Relative to Revaluation Period, you must enter a value in this field. This value is used to calculate the revaluation period. For example, if you enter + 3 in this field, the revaluation posting period is calculated as three periods after the period in which the revaluation takes place.
    Location Selection Option

    You can define which locations are to be included in the revaluation profile using this field.

    Options are:

    • All Locations - includes all locations in the revaluation.
    • Select by Ranges of Locations - enables you to define ranges of locations to be included in the revaluation. If you select this option, you can then specify the range on the profile using the Location Selection action. The user can override this selection during the revaluation process. If you do not specify the range on the profile, the user does so during the revaluation process.
    Warehouse Selection Option

    You can define which warehouses are to be included in the revaluation profile using this field.

    Options are:

    • All Warehouses - includes all warehouses in the revaluation.
    • Select by Ranges of Warehouses - enables you to define ranges of warehouses to be included in the revaluation. If you select this option, you can then specify the range on the profile using the Warehouse Selection action. The user can override this selection during the revaluation process. If you do not specify the range on the profile, the user does so during the revaluation process.
    Revaluation Period Proc Option

    During revaluation, ledger transaction lines can be created to represent the revaluation values for all selected receipts and issues for the revaluation period ready for import to the Financials ledger. To set this, select the Include option. You must also check the Post to Ledger Option check box.

    Options are:

    • Include Revaluation Period Processing
    • Exclude processing
    Include Locked Locations
    Check this check box to include all locked locations in the revaluation.
    Include Quarantined Locations
    Check this check box to include all quarantined locations in the revaluation.
    Revaltn Prd Rcpt Ldg Iface Dfn
    The Ledger Interface Definition to be used for processing receipt transactions in the revaluation period.
    Revaltn Prd Iss Ldg Iface Dfn
    The Ledger Interface Definition to be used for processing issue transactions in the revaluation period. This is optional and defaults to the Revaltn Prd Rcpt Ldg Iface Dfn.
    Update Transaction Costs
    Check this check box to update the transaction costs as part of the revaluation process.
    Force Profile Selectn on Final
    If you check this check box, any subsequent changes made to selection criteria for an associated revaluation are ignored and the selection criteria set up in the profile are used.
    Current Posting Period Option

    Select which period is to be used for the current period.

    Options are:

    • Same as Original Transaction
    • Relative to Current Ledger Period - see the Current Prd Pstg Relative Prd field below.
    • Relative to Revaluation Period - see the Revaluation Pstg Relative Period field above.
    Current Prd Pstg Relative Prd
    If you have set the Current Posting Period Option to Relative to Current Ledger Period, you must enter a value in this field. This value is used to calculate the current posting period. For example, if you enter -3 in this field, the posting period is calculated as three periods before the period in which the revaluation takes place; if you enter +3 in this field, the posting period is calculated as three periods after the period in which the revaluation takes place.
    Post to Ledger Option
    During revaluation, ledger transaction lines can be created to represent the revaluation values for all selected receipts and issues for the current and revaluation periods ready for import to the Financials ledger. See the Revaluation Period Proc Option and Current Period Proc Option fields in this topic. If you have set one or both of these options to Include, you must also check the Post to Ledger Option check box. If this box is not checked, the revaluation process stops at the point when the receipts and issues have been updated, without proceeding to the creation of a journal. That is, it posts to the inventory only without posting to the ledger.
    Update Standard Costs
    Check this check box to update the standard costs on the items as part of the revaluation process.
    Current Period Proc Option

    During revaluation, ledger transaction lines can be created to represent the revaluation values for all selected receipts and issues for the current period ready for import to the Financials ledger. To set this, select the Include option. You must also check the Post to Ledger Option check box.

    Options are:

    • Include Current Period Processing
    • Exclude Current Period Processing
    Revaluation Currency Type

    This field is used if multicurrency functionality is in place for your system.

    Options are Base or Reporting.

    If you use both base and reporting currencies in your system, the difference for the currency against which you revalue holds both the cost and any foreign exchange adjustment combined. In the ledger the difference is separated into the cost adjustment and the foreign exchange adjustment.

    Current Perd Ldgr Iface Option

    The Ledger Interface Definition to be used for processing transactions in the current period.

    Options are:

    • Use Ledger Interface Definitions from Original Posting.
    • Use Specified Ledger Interface Definitions. See Current Prd Rcpt/Iss Ldg Iface Dfn fields.
  3. Save your changes.