Sage 300

Hi All, can we import Qty Cancel at PO Receipt? Or any macro or tools for this?

Hi, I have tried to import PO Receipt Entry using Single CSV file format. The data import showing no error message. However, when I call out the receipt number, only header with data but line details showing blank. Choosing the Single CSV file for…

Normally I import into PO Receipt Entry using an ODBC connection to the tables. Recently I've run into a issue where the receipts will import but upon checking the receipt, the header populates but is missing the PO line details and Export SetID. This…

Hi, is there an online video to explain how to do the following: I want to export on excel particular info from invoices. I tried to do so but get an error when trying to set up criteria. i would need in particual cust name date inv # the detail of each…

I have been trying to transfer items from one location to another but every time I try, I receive an error with the importation. What I did was try to export a single transfer, however, it exported everything even the ones that are posted from way…

We have Sage 300 2020 running on a Windows RDS server with multiple users accessing the application via RemoteApp programs. Everything has been running fine for a couple of years but randomly last month our users cannot export files any more. A user…

I am reaching out because I have diligently followed the installation document step by step for importing simple data. However, I encountered an error, as indicated in the attached screenshots.

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…

Hello, When we try to export the Employee section of Payroll employees in the Canadian Payroll module we get an error message before it completes that says, error - Type Mismatch, LASTRAISE field should be date. It also says error - stopped processing…

Hi All, Kindly advise on where i can get a list of customers with all information updated such as email address, customer number, postal address etc.

I was importing an excel invoice template getting error in sage 300: invoice invalid characters put to field 'remit-to location' Thank you

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…

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…

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.

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.

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…

Where can I find the template for importing A/P invoices? Someone mentioned that I can find it under the Data folder, however I don't have a data folder?

When I upload excel file in bank entry module, the file row is broken. All row is not inserted to the bank entry at a same time, some rows are missing when uploading. how can I solve it, can anyone help me.

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.

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.

Can someone please help me build a csv for order entry import? I've tried to export an OE Order but it's too large and keep failing. If anyone has a template or a resource or any other guidance I'd really appreciate it. Thanks!

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

Hi We recently upgraded to 2023 PU1. The operating system is Windows 2019. We noticed that there is no 2007 export/import option on all the desktop screens. Please note that Excel 2016 is installed on the server. An article in Sage KB related to…

Hello. I'm working on importing A/P data from SAGE Accpac 6.0a. Nowhere in the SQL database can I find a table with a column for a voucher number. Am I missing something? Thanks in advance, Mike

Hello. I'm working on a project where I need to extract the purchase history from the company's Sage Sql database. According to the documentation located at https://sageaom.kcsvar.com/AOM60/POHSTL.xml the TRANSTYPE of 2 is a Purchase Order. I know…