• Querying SQL server Invoices vs Sales History discrepancy

    I am trying to validate some data for our team and am stuck trying understand the data layout. My boss is using stonefield reports to generate a monthly sales report and he has 2 versions generating different #s. There seems to be confusion on what date…
  • Sage 300 Web screens - You do not have a license to use this product. Ask your system administrator for help.

    Hi I have a client who is running Sage 2018 Pu 2 windows server 2019 I have installed the web screens, and run the portal. As soon as I access the web screens I get this. I can confirm the web licence is activated. I am wondering if the…
  • Use Browse() with "NOT IN" where clause/filter

    Hi, I need to do filtering using the "NOT IN" just like in SQL SERVER, but with Browse() function in ACCPAC library. I try using NOT IN with browse but got error, I guess its not supported. Is there other way to filter similar to "NOT IN"? Thank you.
  • How Company Color Code in Hex

    Hi I'm trying to get company color but I haven't the same color with Sage, Someone can help me please Dim Company As String Company = AccpacSession.CompanyID Dim System As String System = AccpacSession.Organizations(AccpacSession.CompanyID).SystemDatabaseID…
  • Unable to Print to a Custom Payment Voucher Form

    I have a crystal report which is run via Sage 300 desktop shortcut [Macro] which has stopped pulling data through for some batches. The Crystal Report only shows a blank Custom form for some A/P Payment batch entries and will pull the data for some batch…
  • 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…
  • accounts in General Ledger

    How do I add sub-accounts in my chart of accounts? EX; Account 64000 - Marketing shows I want to add travel, meals, supplies, freight all under this account. Marketing Shows Travel Meals Supplies Freight
  • 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?