Browse By Tags

Hi Everyone, Our company has ~20 custom reports setup in Sage 300 as well as a handful of Sage Inteligence reports created by our finance team. Recently, 2 of the custom reports have started prompting for SQL login credentials at the same time Sage…

I was trying to use Report Manager to copy the form from the company code that I created it in to all companies. It shows in the Report Manager and after I create the form code in the other company it is using the standard form. I have 250 companies that…

I know there's still some fellow "old school" CR users here ... I am updating our check form - simply making a couple of minor alterations to PAYRLCHQ.rpt I want to replace 47/100 with 47 Cents The form has no 'Page Header' when I begin. I click somewhere…

Does anyone know how to generate a report that shows Attorney, Amounts Billed for a certain period (A/R Transaction Date), and Invoice Status (Paid/Partially Paid) amount at the same time? I cannot find/create a report with these three items. Please advise…

Is there a report or log that shows Fiscal Calendar changes? We are in period 10 of 12 for 2016, and somehow period 8 START date was inadvertently changed from 01/06/216 to 06/01/2016. The start date is not even an editable field. No other dates were…

Hi there, I am reading the XML file by using RDSEQ, but the problem here is its not reading line by line, instead its reading no. line at time. Please advise !

I am running a COGS report for the week ending 4/15/16; however, not all of my invoices are coming up. I verified that one particular invoice in question was correctly posted in that time period, and the items are allocated to the correct GL accounts…

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…

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…

I did create a new form in sage 100, but how can I make it appear in the report setting list. I am using Sage 100 2013 V 5.008.00, ( We will upgrade soon the 2016) Thank you for your help. Joe

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?

Hi, Can I add the user name who is printing the form on the form? Thank you!

I'm new and would like to implement so i can learn, business insights dashboards. sage 500 7.40.8.0

I am trying to figure out how to unbold professional services and previous balance on the bill layout. Instead I would like to bold the total balance due and make it slightly bigger. Is it possible to create a report that has each timekeepers billable…

I am trying to create a new report through the reporter. When I give the report a name and choose where it will be in the reports it puts me to the next screen where I should select a template (Landscape, Portrait, Shipping Label.) At this point no matter…