Sage 300

I am able to print standard reports such as gl trial balance, or vendor transactions but I am unable to print OE invoices using the supplied oeinv01 or 02 rpt. When I do I get the error "redirected you too many time". 1. Does anyone know what this error…

Hi, I am trying to make a Crystal Report that shows all the invoices and credit memos in Order Entry. Right now, I tried using OEINVH, but I don't see Credit Memos. Is there a way I can make a Sales Report that shows All Invoices with Credit memos…

Hi Guys My client recently have upgraded from v6.0 to vv2017. Also change from SQL 2005 to SQL2016. They are running on VM machine (both old and new server). In the old VM, they are able to print the IC Valuation report from 2005 to 2017 (by Transaction…

Printing customized forms - Database login screen. I have no issue printing order confirmation, invoice or credit note in V6.0a. But when printing in Sage 300 V2016, I am getting the database login windows - any ideas what needs changing to the forms…

Is there a report that contains total sales for a specific date grouped by state?

I am using SAGE 300 2016 and would like to be able to reprint orders after invoices have been created. I read the post about reprinting PO's so I am thinking that I probably have to do similar but do not know which forms to use and what changes are needed…

i have altered the icrpt.ini file the icwk04 section to indicate portrait this used to work but now the report still prints landscape. Is there any way to have this print portrait like we used to be able to. [ICWK04] heading=52002 crystal=ICWK04…

We have been running a report that uses the last invoice date from the Customer Inquiry screen. When we attempt to verify the date we sometimes find invoices that we created after the date on the record. Any idea of why some invoices do not update this…

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…

Trying to change the form in Sage 2016 so that it uses a ODBC report instead of a datapipe report. The client is on Sage 2016 PU1. Changed the oerpt.ini file by commenting the sections on OEINV01 that points to datapipe, however when trying to run…

We can't get any results in the Transaction History Inquiry, regardless of what settings we use, including leaving it wide open. There are nearly 4 months of activity in the system, so *something* should be showing up. Where do we start trying to troubleshoot…

Hi There, Is there a way to get reports that shows us only non-invoiced shipments?

I am looking for an inventory report where they can print out the value of their inventory at a point in time. Client is working on their March 31, 2016 year end and they would like to print out a report that shows their inventory at that point in time…

I have a client that just received a new computer. We did the workstation installs, but now she can print an invoice, but cannot e-mail them. She receives the following error: "Crystal reports print engine not opened” Any ideas? She is using Outlook…

I created a sub report for the order action report to add the shipvia code. The report works fine, but asks for a user login and password every time I run the report from a workstation. If I run the report from the server it works fine. Any ideas?

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

Hi , We're using Sage 300 2014/Windows Server 2008 R2 and when we print in Purchase Order (standard report), preview displayed blank, we have this issue only with PO. Any ideas?

Hi, I'm using Accpac 6.2. I've created a crystal mailing label report which I wanted to use to print item labels under I/C Stock Control Reports > Item Labels. I now try prinitng the report but get an 'Error Load Library' error. The default report…

Hi Everyone, I faced some difficulties here with the reorder report and i hope someone can help me here. I try to used the "Reorder Quantities" function (IC --> I/C Items and Price Lists.) Setting the Min Qty, Max Qty, Reorder Qty and Projected Sales…

The taxable income is showing up incorrectly on the W2. How can I correct this?

When we first started using payroll, one of the deductions was marked before tax, but was an after tax deduction. I have looked every where I can think of and I made some changes to the deduction records, but the tax income on the paystub stills comes…

We need a receiving copy of a PO - same as the PO but without costs - to give to the receiving department in advance of the product arrival, so they can check it in. The receiver in the PO module seems to be designed to be printed as a proof of receipt…

I'm to build a report based on project that lists all the invoices associated with that project - does anyone know what links I can use?

After installing Sage 300 ERP 2014 PU3 what changes should be made in PORPT.INI to get POPOR04.RPT to work? it works until PU# is installed.

How do I see the activity for miscellaneous freight charges in order entry? The only report I see just lists the set-up information for miscellaneous charges.