Updating Cost, Sell Prices & Main Supplier

Updating Cost, Sell Prices & Main Supplier

Price Change Maintenance 

Both Cost & Sell prices are amended using Price Change Maintenance. This can be found in within "Pricing > Price Change Maintenance".



You will be presented with the following search options:


The "Branch" dropdown menu can be used to specifically change prices for certain branches, leave this on "All" for changes to be applied to all branches. 

Use the "Date Effective Default" field to set an effective date for the price changes to go live, this can either be the present day or a day in the future.

You can then search for the item you are going to amend, the search can be completed using the SID, Description or Barcode.



Cost Price Amendment

The cost price of an item can be amended within the "Cost Price" tab:


You will be presented with a table containing lines for each supplier, the current cost & margin for the item.

To make an amendment, enter a new cost value within the "Cost" column and select "Apply Changes". The screen will then refresh and update the margin accordingly. 



Sell Price Amendment

Sell Prices can be amended within the "Sell Price" tab:


You will be presented with a table of historic changes which shows the pricing history of the item as well as the date of the amendment and the user who made the change. 

To enter a new selling price, enter a value within the "New Selling Price" field and set an effective date.

The RRP field will determine if a "SALE" tag is given to the item online to show a discount to the customer: 


You also have the option to amend the VAT code associated with the item, this can be changed using the "VAT Code" drop down and will show the VAT codes set up within "File Maintenance > VAT File Maintenance".

The "Discountable" tick box can be used if you wish to include the item on other promotions. 



Individual Stock Amendment: 


This tab allows you to change the cost & sell values for individual stock codes within a SID. This would allow you to have different cost & sell values for each size of a product:


You can use the drop down menu within the table to change the type of value you wish to amend: 





Amend Supplier against a Product:



A new Supplier can be added to a product. 

You can add this using the Price Change Maintenance program under Pricing.  Please ensure you have permissions for this program. If you cannot see the option to create new Supplier then permissions needs to be updated first. 




Here, you can select 'Create New Supplier', in the bottom right, This will take you to the following screen, where you can fill out the supplier details:


Once you have created the new supplier, tick the box to make them the preferred supplier:






User Permissions

If you are unable to make any changes within Price Change Maintenance, you may be missing the correct permissions. The following permissions can be found within "File Maintenance > Employee" for each user. 


FAQ

Q: If I amend the cost price for an item will it retrospectively update reports? 


A: No, the cost will only show on new stock movements. Retrospective cost changes must be completed with a GRN Amendment.

    • Related Articles

    • Bulk Price Changes

      First go to the Pricing tab from the main menu and select Bulk Price Changes. You can change the price against a specific branch or choose all branches. Select a date when the changes will become effective. Choose today’s date to do it immediately. ...

    • Returning Faulty Items To A Supplier?

      From the Main Menu go to the stock menu and then find Returns to Suppliers. Select a Branch where the stock will come from, the posting date, a supplier code and the reason for the return from the drop down. Press Next >> to continue. Start searching ...

    • How Do I Manage Suppliers?

      From the Main Menu go to File Maintenance and then Supplier Maintenance. You can edit an existing supplier by clicking Change. You can delete a supplier by ticking the box in the right most column next to the name and then press Apply Delete at the ...

    • Changing Cost Price/Sell Price & VAT For Individual Sizes

      The system will allow you you change the cost price, sale price and VAT against each individual product size. This can be updated in Pricing - Price Change Maintenance Add in the SID or description and a date the change to be affective from. The ...

    • GRN Amendment / Update Cost Price / Remove the GRN

      The GRN Amendment program is a specialised module designed to manage and amend Goods Received Notice(GRNs) after initial posting. In order to use the program you must have access to it within Purchase Orders > GRN Amendment, and also have level 3 or ...