Sage 300

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, I've been working on a solution where we invoke BICore.exe (through PS and/or Batch script, tried both). When BICore is run, the workflow creates a report and sends an email and works perfectly when I run the script manually. Process lasts around…

I recently added a notice about accepting credit cards to our custom AR Statement via Report Designer. However, It only prints on the last Statement. I see I should be able to change it in the Print Controls way at the bottom, however, when I go to the…

Hello, Which change do we need to do to the unit price formula in the OE invoice form to go from 6 decimals to 4? This is the formula in our Crystal form: IF {OEINPR3.LINETYPE} = 1 THEN IF {OEINPR3.PRPRICEBY} = 1 AND {OEINPR3.INVDISC} = 0 THEN //…

Hi - I have a program that is importing orders (downloaded from an ecommerce site) and sometimes there is a general discount applied to the order. Sometimes there is a taxable item on the order. When I import the order into sage I am using all of the…

I am writing some reports on a machine that does not have Sage installed. Can I find the dll that has the custom Sage formulas like pwFormatDate() and istrue() somewhere on a machine with sage in order to copy it over?

There must be a simple formula for the FR date function on 12 month rolling income statements that crosses fiscal years. If I have the current selected period =@FR("End") in the first column and want the 11 preceding months in the next 11 columns, what…

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 need a crystal report that I enter an invoice number and other details and get the invoice copy. I need to drive the report inside crystal reports editor and not from sage. I checked in "PROGRAMS\OE62A\ENG" for oeinv01 ~ oeinv05 and none seem to allow…

Hi, we get an error message while trying to run an AR invoice for a newly setup company, all of the settings appear to be fine but the only issue is when we try to generate an invoice using the ARINVO.rpt file unofrutnately i keep getting a Vendor Code…

Hi all, May I know is there any ways to get Sage User Id based on username provided? Many thanks.

Hi All, I am creating a new customize program to import invoice in bulk from excel file while referring to a recorded macro on Sage. The import of Shipment number and its detail lines are fine. But when I try to insert to OEINVH, I got this error "The…

I need to replace my budget macro because it has been overwritten by an excel worksheet. How do I do this?

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 We have difference details input in "Doing Business As" and "Legal Name" in the Company Profile. And we wanted to add these 2 field in our FR. But the field name "CoName" from FR Paste is linked to "Doing Business As". I can't hardcode this…

Hi, we have a customized order confirmation form. i added to the webscreens reports. it prints fine but the parameter prompt does not allow you to search or select options such as check delivery method. values must be entered. any help resolving this…

A sage 300 company with 15 users runs into the commonly seen problem where users forget to logout at the end of the day. There is a nice feature where you can sign out users from the lanpaks licenses screens manually, but has anybody written a macro to…

GL Transaction Listing Report looks like a dll type report. Can someone tell me from which tables it takes the data, we require this to make our own customized report.

Note the is a .NET application written in C#. I have an application that imports orders, purchase orders and inventory items into Sage. The customer supplies a file that contains all of the purchase orders w/items. The file is parsed into purchase orders…

I wrote a .NET application for a customer that created Orders/Purchase Orders. No problems with doing that. Now I need to update those Order/Purchase Orders. The problem that I am having is that I can't insert detail items where I want them to go. For…

We have a database for Company A with 10 branches and another database for Company B with 6 branches. Both using the same COA with Segment-1 as GL Code and Segment-2 as Branches. We need an Income Statement to show the comparison of branches in one…

Hi, Is there a way to block the Print Transfer Slip Confirmation Dialog box from appearing for IC Transfer. We have created a custom Print form and wish to suppress the standard Print confirmation alert box which appears after Saving or Posting a Transfer…

In previous version, SAGE 2017. This code works fine. But after upgrading, it crashes. Dim oRpt As AccpacCOMAPI.AccpacReport oRpt = oSession.ReportSelect("APWMSSOFTRMT[APWMSSOFTRMT.RPT]", " ", " ") Dim oRptPrintSetup As AccpacCOMAPI.AccpacPrintSetup…

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…