Skip to Main Content
Sage 200 UKI Ideas Portal
ADD A NEW IDEA

Import/ Export

Showing 70

File Import Routine Changes - user name

it would be better if this defaulted to the user doing the import
Simon Tomkins over 1 year ago in Import/ Export 0 Idea Accepted - Gauging Support

Single URN for Nominal Ledger Transaction Import

When a nominal ledger journal is imported using the standard Sage 200 nominal ledger import routine, could the system use a single URN for the entire import rather that giving each individual line it&s own URN?
Guest over 8 years ago in Nominal 0 Idea Accepted - Gauging Support

Allow import of previous year journals

Client has a 150 line prior year journal to post but the import nominal transaction only allows the current year. Would like a prior year import equivalent
Guest over 8 years ago in Nominal 0 Idea Accepted - Gauging Support

Data exports to go to the default Spreadsheet application

Sage appears to look for the excel executable to create data exports, rather than generating the data and allowing the OS to direct the file according to the users spreadsheet default. Version 12.00.0035
Chris Jones over 1 year ago in Excel 0 Idea Accepted - Gauging Support

add supplier transaction nominal validation

currently sage will import with no warnings if the nominal account doesn't exist, this has resulted in journal corrections being required
joanne scott about 6 years ago in Customer/Supplier Transactions 0 Idea Accepted - Gauging Support

Import Sales Transactions - Transaction Date Validation rules to be followed

The system lets transaction dates through with any dates, it does not look at the transaction date validation rules in ASM
Saeed Malik about 9 years ago in Customer/Supplier Transactions 0 Idea Accepted - Gauging Support

Headers on CSV

Export headers on CSV files
Guest about 9 years ago in CSV 0 Idea Accepted - Gauging Support

Functionality to add a Name (Description) and a Short Name to non-standard Sage 200 Modules/Sources

When importing Sage 200 Customer or Supplier transactions, it is possible to specify a Source (Module) number in the 16-90 range to the Excel import file. At present, when the transactions have been imported, the description of Sources 16-90 will ...
Eric Belshaw about 5 years ago in Customer/Supplier Transactions 0 Idea Accepted - Gauging Support

Import Reporting Categories

When creating new company, program automatically creates reporting categories with codes 001 etc. Should be able to import reporting categories with overwrite existing option so users can use their own reporting category structure. Currently progr...
Guest over 5 years ago in Nominal 0 Idea Accepted - Gauging Support

Import journal transactions template usernumber field to be made mandatory:

When we use the import transactions functionality to upload a journal via the .csv template http://desktophelp.sage.co.uk/sage200/sage200standard/Content/CSV%20samples/NominalTransaction%20CSV.csv I have noticed that the UserNumber field is not ma...
Guest over 5 years ago in Nominal 0 Idea Accepted - Gauging Support