Sage 300

I am trying to import an A/P batch into Sage, I'm using the template downloaded from an already existing batch. The issue is when I select the file (Excel 200 format) and click OK an error window pops up with the G/L account cannot be blank message. …

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…

I have a test import file that works on version 2018, 2019, 2020 Sp1 but won't work with 2020Sp2. Has anyone tired importing a customer account change in V2020 with sp2 and been successful and if so what format did you use?

Hello, can someone point to me in which table we can get the shipping payment term for an order, such as "Prepaid". We looked at OEVIA table but don't find this information in there. Many thanks!

I have a client that is planning on changing banks. The problem is that they have over 1000 credit cards saved. They are using PAYA, but the problem is that in Sage 300 the credit card is associated with a bank. I have been told that when they change…

I have successfully imported transactions from several banks and credit cards. However, Capital One credit cards are giving me an error "Error End Document Tag" Which means there is some kind of problem with the xml file. Anybody run into this…

When i'm trying apply docs

I have several entries in several different batches that error out and make an error batch with the message Currency conversion failed. Source=CAD, Functional=, Rate date=0000-00-00, Rate operator=M, and Rate=1.000000 anyone seen this before …

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…

Currently running Sage 300 2019 and have noticed a number of errors during the data integrity check. Balance due $ is not equal to the sum of open documents for vendor. Restoration of data is not an option as the errors go a long ways back before my time…

our company have more than 40000 journal entry history data - how to import into Sage 300 2017 General Ledger ? I tried entering manual Journal and export in excel sheet then add 5 journals on headers and details , then import from excelsheet it's…

I am importing an excel template for invoices. An error message appeared 'Terms code 1 must be blank'. There was previously a '1' in this field and I deleted it and retried the import but the error message came up again. Can some help to resolve this…

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…

Hi, We are upgrading to Sage 300 2018 and need SQL Server Native Client 11.0 but not sure where I can found. Apparently one comes with SQL Server 2012 but not sure if thats OK no matter we have SQL Server 2016 or 2017? Any idea? Thank you

Hi there, If i wanted to see all bank transactions on SAGE 300 ERP Accpac that occurred on a particular day, how do i do a data dump of all transactions that occurred on that day? This includes all withdrawals,deposits, transfers etc. Ive looked around…

Can anyone advise me if you can run custom crystal reports against data that is on the Sage Online hosted offering. Also is there any way to query the SQL data through tools like SQL enterprise manager.

Hi there, Is there a document for Sage 300 2016 to direct the user as to which tables should be edited in order to change an invoice number in the AR module. thanks

I have left the pay codes and taxes blank at this time. Any ideas where to look for my error (s) ?

I started using the Bank Reconciliation module a few months ago in Sage 300ERP and have really liked it. However, I am running into one snag that I think there should be away to do this. Every month I have a couple of entries that I post for payments…

I've been attempting to import AP invoice details into Sage 300, and I've been successful in getting all of the distribution details to import. However, I cannot determine from a prior batch export which field I need to include for the Document Total…

I'm wanting to import miscellaneous receipts from an excel file and see that the system needs an Invoice # to be included. When creating a misc receipt manually the system will just assign a "made up" invoice # automatically when the entry is saved. I…

Want to do training using Sage sample Data, not using multi-currency company. Kindly assist between SAMINC and SAMDAT, which one is not multi-currency?

I am in a lab environment I have imported about 80 users, set to sage authentication method, password never expires, change password next login I need to run various tests that will require me to login as a bunch of the 80 users once i am done testing…

I have a single CSV file that I am importing invoices into Sage 300 2014 A/R. I receive no error on import but when I analyze the sage invoice compared to the csv file there is a difference in the tax1 amount. Eg the line total is 990.47 and the csv…

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…