Supplier Global Pricing

Supplier Global Pricing


There are two different ways to change prices in Agility Pro on mass:

1 - Supplier Global Pricing - By Percentage
Allows you to increase or decrease the price by a percentage for all stock assigned to a supplier.
The update can do buy and sale price, but not both at the same time.
This can be filtered by category, group and type which means only the codes in the specific groupings will be updated.

Go to Stock>Ledger Maintenance>Supplier Global Pricing, the below screen will open:


This updates the prices on a percentage basis.
Enter the supplier account number and click the spyglass to search:


Select the supplier by Clicking Select:


If required, select Category, Product Group and Product Type

With the Buy Price radio button selected:


Select the percentage you wish to chnage the price by from the dropdown box:


Select either Increment or Decrement radio button:


Now click the recalculate button:


The updated price will show in the Net column:


If you are happy with the price change, click SAVE
The below message will appear, answer Yes or No, depending on your choice here:


If derived pricing has been enabled, but not setup for this supplier, you may get the below:


Click OK, and then Yes. The form will not clear, but the Buy Prices will have been updated.

To update the Sale Prices:
Select the Sale Price radio button selected:


And then click Recalculate:


Select the percentage you wish to change the price by from the dropdown box:


Select either Increment or Decrement radio button:


Select Net or Gross, depending on which you want to update by:


Now click the recalculate button:

If you are happy with the price change, click SAVE
The below message will appear, answer Yes or No, depending on your choice here:



2 - An import update of stock prices
There is also the ability to EXPORT and IMPORT the information in the grid.
Exporting the data will allow the prices to edited by a value rather than a percentage and then can be imported.
This allows you to update the price to a specific value, instead of by a percentage.




In order to get the information out of Agility Pro, Supplier Global Pricing can be used to do this.

Go to Stock - Ledger Maintenance - Supplier Global Pricing, and then search for the supplier and select Buy price radio button:

Then click Export, clicking Yes to all of the prompts. Microsoft Excel will open with the exported Buy Price file.

Now select the Sale Price radio button:


And then click the recalculate button:


This refreshes the information and returns the Sale Prices to the grid, now click Export again, clicking Yes to all of the prompts. Microsoft Excel will open with the exported Sale Price file.

Using these exported Excel files, for the buy price edit the New Price column, and in the sale price the Gross or Net can be changed.
After changing the prices, save the file as a CSV (Comma Delimited) (*csv) file:


Then go back to Agility Pro and click the Import button in the Supplier Global Pricing screen, and click Yes to the below:


The click Yes to the below (unless you have removed the column headers from the Excel file):


You can untick any of the rows you do not want to updated:

By default they are all ticked.

If you are happy with the price change, click SAVE
The below message will appear, answer Yes or No, depending on your choice here:


For the Buy Prices, if derived pricing has been enabled, but not setup for this supplier, you may get the below:


Click OK, and then Yes. The form will not clear, but the Buy Prices will have been updated.
The same process applied for Sale Prices.


Although editing directly on the grid is possible, it is not advised, as it does not consistently update prices through Agility Pro

    • Related Articles

    • Changing Prices in Agility

      INTRODUCTION There are two different ways to change prices in Agility Pro on mass: Supplier Global Pricing or Import Stock Prices Supplier Global Pricing Select link to see instructions Supplier Global Pricing Import/Update Stock Prices Select link ...

    • Derived Sale Price

      INTRODUCTION This feature automatically creates a new sale price based upon a change on the buy price, pending on set up. You can discount or increment or decide how much margin you would like to make each stock code. REATING A DERIVED PRICE Go to ...

    • UPDATE Stock Prices

      UPDATE STOCK PRICES This allows you to update the price to a specific value The update can do both buy and sale prices SQL QUERY This can be used to extract data based on Category SELECT --The BuyPrice will need to be multiplied by the quantity of ...

    • Purchases - Supplier Details

      INTRODUCTION Agility Professional includes a purchase ledger enabling the company to set up their suppliers. These suppliers can be linked to buying groups and if BACS/SEPA is required these details can also be recorded SECURITY There is various ...

    • Stock - Stock Item Maintenance - Buy Price Tab

      INTRODUCTION Once a stock code has been created this can then be maintained by going to Stock\Ledger Maintenance\Stock Item Maintenance\Stock Items or by selecting the shortcut on the menu. From this screen a codes can also be created and there are ...