Sage 300

Hi All, May I know is this the limitation in Sage 300 2017 PU6 whereby user unable to import AR Invoice line comments with line break? One of our clients encountered this issue recently. At first, this client was in Sage 300 2017 PU3. Hence, we…

When I try to import excel file to bank entry UI, the header and details files not upload correctly, one bank details data automatic transfer to another bank code when upload, why this? Can anybody help me.

I can successfully upload A/P invoices using the basic template included with Sage 300. However, if my invoice number ("IDINVC") includes any text (e.g. "A23456") the upload fails with the error message "Document number cannot be blank". It is very…

Description: Failed to process the file due to an unspecified error. When I try to import an OFX file I get the error above. It worked five months ago when I tried it last. I have rebooted the server and the workstation. I get the same error whether…

Anyone know if there is a way to generate an export file from a list generated using the GL account code change pattern. I have generated a very extensive list of GL account code changes using patterns in the lab. I am wanting to grab that list and turn…

Is there a list somewhere of the minimum REQUIRED fields for importing into SAGE 300 modules? Rather than experimenting with exporting everything and removing columns one by one then importing until it fails? I'm specifically looking for payroll timecard…

Hi, I have a test company with 20 banks defined which I exported in excel to import to the production company. Import fails on record 1 with the error "There is no entry for statement currency in this bank's valid transaction currencies." Although the…

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…

how do I import data into a new Sage 300 database? I would like to import data but I have never done it before. Can some one give me any advise?

Hello, I am setting up an import template so that we can take all of our payments and apply them to the outstanding documents / invoices. I am wondering what the field is called in import to make that happen. If I was manually entering it in sage I…

I need to remap a bunch of the close to account. Instead of me going one by one and selecting close to segment, can I just export this data and then do an import to fix it ? When I export the G/L Accounts screen I get the options to export basic account…

Hi All, Trying to fill up an import template in Excel - As you can see in the screenshot, there are 4 transaction per journal entry but in some cases there are 5 - 6 transactions as well. I know that excel follows a 20-40-60-80 patter in the TRANSNBR…

The recurring entries will not run because the last run date is later than the date I need (2 months later - batch was run and deleted by mistake). I tried exporting the entries and importing them again but it does not update the last run date. has…

I have a client, where for a couple of companies, I cannot export the customer or ship-to records. When I attempt to export my customers, the screen that shows the records, the first record should be customers, but it only shows a "-". If I look at attempting…

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?

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…

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…

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

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

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