Sage 300

Hi, We're running Sage 300 2022. We just got Paya installed and did our first Credit Card transaction. I'm still fairly new to the usage of Sage and Crystal Reports. How do I customize our receipt confirmation report to include Order Number or an Invoice…

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 have modified the original invoice footer with 2 format options by parameter field on Bill Type for user to select the format when printing. Example Footer A for Standing Billing Footer B for Tenant Billing Below is the formula from the existing sage…

I need to make a minor change to the L-PB Detail with Stored contract invoice format. The CNAME in TS Billing Field Names is giving our group name instead of the Company name. We have 5 companies and I need it to give the correct Company name based on…

Hi, I wondered if I could tap in to sage city for some advice, as I am frustrated with support.na.sage The whole reason I am here, is that when I search the support site, I get to a issue, on the topic I want to learn about, and the article has a an…

Can anyone recommend a Sage Specialist for writing reports in the Financial Reporter in Canada? I need help and it can't be someone who is just learning to write these things, its a little complex.

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…

Greetings! In the data dictionary, for the above table, I see an 'ENTEREDBY' field; when I open POPOR04.rpt to try and modify it to include the 'ENTEREDBY' field in the report, I do not see this field in the POPORH2 table in Database Fields panel of…

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…

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

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

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

I have successfully added the territory field to my sales report is Sage Intelligence, but I cannot get the field to total correctly. If I put the field before the customer number it total, but only for each customer. If I place the field to the left…

Hello, I am trying to reduce the number of decimal places shown in the Unit Price field on my invoice template generated in Crystal Reports (a custom made OEINV.rpt) The field is currently showing six decimal places on items related to labour (i.e…

Hello, I am trying to reduce the number of decimal places shown in the Quantity ordered, quantity shipped, and quantity backordered fields on my invoice template generated in Crystal Reports (a custom made OEINV.rpt) Each field is currently showing…