Sage 300

We're printing a custom report (PJC) built using Crystal Report 16 and running Sage300 Premium v7.0 2023 How can we resolve the error below?

This is hopefully a simple request. Trying to use the stock APLETT01.rpt form and have it filter out all "inactive" vendors. Focusing on the {APVEN.SWACTV}=1 field as a record selection but cannot get it to filter. I assume it has to do with the APSLVEN…

I'm creating a customized OE Entry screen. I want all the users to have the exact same fields and detail columns. I'm able to hide fields on the header level using the code below. But I'm not sure how to hide specific detail columns. Anyone know how to…

Hello community, On SAGE 300, there is a way to have a "PAY NOW" button directly on the invoices sent as pdf to customer by email. Then when the customer click on it, he got redirected to a secured web portal transiting between Sage money and third…

Hello, Getting the below issue while activating the newly developed module. I am able to create a flat view that is independent but when it comes to creating a join subclass view in the below tables like ARCUS, ARIBH, OEORDH. I am getting RVSPYTRACE…

I am looking for an excel template to import Sage 300 AR Receipts. Would anyone be willing to share one?

Hello Community, I have a customised version of the Order Entry screen (OEOrderEntry.exe) which was added to O/E Transactions panel. Then the point was to prevent users to use the original Order Entry screen (program OE1100). I found out that I cannot…

Hi everyone, I dont remember exactly but Im sure we could copy some folders/files (\USER I think so) of Sage actual installation at server (they have Sage 300 ERP 2012) to new server installation (Sage 300 2022) so we can recreate icons users run -…

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…

Does anyone know if this program is capable of inserting a signature on a cheque? if so how? If not what do others use to do this?

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…

Is there a way to quickly remove earnings and deductions from employees or a group of employees utilizing a selection list or range? We use the assign and update tools frequently, but are needing a way to quickly process a removal of a specified earning…

Is there a way to add fields to Enter Invoices in the AP module?

We are running Sage 300 Premium version 2022. When we go to Customer Inquiry screen and use the Invoice Drill down - the view has a tab for Optional Fields - but the O/E Invoice optional fields are not being displayed. If I pull up the Invoice from the…

I can currently change budgeted amounts in the "Budget Maintenance" window; however, I am wondering if I can do so in such a way that a record is kept of the changes and, ideally, a note can be left to explain the change. Does anyone know if this can…

Sage menu invoked an XLSM file Inside that XLSM file I want to use the invoking Sage300 session because customer has limited licenses So do not want to login and make another session with another userid and or have to know user's password etc. sort…

hi all, I am following example on this link https://www.sagecity.com/us/sage300/b/sage_300_erp_r_and_d/posts/launching-non-sdk-programs-from-the-desktop to create a screen using C#. I am able to create and working fine. However, the details is not looking…

I recently got new checks for payroll and they are not the same as our previous layout. How can i change the printing layout in Sage 300 PR?

Is there any option in bank entry module to input cheque number?

I am trying to have a calculated cost - ie. Ic most recent * 1.8 rounded up to the next 100. Say I get 2445 that would print 2500 and then I am trying to substruct 1.00 from 2500 to get a new sales price of 2499. I am using two formulas one to get the…

Hi, Does anyone know who can create macro to import autosimply MF Issuance and MF Assembly Receipt? We have a different system to control manufacturing and I need to import this automatically and periodically (so ideally we need .exe file to execute…

I'm using "Sales master by Customer and Items" report in Sage Intelligence and I need to see the USD currency customers converted to CAD currency amounts. The report displays all USD vs CAD customers in their own currency but would like to have the USD…

In sage 300 I can define the bank code: A/P -> A/P vendors --> Processing tab -->Bank Code However I couldn't find a way to set nor retrieve the bank account. Is there a way to do so in the application / via the RESTful API?

We require a National statement to be sent to the head office, but We need the statement for the national account to show all the branch invoices and payments on one statement. Please can you assist with the customized report.

Recently upgraded a client from Sage 2014 to 2023, several custom crystal report run ok but one gives an " Invalid agrument for Database" ? It runs ok on my laptop . I am thinking it has to do with the new ODBC driver 18 and/or the new 2019 MS-SQL but…