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

Import/ Export

Showing 81

Sage200 - Stock Record with Supplier Cost and Selling Prices Import

We would be looking to use the Stock Item Import feature currently in Sage to bulk import new products we want to set up. What we would like to be able to do however is import new stock records along with a Supplier Cost Price and Selling Prices a...
Guest about 1 year ago in Stock 0 Idea Accepted - Gauging Support

Validate transaction import for nominal codes that do not exist in sage

currently when you import customer/supplier transactions and it contains a nominal code that does not exist in sage, it allows the import to go ahead with no warnings and posts it to suspense. I think it should allow more strict validation and rej...
Guest over 8 years ago in Nominal 0 Idea Accepted - Gauging Support

ODBC Connectivity

It would be a good idea to add ODBC connectivity so that the underlying SQL database can be directly queried from Excel
Guest over 8 years ago in ODBC 0 Idea Accepted - Gauging Support

Import Analysis Codes

With the recent additions of being able to import nominal ledger cost centres and departments would it be possible for Analysis CodeValues to be imported into Sage 200? During a large 50 to 200 migration the client had 50 odd analysis code values ...
Guest over 8 years ago in Analysis Codes 0 Idea Accepted - Gauging Support

Ability to import Monthly Budgets against projects

This was previously logged as a Wish. Need to have the ability to import Monthly Budgets against projects. At present they have to be entered manually.
Guest over 6 years ago in Project Accounting 0 Idea Accepted - Gauging Support

File Import Routine Changes - posting date

this should default to the date of the import rather than being a column on the import file
Simon Tomkins over 1 year ago in Import/ Export 0 Idea Accepted - Gauging Support

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

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

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