• Financial Statements fails to open in MS Office 2019 Pro Plus

    Hi everyone, Does anyone know a solution to this error when running G/L Financial Reporter to Print Financial Statements? We are using Sage 300 2022 and 32-bit MS Office 2019 Pro Plus on 64-bit Windows 10 Pro. I've enabled all macros and did a repair…
  • Need to update a crystal reports invoice with a specific field

    Hi - how do I find this in crystal reports to add it in: So, where do I find that "Item" in the field explorer in crystal reports so I can map it to the invoice Thanks! Dan
  • Multiple users printing different customer statement concurrently - sage 300

    in one of our client , Users cannot print different customer statements concurrently. Is this how sage works? If for example a user has printed a statement for Customer X and while it is still open on his machine, another user tries to print a statement…
  • Report of Additional Costs

    We add inbound freigh as an additional cost on our inventory purchases. How can I pull a report that tells me how much I'm spending on inbound freight?
  • PO wont display amount

    When I print my PO to PDF the amount is displayed by #### symbols. Is this a formatting error? I attached a snapshot of what it looks like. Thanks!
  • PJC work in progress report

    I'm trying to figure out the WIP report in Sage. The report in PJC doesn't give me what I would consider to be a proper balance even when looking at the totals in the contract maintenance screen. My client and I have run this on live data and on the sample…
  • FINANCIAL REPORTS IN DETAILS

    I have chart of accounts with two segments i.e MAIN & MAIN SUB 1234 Repair and maintenance 1234-01 Repair and Maintenance - HQ 1234-02 Repair and Maintenance - TZ 1234-03 Repair and Maintenance - ZM On printing financial reports only Main…
  • Sage 300 financial reporter

    Hi there, Can someone help me out an FR function here. I am new to the FR designer. I am using a report template that was created before me, function is below, but it returns the date format like 5/31/2021 =FR("PERIOD")&" Months Ended "&FR("END…
  • Error "A generic error occurred in GDI+" during GL Transaction Listing Printing

    Hi, I have encountered an error, when printing a physical copy of GL Transaction Listing from the crystal preview. An error message of "A generic error occurred in GDI+" will pop out and my print process couldn't be done. There are no issues when printing…
  • Paid customer and job remain on AR Aging Detail reports (not crystal)

    Our AR Aging Detail by Job is showing a job that has no balance, and our AR Aging Detail by Customer is showing that customer with no balance. There's nothing that I can find to adjust on this customer. I found some forum posts on receipts and invoices…
  • Printing error

    Using Sage 300 2020 with a shipping Macro that worked last week and now when printing packing slips we get the error.... Automation error The object involved has disconnected from its client. This only seems to happen for specific user. When logged…
  • Sage 300 2019 standard crystal reports not printing in desktop

    When printing the report runs and close without displaying/printing, this is on all print destinations preview/printer/file/email
  • Is there any easy way to show the currency used on a purchase order

    I have a client entering purchase orders in different currencies, but when I print the purchase order, it does not display the currency being used on the order. Is there a simple way to add that information to an order?
  • Error in File OELABEL ... The table could not be found

    Hi Citiers, I have searched around and and followed all the tips found here there there with no uck. I decided to knock on your door to check if you have any solution, hint, tips and a clue on how to debug this error. We got an Windows Server…
  • ALL AR/AP INVOICES

    Hello Team, Our client who uses sage 300 ERP requested for a report of all AP invoices and AR invoices for a vendor and customer respectively. Specifically, the invoices that have been paid for in the past and yet to paid. What report can we spool…
  • Am getting an error when am printing customized crystal reports on web (Sage 300 2020 PU3)

  • FR Account suppression

    How do I suppress inactive accounts in FR I have tried ACTIVESW=1 in column B but it does not suppress the account # in column A
  • Row Edit Query

    I am creating a customized report on sage 300C webscreens intelligence reporting. After selecting a set of rows, when i edit a row it couldn't be save or proceed further. So i have to close the report.
  • Inventory optional fields

    Hi, Are the inventory optional fields a searchable fields? Can I use it to generate reports and stats? Thanks!
  • No reports work on Sage 2020 PU2 Virtual machine. Other workstations work

    We have a Sage 300 2020 PU2 installation that works on most workstations, but one virtual machine running windows 10 Pro 64bit does not work. The issue is that when we print a report - any report, it runs the database record select and then stops…
  • Commitment Count - Total & Unique

    Is there a canned report (or a canned report that would require minimal manipulation) to determine the total count of commitments that were issued in any/all jobs over a given period of time? We're trying to determine: 1) How many commitments were…
  • OE Label Printing Very Slow

    I just started to use the label printing feature in Sage 300 2020 Update 2 and it is very slow. My last test took almost 6 minutes to tell me that there were no labels needed to be printed. Is there any way to speed this up?
  • Cannot get the calendar to show up when adding a parameter to a report

    I have created a new container and report, but when I attempt to add a start date >= parameter, it will not show the calendar. The user has to enter the exact date. Any ideas?
  • FR Report Problem - Z Not Omitting Zero-Balances and arguments not taking

    I've built an FR report. Its very straightforward, I have each individual account listed in column A but grouped together into line items. For example Column A ACCOUNT, ACCOUNT, ACCOUNT, ACCOUNT ACCOUNT, ACCOUNT ACCOUNT, ACCOUNT, ACCOUNT ISSUE 1 I…
  • SAGE 300 ERP crash when running User created reports

    I created a folder (new Object) that contain customized reports in Sage 300 premium (version 2016). When I run these reports Sage crash and closed with no error message. The reports I created work well in another PC. What can be the problem?