mO SharemO Share

Adding Price Control at HO

Retail is an extremely dynamic area where prices of items can change based on various criteria, especially date wise. So that HO needs to manage the price change of items. This article describes how to manage Price Control at HO.


 Add Price Control

Pre-requisites

  1. The users' role must have access to the Price Control feature by enabling Add app operation for the feature in Admin - Security - Role.

  2. The items must present at HO.

  3. Site must be created.

Step-by-step guide

The steps are as follows:

  1. Go to Web > POS Manager > Setup > Price Control.

  2. Click on Add button. 

  3. Add Price Control window will open.


  4. You will get three sections - Item Information, Site Information, Price Information. 

  5. Item Information:
    1. In this section you can select items in any of the three ways - Select Item, Scan Item, Import Barcode.
    2. The searched items will be populated in the Item Information section.

      Item Information


      • Four New Columns have been added in the grid 

        • Price Management- Values are displayed as per respective item master and by default the column is hidden.

        • Batch/Serial No.- Batch/Serial No. can be displayed but it is hidden by default.

        • Mfg. Date - It can be displayed but it is hidden by default. It's a non-editable field. Its values are populated from respective batch.

        • Valid Up To - It can be displayed but it is hidden by default. It's a non-editable field. Its values are populated from respective batch.

      • Behaviour of item population mode:


        1. Function Name

          Explanation
          Scan Item

          It allows the assortment creation by scanning items

          Batch/Serial impact in Scan Item

          Behaviour of this section would be similar to Scan item → Automatic mode with the following exceptions -

            • Manual mode has been disabled.

            • No checking of negative stock.

            • No validation of Expiry Date.

            • Set Scanning is not allowed.

          • Behaviour based on options selected

            • If item barcode is scanned:

              • Two new windows (Batch selection window & Serial selection window) will open for batch or serial applicable items respectively with following exceptions to current workflow -

          1. Always a blank pop up window will open.
          2. Window will not have qty column because qty is irrelevant in this master form.
          3. Batch/Serial selection is not mandatory, if user clicks on Accept in such case only "icode" will get populated in the main grid.
          • If Icode/OEM barcode + batch/serial information is scanned, and if invalid combination is scanned, the following error message will be shown, after clicking on OK button -  “Item-Batch/Serial combination does not exist”.

          • If batch/serial is scanned, and if batch/serial is scanned and only single product is available in it for delivery then populate the same and keep cursor on the last position.

          • Otherwise if multiple products are available a new Item selection window will open.

            • However following the exceptions apply:

          1. Always a blank pop up window will open.
          2. Window will not have quantity column because quantity is irrelevant in this master form.
          3. Batch/Serial selection is not mandatory, if user clicks on Accept in such case only "icode" will get populated in the main grid.
          4. Item selection is mandatory in this window.


          Select Item

          User can populate items from all pending orders by clicking on Select Items.

          Batch/Serial impact in Select Item

          • After introduction of batch/serial functionality, a new window (Batch & Serial Selection window) will open for selection of batch/serial with items.

            Following exceptions are applicable

              1. Always a blank pop up window will open.
              2. Window will not have quantity column because quantity is irrelevant in this master form.
              3. Batch/serial information grid will always remain blank. Adhoc batch/serial input is required.
              4. Batch/Serial selection is not mandatory, if user clicks on Accept in such case only icode will get populated in the main grid.
              5. No validation of Expiry Date.
          Import Barcode

          It allows the assortment creation by importing barcodes from text files or comma separated values (csv) files.

          • For batch/serial enabled items having price management at item level, “Batch/Serial” field to be NULL/Blank.
            Msg: “Price is managed at item level, remove batch/serial information and try again.” 

  6. Site Details: 
    1. Select one item for which you want to select site.
    2. Click on Add Row button in the Site Information section to add a new blank row.
    3. Select a site from the drop down list of the Site Name column.

    4. Active Price Count and Total Price Count will be populated automatically.

      • Only sites belonging to type ('Managed Site-Organized Owned-Consignment Mode', 'Managed Site-Customer Owned-Consignment Mode', 'Managed Site-Customer Owned-Outright Mode-Track Secondary') are allowed.
      • Only Non Extinct sites are allowed.

      Site Information

      Site Information Grid

      • Multi Site - pricing

        • If batch/serial is selected in the item grid then, RSP and MRP will be populated from Batch/Serial

        • Else from item master

      • Multi Site - Extinct- No dependence on batch/serial functionality.

  7. Price Information:
    1. Select one item for which you want to select site. 
    2. Select the Effective Date (Mandatory) from which the price of the item will be effective.

      Note: Effective Date cannot be Past Date.

    3. Put in the RSP and MRP (both are mandatory) of the item. 

      Conditions for MRP and RSP:

      • Zero Allowed
      • Cannot be negative or blank
      • RSP cannot be greater than MRP.
      • Modification of MRP & RSP is not allowed if effective date is less than the system date.
      • Markup - In Markup the profit is calculated by adding a percentage of the cost to the cost itself, to get the Selling Price. negotiate SP
        For example, if the cost of an item is ₹ 100 and there is a 5% margin on markup basis for the item; then the selling price of the item would be ₹(100 + 5% of 100) = ₹ (100 + 5) = ₹105 
      • Markdown - In case of Markdown the cost is derived by back calculating and deducting from the selling price, to get the Purchase Pricenegotiate CP 
        For example, if the selling price of an item is ₹100 and there is a 5% margin on markdown basis for the item; then the cost price of the item would be ₹(100 - 5% of 100) = ₹ (100 - 5) = ₹95.
  8. Click on Populate to save the record.

  9. Click on Extinct.

  10. Select a site.

  11. Select Yes or No.

  12. If you click on yes, all the items under the selected site will extinct. 

    Note: If you Extinct any site, the listed items under that particular site will Extinct (Deactivate). In future user will unable to get those items from that particular site.


To go back to the main page click on the link: How To: Manage Setup in Ginesys Retail