Over 25 Years of making Sage 50 Accounts do what others can't
Another new feature, this time in our Sales Order CSV Tool. The STATUS column can be used to instruct the importer to allocate available stock to the new Sales Order. Check out our Adept Blog for more info.
More great new features in our POP Header CSV Tool which allow you to change the STATUS and update Stock Records inc the GRN. Check out our Adept Blog for more info.
Need to re-install your Adept Add-On Tool? Select “Download Again” from our Support Menu.
Adept Sage 50 Purchase Order CSV
Adept Sage 50 Purchase Order CSVDaniel Hampton2021-01-26T15:11:29+00:00
Do you need to Import Purchase Orders into Sage 50? This program will import Purchase Orders into the Sage 50 Purchase Order Module from a CSV file. It can also set the status of the Purchase Orders to update stock levels and create goods delivery notes (GDN) if required.
Core Features of Adept Sage 50 Purchase Order CSV Add-On
Can be used to import data into any field in the Sage 50 Purchase Order file that is exposed by the Sage SDO.
The column headings in the first line of the CSV file are used to define the fields that the data should be imported into.
Will import Excel style multi line data into the Service Text field.
The CSV file contents are displayed, along with any error messages, before the import takes place.
Setting the Status of an order to ON-ORDER will update the product on order counts.
Optionally set the purchase order STATUS to be ON_ORDER by default during import.
Setting the Status of an order to COMPLETED can optionally update the product stock levels and create a GDN.
Create new template CSV files by selecting fields from a list of available field names.
Optionally move the CSV file to an Archive folder after it has been successfully imported.
Optionally monitor a specified folder for new CSV files and import them automatically.
Option to be run from the command line with -F
Optionally create new Supplier or Product records if they don’t exist.
This Add-On creates new Purchase Orders, it cannot add item lines to existing ones.
Export option will load your CSV template with data from your current purchase order file.
In a multi company Sage environment the company that each purchase order should be loaded into can be specified in the CSV file.
You do not have to log other users out of Sage while using this Add-On Tool.
The program can be run from an icon in the Sage Purchase Order module tool bar (dependant on Sage version).
Only Compatible with Sage 50 Pro and Financial Controller, see below for version compatibility.