Sage 300

Recently my workstation was upgraded from Windows 10 to Windows 11, shortly thereafter I started experiencing issues importing excel files into Ship Orders (Tairox). Whenever I try to import an excel file into ship orders I get the error "Microsoft Excel…

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…

Our regular import of a payroll GL JE has failed with the error message: Description: External table is not in the expected format Source: 12:20:40 - 1071.80004005.503.914 The only identifiable change is upgrading from old Excel (version unknown…

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…

Hi - We just updated to Sage 300 2020 from 2014 and use CSV files for exporting and importing sales orders between Sage and our warehouse Access db. For some reason, some of the shipped quantities brought back into Sage come in with quantities in reverse…

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…

Hi all, Have a customer that imports new vendors monthly with a Single CSV file created from another system. When I try to import after upgrading there is a new table for Vendor_Contact_Selection because multiple contacts have been activated. The Status…

Hello, Is there a way to record individual credit card expense transactions and be able to reconcile the monthly credit card statements like a bank account? Or import the invoice #s for reconciliation? We have hundreds of credit card transactions…

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 there, I am just new to Sage 300 and planning to use it in our next project. IF there is a WordPress website which exports it's data in JSON format, is there a provision available in Sage 300 to import that data?

We are on Sage 300 and would like to start importing new items. We are successful on all but the I/C Reorder Quantities. I exported data from the I/C Reorder screen, created a template and attempted an upload for a new title. We receive the successful…

We have many employees with pre-tax 3rd-party short-term disability deductions. When those employees receive payments for short-term disability, some employer-related taxes must be calculated. I have a custom Excel workbook to carry out these calculations…

I am working on an AR Import for Sage 300 in the actual Accounts Receivable Module; I am having trouble with the taxes calculating properly. If I manually enter the invoice I put the total in the top line and the subtotal below as taxable to the right…

Hi Sage Support, Unable to post a IC Receipt as IC Receipt RETURN using a Macro . Executed the Macro using Run Command ( F5 ) , I am getting below Error : Method 'Update' of object 'IAccpacView' failed Execute the Macro using Step by Step command…

I have imported items and quantities into a Transfer from an excel spreadsheet. The Transfer then SAVES correctly within SAGE300 however, it errors out at the end of the posting process. Error reads "Transit Transfer/Receipt Detail record already exists…

I imported thousands of customers in Sage 300. How can I delete a range of customers in the system? I called Sage Support and they said you need to delete one at a time. Is this true? I have to click delete 10000+ times. Isn't there a utility to do…

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…

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…

Please Help! Since I upgraded from 6.0 to 6.2 2014 PU3, when I import file on AR customers I have this error message :'File customer does not exist. Please specify an existing file' Any clue?

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…

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…