• Sage 300 - Database is locked

    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 ?

  • AATRIX errors: AatrisForms.exe - Entry Point Not Found after tax update and product updates

    I am getting the following error when trying to run any government report:

    The procedure entry point [email protected]@@[email protected]@@[email protected]@[email protected]  could not be located in the dynamic link library d:\Sage Accpac\Taxfiling\aatrixforms…

  • Union report from different companies

    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…

  • Reprint of PO already received


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



  • How to edit G/L trial balance report?

    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.

  • Inventory transactions report


    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?


  • I/C document number


    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.

  • OE paid invoices report


    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.

  • RL1 forms rejected by Ministry of Revenue

    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…

  • Manual Journal entry report with user ID

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

  • Creating a sales report - which database fact tables to use?

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

  • AR invoice email to multiple contacts

    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?

  • unable to load report

    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…

  • Sage 300 2018 Error on export button

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

  • emailing from AR Office 365

    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.   

  • Sage 300 2014/2018 with Microsoft Excel 2010 32 bit

    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…

  • payroll check stub

    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.

  • Crystal Reports XI and Sage 300 v2017


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

  • Color AP check logo printing in black and white through RDP

    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?

  • System.InvalidOperationException: Plug-in host process not ready

    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?

  • Paystubs

    Can I reprint a paystub in Sage 300?  

  • Unapplied Receipts

    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?


  • Deadlock victim. [Database vendor code: 1205]

    The problem occur when user try to print transaction listing report

    Anyone knows why is this problem occurs?

  • Next Order Number

    in the OE Setup screen there is the "next document number" fields.  Do those store anywhere the I can use them in an alert?  I need to create a mechanism to check when people have manually entered it.  I just discovered another one and have about…

  • Memo field contains font description in Crystal Reports


    Not sure if that's the right place to ask. If not then please re-direct me to the right discussion :)

    I'm creating a Crystal Report to use in PO module, and when I run it, memo fields (like PO Line Description) contain strings like {\rtf1…