Sage 300

Hi all, I keep on encountering the error below while trying to do my database setup on Sage 7.0 Can anyone help with this please? Thank you.

Is there a way to bulk import items within Sage 300? We around 2000 items that we need to add. Typically we add items using the Items Wizard manually as we utilize quite a few Optional fields and use different pricing Item Pricings. I have tried to use…

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. There are two columns in table OEINVD, INVDISC and HDRDISC. The descriptions for these are "Invoice Discount Amount" and "Header Discount", respectively. What is the difference between them? Thanks in advance, Mike

We are adding a large number of new products to our Inventory Master list which requires new part numbers, adding each part to the Pricing list, entering the quantities for each part and its location. What is the most efficient method to add this information…

I have started to upload A/P Invoices using the Excel template provided with Sage 300. Whenever I upload a file, I get the error message "Vendor cannot be blank" despite the Vendor Number (IDVEND) being populated in the Excel file (in the "invoices…

Every year I have to change AR Customer default price list. We have 90K customers and import from excel takes more than 72 hours. Hardware is definitely not an issue since ship to locations are updated for less than 12 hours. Using minimum of data in…

Does someone have a template that I can use for importing invoices into SAGE 300 AP using Excel? I tried an export but the arrangement of the output doesn't make sense for a template. Also, I cannot locate the function to import. So I am not sure that…

We are using AccPacc to work with Sage 300. When we call View.Insert the error message appeared: ------------------------------------------------------------------------ Timecard Detail. Database error (operation=REV-POST, error=229) ------…

Good day, I am trying to export data from my local sql DB in sage. I am new to sage integration, so i have narrow knowledge on this subject matter. When i inserting InsertInvoiceDetailSoftCols() i get an exception "Error HRESULT E_FAIL has been…

This is the file I am using to Import bank statements to reconcile our postings on Sage. The entry does not reconcile, I have tried everything please help and let me know what I am missing on this Excel sheet to complete the reconcilition. This file…

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…

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…

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…

I will often do the importing of data for my clients. Is there a document that explains what the minimum field requirements are for an import? Is there some kind of logic that I could use to figure it out on my own?

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.

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…

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

Hello, We upgraded our office product from 32 to 64 bit. Office 2010. Now in Sage when we Import/Export in any module, the option for Excel 2007 disappeared. Only Excel 2000 is available. Any ideas? Do I need to uninstall-reinstall Sage? Sage…

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…

Hello All, My Financial Report that exported from system by using template include a lot of 0, the cells without any number. The template is wrote by myself. I was wondering if somebody can advise how to remove 0 and just show clean cell? I mean how…

Would like a conclusive answer if Accounts Receivable (A/R Transactions) allow for the use of Kit items with individual components. I know they are available in Order Entry Transactions. Thank you for any/all help!

I need to set up an import for timecards into Sage 300 payroll. I have gone through the process of manually entering a few timecards and then exporting to Excel. Now I need to figure our which fields really need to be populated by the import file that…

II need to import OE from an external application. Spent many hours trying to create a valid script without success. I am not using serialized or lotted items but the import function keeps looking for them even though System Information does not list…