Update Stock Records

Update Stock Records

In Agility pro there is an option to import an update file to update existing stock records with new information, such as barcodes, case types, etc.

Go to Tools-Tools Menu-Import-Stock Records

When prompted Are you continuing with import from previous data load, click No

            
Then when asked Is this an Update File? click Yes:


Then select the Import .cv file you are intending to use:


For this example, we are updating the stockcode, sale casetype and barcode. So we select those from the lefthand side. The .csv file must be formatted in the same order:
Stockcode | Sale Casetype | Barcode

      

      Click on Load - this loads the correct file for Update:

            
   
Select Yes - this will load update file onto Grid

      

 Click on Update and this will update the File to Agility Pro:
     y


    • Related Articles

    • Stock - Stock Import

      Stock Import Introduction In Agility there are features that enable the importing of new stock codes, updating current stock codes and changing prices. Here is a list of ALL items which can be imported but not ALL are required. Items highlighted are ...
    • Update Stock Records - Supplier

      Change a supplier from one currency to another and transfer stock Create a new supplier account with the currency recording what the new account is To update the stock records with the new supplier code follow the instructions: Go to ...
    • Update Stock Records - Suspend or Close

      INTRODUCTION In all businesses the stock file increases with stock that is no longer purchased or sold. Within Agility the function to update stock records can do this. Identify the codes that need to be suspended or closed. NOTE: Suspend basically ...
    • Stock - Browse Stock

      INTRODUCTION In Agility browse stock gives the user the ability to search for stock in many different ways: Stock Code, Description, Preferred supplier and preferred supplier code, barcode, Department, Category, Group, Type, Job/Project and Analysis ...
    • 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 ...