Sage 300

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…

Our client upgraded from Sage 300 2014 PU5 to Sage 300 2019 PU1. We had developed a specialized invoice form for OE for them. After the upgrade everything is out of alignment. Any ideas why? Sam

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.

Hello, I want to create separate income statements for each segment and save it all on one workbook using Financial Reporter. I understand that you can print the income statements divided by segments as separate workbooks but I do not want to spend…

A client wants to add the invoice number to the emails subject line not only the $COMPANY_NAME. Is there a way to incorporate the invoice number either on the subject line or the pdf name without doing it manually? Thank you,

We have NOTES in the optional fields in Ship-to Locations, so they show up in order entry. I am trying to get the note tied to the ship-to location for that customer, to populate on the order confirmation form. My problem is that I can't find the field…

When printing customer statements, our remit to address is not showing on the statement. How do I this information?

I'm currently working with a standard job cost report that shows employee hours at T&M rates with certified classes on it, but it is actually pulling the certified class from the employee set up. I want it to pull from the actual weekly payroll certified…

We are migrating Sage to a new server. When I move over the custom crystal forms, some of them are prompting for a sa password before running. I have checked all my database connections. There is one difference between the two database connections - when…

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…

Hi folks, I work for a foster care/adoption agency and we're trying to modify our child care cost sales invoice templates in Sage. Usually our invoices have the client listed as a county department of jobs and family services, and billed to the foster…

I have a macro that contains the GL2100 OCX (journal entry screen) When run on site on a particular computer the form pops up , there is no error message but the ocx does not show at all On the same computer, al macros that contain OCX have the…

I created a label report with a dynamic parameter for the user to select the range of items to print, and am trying to run it. It runs - but only with a fraction of the items in the range list (there are 30,000 items). I did the List of Values fix in…

i have the below Exception please any help ????