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

Import/ Export

Showing 83

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

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

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

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

Headers on CSV

Export headers on CSV files
Guest over 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

Multiple Budgets per Financial Year

eg To able to haveseparate valuesBudget, Forecast and Re-Forecast for the year. Many customers operate in this way Using Multiple Year Budgets for this is not the best way as you then cannot set Next Years Budget if you are using this for a Forecast
Saeed Malik over 9 years ago in Budgets 0 Idea Accepted - Gauging Support

Budget Imports need to overwrite everything

When you import a budget using the import template, at the moment it will overwrite only values of 0.01p or over. If you leave a value blank or a zero it will leave the previous allocation as it is. The ramification of this is that the whole Nomin...
Guest over 6 years ago in Budgets 1 Already Exists