Sage 300

Hi all. I create my own excel file with the same sheet name, column name as exported one. however, it failed to import with the error below. However, copy pasting the content to an exported excel file seems to works fine. The issue is: I am going…

Is it possible to import updated unit price in order details using excel file, I import data using excel but unit price can't be updated , it automatically pick the price from the finder.

Hello! So I've been able to successfully import orders via the import function. I'm wondering though, if I want to make changes to orders already in there, is it also possible via the import function? As of now it will give me an error saying the…

Is there any way to update my unit descriptions from an excel spreadsheet? I tried an import but apparently there is no insert/update for that import, just insert. Would a macro be the only way?

Getting an error 127 every time a client tries an item combine function. I believe the 127 indicates a duplicated field but I cannot find anything. RVSpy is giving no clues. Any ideas for where to look?

Hi Sage City, I work for a company that sells imagery to companies that print and frame, as such our inventory is huge, we have upwards of 50,000 different items. Customers will order upwards of 2000 at a time which means our sales team is forced to…

When trying to use an import file for IC Number change we get the following errors before it starts trying(and failing) to read the actual item numbers. We've used this functionality in the past with no problems. Even tried an old import file and still…

Is there a way to import an OE credit note without specifying the CRDNUMBER? I'd like the system to assign the next available number so I'm not duplicating and causing an issue with a manually entered one. When trying to import I'm getting an error: …

Merry Christmas Everybody, Before I left my office for Christmas Eve Thursday night, I was struggling with the very clumsy and unwieldy asset acquisition data entry process of the norming asset management module of our Sage 300 system. I had noticed…

Has anyone managed to make this work? I created an import template for a PO receipt, based on an exported record from Sage 300. The "MULTIPOR" field was set to True, however that box wasn't checked after import and the receipt wasn't logged against the…

Hello, As per subject, it pop-up error message and i have to manually delete off from my excel and continue import. I have 130k of new items and i do not wish to do the deletion part. Please help. Sage 300 2016 Advance PU 5.

I have searched the help in my Sage 300 and in this forum and cannot find instructions on how to import a batch of sales orders. Can anyone point me in the right direction please?

Hi, I asked this question 2 years ago but am asking again in hopes there is now a solution or third party vendor that has created a solution. I am trying to extract prices from Inventory Control for a client to import into another software package so…

Hi, May I know what is the maximum number of lines can be entered in O/E Shipment Entry? One of our client requested to do import into O/E Shipment Entry with big volume of data. Is it possible to import 20,000 lines of data into O/E Shipment Entry…

A customer reports that he gets problems importing "large" CSV files to the GL. In his case, "large" is around 150 rows. Is there a theoretical (or practical) limit to the number of rows? Breaking the entry into smaller number of rows probably not practical…

Hi guys, I'm experincing the below error when importing the inventory balance. Description: System error. Write down the message, error and source codes. Exit Sage ERP Accpac and Windows. Restart and retry the operation. For more information, see Appendix…

Hi, I am trying to extract prices from Inventory Control for a client to import into another software package so I would like to know the following please: The best way to extract item pricing information out of Sage 300 V2014 for a customer when…

Hi All, I have performed an OE import successfully in most of the cases. However, I have encountered the captioned error for some items at zero stock level at the moment which could be imported as OE successfully for one OE, but not the others at different…

Dear Forums, I have tried to export order entry to excel both 2007 or 2000, however, the table Orders could not be exported. Do you know the reason? Thanks a lot.

I am struggling with importing the preferred vendor field in IC Vendor Details, even when I export and force the field to Yes (Check box) on re-import it still does not update the required field. When I check the ICITMV table that field does not even…

I want to update the average cost field on the location table, using an import. I can get other fields to update successfully, just not the average cost. This is for a data migration, so we're not in production as yet. The items in question do use…

Hi All, Has anyone got a working import excel template for PJC Contracts? (FYI: I'm working in Sage 300 2012.) I've asked Sage but they have gone all quiet. I've tried the "export and build a template yourself route" but before I bash away more…

I'm wanting to add about 600 items to an already existing list of products in our datasbase. So, I exported 3 lists: I opened I/C “Items”. I created a script that would contain all the columns we use in that first tab (of the Items Module), and the…

Version 6.2 PU1 Sage 300 ERP SQL 2012 I exported an I/C receipt, copy data to it from another spreadsheet and tried to import it back in as a new receipt (i.e. changed the sequence #) and am getting the following error: Description: System error.…

Hello, My company just start to use Sage 300. One question we meet is AP can retrieve or apply invoice with receipt exceeds PO and receipt value and quantity w/o warning and can go ahead. I think that should be security problem, anybody can give me a…