Sage 300

Hi, I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error - Could…

Previously I could either insert or update records using that drop down option when importing records using dbase5. Now I have to use .csv to import, the Insert/Update option is there but you get an error “Record already Exists” when trying to update…

I have been using Sage 2017 for Payroll for some time and have used Dbase format to import/Export since days of Accpac Dos. Upgrading to 2020 SM finds that the option no longer exists. I am having issues exporting using CSV (Through Visual Foxpro) and…

hello, it is possible to enter 150-200 different item #’s into an excel spreadsheet and then import that to ACCPAC? instead of creating an item one by one in the inventory item? thanks eb

Good day All Windows 10, Sage 300 2019 23-Bit. I am trying to import or export, and then presented with the following error: Clicking on both yes and no does nothing. Kind regards Edwin

We are implementing Sage 300 ERP on premises. Due to current situation, implementation taking longer than planned. The simple question is, how can we migrate current FY data back to January from our legacy Peachtree Quantum system to sage 300? Comments…

The date fields in sage are coming into excel as text via my Intelligence report. I can reformat them in excel but would much prefer they come into my excel as dates. Is there a way to format the column in my Report so that it's already a date in my…

Hi, Any master or transaction data while exporting the set criteria is blank and unable to export. Server is working fine, we face this issue on workstation. Newly updated SAGE 300 2019 and premium. Attachment is enclosed. Any guidance to fix it…

Is there a listing of all the codes used in Sage 300? Trying to create a few spreadsheets using pivot tables and need a listing of all codes. Suggestions on where to find these?

I stopped the window update because of the “Unexpected error from external database ” Importing into Sage 300 and MISys at 2017 Oct . I have a question is that can i restart the window update now?

We have «Sage 300 ERP AccPac v2014». We export IBM Notes data in XML to TransAcc module. I must modify le doctype for actual data, they are considered as «Prepayment», and I must change doctype for «Receipt». Here the sample of data: [code]<?xml version…

The system indicates that "can't append table. System error. Too many fields defined" when exporting SO to Excel. How can I export the basic information without having to look field by field? Is there any workaround for this?

Good morning, I need to extract YTD balances based on an optional field linked to the account number. I can not find the tables that keep the optional field data as well as a file that keeps balances per account. Any suggestions? Thanks.

I was importing a price file that was over 65000 lines so I used the Excel 2007 function using an xlsx file. It got most of the way through then failed on me. So I altered the file thinking it was too large (now only 53000 items) and tried again. Now…

Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "DatabaseName" requested by the login. The login failed.

I need to know where I can get the names of the tables,their descriptions and how they relate. A database diagram would also be helpful

Hi, We are using Sage 2014 and We have the following error message when we load data ( error=856, native code=476485). any clues? thanks

I am having issues exporting database on the item module. It only exports half the database. Also I have to check all criteria to display anything for "optional fields"

I need to export the customer comments. I can choose the comments from the pull down menu when I export from Customers...but when it starts processing, it stops about a 1/8 of the way through my customers and gives me the above error message?? Also…

i have not seen this in years any problem with MDAC. when printing report to preview and then export no issue but trying to do any import/Export out of Sage say MDAC need to be installed and activated. Any idea where to start looking. Database MS…

Hello, We are moving to a new SQL server. Is there a way to bring over the users and their passwords from the old to the new server? I have done a dump and load of the system database, and everything comes across except the users. I also tried export…

I am using Sage 300 ERP 2014. I can see that Salesperson code is in ARCUS but I cannot find the name, which I need to be able to pull into a crystal report.