Sage 300

I have a Sage 300 program, developed in VB.Net, that generates crystal report PDFs. When I run the program from the Sage 300 desktop on my client's server, it works just fine by passing the session token as a parameter. It also works fine running…

Hi all, A client wants to add the A/R invoice number to the email template. I've tried to search from F1 Help -> E-mail Message Variables, but there's no such variables named AR Invoice Number. Does anyone has any idea? Thank you. Yours Faithfully…

I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name. Now I want to add some fields to it that are not in the set of data tables already in the report. In the "Field Explorer" I right…

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…

I made a report with crystal report on my local, it all went well but when running on the client pc the following message appears

Good Day, our client upgraded there office from 32bit to 64bit. But now we are getting a class not registered error when trying to open macro to display user form. We have tried to reg edit the fm20.dll file and that also gave us an error. …

Hi there, This is my first post in Sage 300 online Community, woohoo. I find myself in uncharted waters. I am putting together a custom date formula, where the date has DDD field, which means 3 digits for "day in year". Example would be that today…

Hi, I wanted to add "invoice transaction description" into it original report file ARTBAL.RPT using Crystal Reports. But there is no description field found from it existing table in this report. The field that I want to add is in table AROBL.DESCINVC…

I wrote a simple macro in VBA that enters an order and then posts it. On post, SAGE 300 assigns the next order number. How do I return that order number to the macro? I want to put it in the message box for the user.

Is is possible to add new column to standard table like OEORDD? I'm converting the old system to c# and noticed that there are two new columns on OEORDD table based from this site: http://sageaom.kcsvar.com/AOM2019/OE0500.xml New columns named: PDTLNUM…

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…

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.

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,

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…

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 ????