Purchases - Importing A Purchase Order

Purchases - Importing A Purchase Order

INTRODUCTION

Some suppliers may send a csv file so that the user can import a Purchase Order.
This has to be a new PO

EXPORT A PO

It is possible to import a purchase order from a csv file.
This process almost always follows the export of the PO first.
To that end the export process will be covered in this section at the same time.
You may wish to check with a supplier stock availability and pricing prior to raising a PO.
This button allows you to export a PO to email to a supplier for them to confirm these details.
Column Headers, Blank Row Stock code, Description, Case Type, Quantity and Cost there is a dummy field

On pressing the Export button the standard Microsoft File Control screen is displayed to determine where the file is to be saved.
The file is automatically named as POXXXX where XXXX is the purchase order number.
You can amend this if you want.

You will then be asked two questions
a.       Use Supplier Stock Codes: This will be more meaning ful to the supplier. It should only be used however if you are confident that you have all supplier codes in the system.
b.       Export Unit Cost: You may wish to click No to yes as you may be looking for the supplier to give you costs

CREATING A PO

Once the file has been returned open a new purchase order and enter the supplier code.
If you are importing a file previously exported, you must first open the file in Excel and DELETE the blank line between the column headers and the first line of the purchase header.
This line was inserted to make the file more readable for the supplier.
You can also delete the column headers if you want.

Open a PO and log in with the eposid of the user.
Select the supplier account
Now select the import button and navigate to the location of the file:


Select each field and press the single arrow to move over these have to be in the exact order as the file.
The format of your file needs to be StockCode, CaseType, Quantity, BuyPrice

When finished click OK. The system will validate that you have selected Stock Code, Quantity and Cost.
If you leave out Case Type you will be warned that the default case type will be used.

If there is a description then either delete this or add a DUMMYFIELD between stkckCode, DUMMYFIELD, CASETYPE, Quantity, BuyPrice
Remember to tick the box ignore column headers if you have some

NOTE: As this is a CSV file - Comma Separated Values this means that there can be NO , in the file.
Also, remember that if File is selected the format can be saved for importing the PO's in the future for this supplier.

The import process does not support volume or fashion stock codes and if any are found these will be skipped.
Any other errors on import will be highlighted after the import.
Examples of errors include
a.       Suspended or Closed stock items
b.       Invalid Case Types
c.       Invalid Quantities or Unit Cost i.e. negative or contain alpha characters

ERROR MESSAGES

When a file is imported it will be seen in the grid:


The file that is being imported has 17 rows yet only 10 are visible
The import process does not support volume or fashion stock codes and if any are found these will be skipped.
Any other errors on import will be highlighted after the import.
Examples of errors include
a.       Suspended or Closed stock items
b.       Invalid Case Types
c.       Invalid Quantities or Unit Cost i.e. negative or contain alpha characters

if there are issues then agility will show the following message box:


Select YES to view the issues


Scroll to the right to see the error messages here there are a fewe:
Invalid Case type
Invalid Stock Code
Buy Price lower.....
You have the option now by using the Apply Price Changes button to amend the system price if you so desire

If, the user does not want to use the PO select CLEAR button and say NO to saving a temporary copy.

NEW STOCK

New stock codes CANNOT be imported these must be added through the standard ways.




    • Related Articles

    • Purchases - Purchase Orders

      INTRODUCTION Agility Professional allows users to raise and edit Purchase Orders (PO’s)to suppliers. This is restricted to Purchase Orders raised through the main Purchase Order screen at Purchases/Orders/Purchase Orders. It is possible to raise a PO ...
    • Purchases - Editing a Purchase Order

      INTRODUCTION When creating a Purchase Order there are two options based on security: 1. Save as Draft or 2. Finalise the Purchase Order SAVE as DRAFT When saving a PO as draft this allows another user to finalise the PO this could be due to the ...
    • Purchases - Purchase Orders - Supplier List

      INTRODUCTION Agility Professional allows users to raise Purchase Orders through a supplier list. This is a list of all products for a specific supplier. SUPPLIER LIST An alternative to using the Add Item button from the main purchase order screen is ...
    • Purchases - Browse Orders

      INTRODUCTION After creating Purchase Orders the enquiry screen allows the user to browse these. From this screen it is possible to drill down more information and also according to user permissions to carry out certain actions. BROWSE ORDER The ...
    • Purchase Orders - Notes

      Agility Pro has the option to add notes to Purchase Orders. There are multiple types of notes that can be added to a Purchase Order. To add a note, when in the PO screen, click on the Notes button To add a note that will show on the PO, click in the ...