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 Creating a Budget in General Ledger a useful tool or is it better to create the budgets in Excel and export the data from GL?

Hello SageCity, I am struggling to get to the bottom of a strange issue. It happens in SAGE 300 version 2019 when printing reports. The details are: 1) A user starts a report from SAGE, 2) The report program prompts for parameters, 3) User fills…

I want to import items into an O/E quotation. I have attempted to export an existing "QTxxxxx" to use as a template, but I get an error message "Can't Append Table. Error: Too many fields defined." even when I limit the requested fields to those in…

We are working with a company using Sage 300 on a Pervasive SQL database. They are interested in exporting data such as GL, AR, and AP transactions and other table information, such as accounts, customers, and vendors. I'd like to know if there are…

Why I export and import batch payment batch list as payment amount from older batch payment amount is double payment amount but in detail is not double double all entries in misc.payment. I inqured excel template is the same as old template. or…

Hello, I am trying to export the 2016/2017/2018 year end income statement accounts and amounts to excel. I cannot find which column definition displays this information. Every column definition I have tried does not tie out with the actual income statement…

I am looking for a formula (in Report Designer) to pull out the first name & another to pull out the middle initial. I know it's fairly easy to do in Crystal. However, I'm trying to avoid completely re-writing this report. Any & all help is greatly…

Custom report developed for AR invoices . User enters parameters and executes reports and all the data comes on print preview , approx 15 pages . As soon they click on export button the following error is received. generally user tends to run the…

I do the work for two separate customers (slightly different ownership). One company -- Company A -- frequently invoices the second company for various items -- and the A/R invoices have many, many lines. The second company -- Company B -- wishes to post…

Customer has a new Win7 laptop and their IT folks installed the Sage 300 client 'as usual'. Users normally preview reports then prints or sends to PDF if a copy is needed. When they choose 'export' option from the preview, instead of getting the window…

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…

Hello, I need to know the values I should use for "CATEGORY" in time card import sheets,,,,can someone help pleeeease? BR

I know how to import into AR Receipts in Sage 300. Is there a way where Sage 300 can read single line items per transaction. For example, on the import file, I just want a single line item on the CSV for every cash receipt. Right now, Sage 300 requires…

We are from Australia. We have set up two tax classes on supplier. When we made a purchase: 1) Within Australia, GST Purchase 2) Outside of Australia, GST Free Purchase (as the GST will be dealt with the freight company who deliver the goods to…

Hi, I am having a hard time importing transaction on AR module, this notif. keeps on prompting while i keep on trying. I have searched some trouble shoot for this but still I can't proceed to what I am doing. Any help? Please! Thanks, B…

Hi I'm importing shipments and the status is "Shipments: 0 updated, 0 inserted, 1 processed". The shipment is not imported I can't find it anywhere. I tested the whole process on a test company and there it imports perfectly. I don't understand why…

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…

We use Sage 5.6A 500 ERP at our offices. Whenever I run a custom report (to generate sales numbers), 50% of the time the program will crash when I try to export it into an excel data file. The report runs FINE, we can see the information in the report…

When attempting to import inventory records we get an error "Category Cannot Be Blank" We have an entry in the category field. We even updated the inventory record with the value manually and then again attempted to import and we still get the error.…

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.…