Sage 300

I notice OEORDH has a column EXPDATE but our customer service says it does not reflect the same date in the report they need. What is the column and what table is the expected ship date located?

Recently migrated client to Windows Server 2022 (RDS) Sage 2023 PU1. Printing anything takes forever - 18 seconds running AP Account Sets report. When I test the same report on SAMLTD it renders in a few seconds. There is no Customization Directory…

Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS

I am getting the following error when trying to run any government report: The procedure entry point ?selectNodes@CAXMLNode@@QAE?$shared-ptr@VXCAMLNodeList@@std@@PBD_N@Z could not be located in the dynamic link library d:\Sage Accpac\Taxfiling\aatrixforms…

Where do I specify the different companies to run the report in. I created a container and the report and it is currently "auto connecting" meaning the report runs in the company in which you are. I want the report to run the information on sheet…

Hello, Is it possible to reprint a PO that is fully received? Tried in Print PO forms, but it doesn't print. Thanks! Helen

May I know how to edit trial balance report in database? Because the amount in trial balance is not tally with the G/L transaction. May I know how to open the GLTRLA dll file and how to add dll to crystal report? Thanks.

Hello, I am creating a report based on ICHIST. I need to back-track each transaction to the originating document (OE, PO, MO, etc). How can I link the information in this table to other detail tables? Ty.

Hello, How does the IC document number in the movement report relate to the originating transactions? I need to pull the order information for some shipment and receipt transactions reported in the I/C movement report. Thank you.

Hello, We need a report of invoices by paid date. We use the distribution suite therefore we invoice through OE. Which tables do I need to use to pull the payment information in AR and link it to the OE invoice? Thank you.

We have a client running Sage 300 2019, Payroll 7.3 and the most recent Tax table update installed. They created their file for RL1 filing (Province of Quebec), and went to efile and receive a message that their transmission is denied The file was not…

I am attempting to run a manual journal report for 2020 that includes the UserID of the creator of each entry. Can anyone assist?

Hi there, To those who have undoubtedly treaded 1000 steps ahead of me...: What I am doing: Building my own sales report by going directly into the database and using a selection of tables. My report needs to answer: "what are we selling, to whom…

We are experiencing an error message when we have 2 customer contacts checked to be emailed invoices. When one contact is checked to receive invoices the email is sent successfully. Is anyone experiencing the same issue?

I have a report written over a Single View. The tables used include: GLAFS, ARCUS, OEINVH, OEINVD, OECRDH, OECRDD, ICITEM. When I run my report in Crystal it runs fine. When I attempt to add it to the ACCPAC SAGE300 Reports menu I receive a popup warning…

Custom report developed for AR invoices . User enters parameters and executes reports and all the data comes on print preview , approx 15 pages . As soon they click on export button the following error is received. generally user tends to run the…

I am unable to send emails AR since upgrading to office 365. I have setup the email tab of company profile to the standard smtp.office365.com, port 587, with SMTP checked SSL not checked, username and password confirmed and entered, use SMTP checked.…

Is there a work around or fix available for FR Reporter not working or playing up for sage 2014/2018 versions with Excel 32 bit office 2010. Get the error below when executing reports "PrintReport: Error on opening the xla macro. Have received…

I set up a reimbursable payable through Payroll. It doesn't show on the stub as a line item, but the amounts are included in the gross. We use Standard, but it is within the six line limit.

Hello, Does any one know if Crystal Reports XI would work with Sage 300 v2017? Crystal Reports XI seemed to cause my existing customized reports to stop working: - Before installing Crystal Reports XI, my Sage 300 (including Sage 300 standard…

We have a client on Sage 300 2014. They have macs they use to RDP into a server to run Sage. A recent update to RDP causes the AP check logo, which is Red, to print in black and white. Has anyone seen an issue like this before?

I'm getting this sporadic error on some clients. Doesn't happen all the time and after a little while they can login successfully. Any suggestions or insight?

Can I reprint a paystub in Sage 300?

We are new to SAGE 300 and made some mistakes. What report can I run to get a list of Unapplied Receipts so that I can correct them? Thanks!

The problem occur when user try to print transaction listing report Anyone knows why is this problem occurs?