Sage 300

A/P Payment Inquiry comes up blank regardless of input parameters Sage 300 2017 PU5 Running as ADMIN

When clicking the "Print" button on a report options window, the window closes and nothing shows. This is happening with all reports. User is on v2018. This is happening on multiple machines. Appreciate if anyone has seen this before and has a solution…

We have Sage 300c installed and the Web Screens are accessible. However, none of the standard reports display on the web screen if accessing them from a workstation that doesn't have Sage workstation installed on it already. Is there a fix for this…

Where can I find the last date of sale for particular item or items?

When running the inventory on-hand intelligence report I see that one item at one location is showing a quantity onhand as twice as much as it should be. The costs are also showing up at twice the correct amount. Any idea of what is happening. We look…

Trying to customize the "Commitment Cost Status with Full Detail report to show invoices and check numbers on one row, instead of listing in separate rows. Not sure if this can be done.

I am trying to create a report that pulls all OE sales by month and includes standard cost, average cost, most recent cost, last cost, alt cost 1 and alt cost 2. I can't seem to find which table or view has all of these costs. It looks like they are…

My company is looking into the possibility of developing an ASP.Net MVC application to view custom reports that are designed & created by our users through Sage 300 ERP Suite. I believe there is the .Net library to integrate with Sage. Can we develop…

I find it cannot print out or preview the built-in standard sage 300 crystal reports with windows 2003 at the c/s workstation level.Everything else is normal. Is it incompatible with windows 2003 and winxp used by sage 300 2016 c/s workstation Level…

Where is a report that shows the Unbilled PO Receipts in Sage 300?Un

I want to create an intelligence report that only shows inventory items where the quantity on hand is less than the minimum level. I do not see how I can add a comparison in the filter area against another field. Can this be done? I have also tried to…

Dear Friend, My company are using a several-section numbering for GL code and i would like to know how to wildcard the first part of GL code? For example, GL code, 100-02-03,101-02-04,102-02-05, 102-03-01 etc. if i like to use wildcard in the first…

Is there a procedure required to update the price list item descriptions? Only the item status reports show corrections at this point.

Crystal report datapipe connector fix from years ago does not work for Sage 300 2016. Will Sage release another fix?

To all Sage300 Report and/or Crystal Report gurus: I have an item optional field that holds a number value that I need to use to compute a quantity for each line item for which I need a running total in the footer in the OE invoice report (OEINV01.rpt…

Hi, i get this error when open BI Report Manager I'm on Sage 2014 PU3 "The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statment accordingly. The SQL statment supplied was : - SELECT…

How do I create a sales tax report on a cash basis? In Illinois small companies may file their sales tax return on a cash basis. How can I see the items that have sales tax that have been fully paid.

How do I generate a report that shows me the non AR cash receipts? Or how do I generate a report of only the MISC cash receipts? Currently the only way I know how to do this is to print the AR journal and ignore any transactions that include the AR account…

Sage 300 2014 Intelligence Report getting an sa login failure when attempting to run a report with terminal server. Any ideas? Everything else appears to be working.

How do I add an Custom Field from an inventory item to the picking ticket? I actually want to a 10 custom fields the report

It there a way to not show the discount date and discount amount when the discount amount is zero?

Is there an example of a Cashflow statement in Intelligence Reporting? I am looking for one and do not see it.

Datapipe report runs well in Crystal Reports preview, but when placed on desktop this error is received "..\a4wdp.c line 372". Copied datapipe.ini file for ICSLOW and commented out stock report and entered my report name and parameter. Copied same…

We have just upgraded a client from Sage 300 5.6 to 6.2. We had customized the OE invoices on 5.6 to print in draft on pre-printed stationery using dot matrix printers (Epson LX-350, Epson FX-2190 and OKI ML280). After the upgrade, the forms still work…

How do you create a report to show the sales for a national account if the customer numbers are not contiguous?