Sage 300

Just upgraded to Microsoft Azure. Same version of Sage300 and crystal reports. If you print preview a report fonts are crazy and look strange on screen . Export and view in Adobe font is as specified in the report layout. Arial font is loaded on server…

Reports do not print from the Sage 300 Web Screens. No error message or warning is displayed. I tried to open on server and on client.

I am attempting to create an On-Time Shipping Report. I want to add a parameter to only show items shipped during a certain date range. I am using the same logic as the OE Sales Report, but my parameters are being ignored and I see all records. Any…

Hi, The scenario is like this: The Financial year is Jan - Dec 2021 while the transaction that entered in the system is until Jan 2022. Note that the user is not yet create new year as the transaction of Dec 2021 is not yet completed. So, here, how…

Has anyone had any issues with being "black listed" by your email provider/server for emailing AR statements, invoices, etc... from the Sage program's email capability? My IT people are concerned because we are one division (using only Sage) of a larger…

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

How can you select more than one invoice for the sane customer and email in one go

Using OEINVD and OECOINI tables for report and trying to get item/miscellaneous comments. Somehow I am not able to get comments to match. Any tips?

We just put the Tax updates for January on our system December 31. We are on version 2021, UP73 product update 30. When we enter all of the parameters on the screen for the Payroll Employee Information Report and hit print, it crashes. By crashes I mean…

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…

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…

accpacPrintSetup = accpacSession.GetPrintSetup(" "," "); on reaching this line application crashed

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…

Hello Team, Is it possible to export the Invoice in PDF format from Sage 300? If yes, could you provide an example of how to do it? Also, is it possible to receive the Invoice PDF via API from Sage 300?

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…

We need to retrieve Purchase Order details to include the PO # and "Ship to" name. Can this be done with canned reports in Sage 300? My searches have come up empty. We have intelligence but not Connector. The Purchases Master report doesn't appear to…

When printing the report runs and close without displaying/printing, this is on all print destinations preview/printer/file/email

How is Sage addressing the new form 1099-NEC and when will any updates be available? Will there be any changes required in the Vendor profile information?

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?

Created a custom crystal report for client with Date from and Date to and customer number as parameters in order for sending all invoices to a particular customer for a specific month or range of dates. The custom crystal report on the sage server…

I am trying to print the aged payables report in functional currency as at March 31. The problem is, that its showing some documents with dates after March 31, just because those documents were applied against prepayments with dates before March 31. This…

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

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.

Hi, Are the inventory optional fields a searchable fields? Can I use it to generate reports and stats? Thanks!