Update Stock Records - Supplier

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 Reporting>Interactive SQL Queries
Copy and paste into the screen that opens:

Select stkcode, Supp1
From stkhead
Where supp1 = 'Andy'

Replace Andy with the current supplier account number
When the data is returned Export to Excel
Update the supp1 code to the new supplier account code
Save as CSV - Comma Separated Value

Go to
Tools>Tools Menu>Import>Import Stock Records
Question: Are you continuing with import from a previous data load - NO
Question: Is this an update File - YES
Select the file from where you have saved it
Add the following fields by selecting them and pressing the single arrow to move to the right
Stkcode
Supplier
If there are column headers on the CSV file select Ignore Column Headers
Select OK
Select LOAD
Select Import

    • Related Articles

    • 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 ...

    • 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 ...

    • 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 - 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 ...

    • 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 ...