Sage 300

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…

I've added the DataSource Control and FEC control to my Form ok. My COMAPI session is working fine. I'm running into a couple of issues getting the FEC working. I'm getting the following error trying to set the DataSource control to active. Also I…

I have a client that wants to send the financial reports to a partner that does not have access to Sage 300. We would like the partner to be able to change the parameters on the Excel workbook that is e-mailed so he can take different looks at the data…

How come I can condition down to job or entiy in "Generate Work in Progress" but when I want to "Generate Cost-Based Invoices" I cant condition to a whole entiy, ONLY do job by job OR every-single-job in our system. ?

I am attempting to add ICITEMO fields to my OE picking ticket, but some how I cannot select the ICITEMO table in my sub report. I do not see any of the optional field table being able to be selected. Any ideas of what I am doing wrong.

I can't find any functionality for coding a specific period from 1 year ago in a fixed 12 month financial. I've got multiple columns set-up with FRAMTA ("NET1P"), NET2P, etc. and I want to add the same period from 1 year ago. All I can find is formulas…

I have a client that i upgraded from Sage 300 v2014 to Sage 300 v2022. They have some macros where some of them needed some minor changes. One of them prints a bunch of forms and they print them to different trays of the printer based on a screen selection…

I need to add a summary section to my invoice report with the value of the invoice from the previous year (if there is one). I plan on storing the batch number for the previous years invoices in the invoice optional fields. Here’s my formula to get…

Hi, Are there any 3rd party add ons that will create a bank register showing all the transactions to get to the bank balance? Similar to the quickbooks bank register. Or is there any report that can be written in sage to accomplish that? Thank …

If you have to print multiple instances of a (seemingly any) form (with different parameters, order number, invoice number) using the COM AccpacReport and AccpacReportSetup types they leak a lot of memory. In the space of 200 iterations there is about…

Hi Team Is possible to create a QRCode with (check number, date, customer name and amount) information to make it easy to index and store in a document management system? Any idea ? Melvin

Getting below error when calling API for AR module. The 2 config files are enabled ( https://www.sagecity.com/support_communities/sage300_erp/f/sage-300-general-discussion/110205/unable-to-make-a-get-call-using-sage-300-web-api ) and in Sage 300 USER…

Hi, I need some help figuring this one out. I am trying to automatically export I/C Internal Usage reports from Sage 300 using a C# console app. I have recorded a macro in Sage 300 and have used the macro to successfully export the report to PDF.…

Hi, I was asked to create a custom service that will do the following: 1. Get Purchase Orders based on specific criteria 2. Export each Purchase Order using the standard Crystal Report file to a PDF document Getting the purchase orders is…

Hello, Where can i get a template for PO Transactions > Receipt entry? I have a couple of entries that have multiple lines in excel and i have to code them again. Just thought of doing import transaction but i do not know where to get a template to…

Found an interesting issue with 2023 on my workstation. Programs on workstation, shared data and programs on server. Server and SQL are 2019. I use Customization Directories to keep my modified forms and my clients' forms separate. Especially the PO…

I'm unable to HIDE the delete button in A/R receipt batch and A/R receipt entry screen using UI profiles. The method works with A/P and other screens. but, not with A/R. Any Advice would be appreciated. Thanks Nish

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…

Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement. mDBLinkCmpRW.OpenView("CS0120", out csQry); sSQL = "Select Name, Description from MYDB.dbo.Table"; csQry.RecordClear(); csQry.Browse(sSQL, true); …

Installed PU8 on server and now a macro with OCX dropped on userform1 does not work on the server where macro is being developed does weird stuff now like 1. no longer generates _OnRecordChange event 2. Set oHeader = AccpacOE1100UICtrl1.UIDSControls…

I know this is a very specific question and I may not get any replies. But I thought it was worth the ask. We are transiting our 401K fund to Charles Schwab. They have a quite extensive file spec for uploading payroll data in regards to 401K deductions…

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…

we have a client running Sage 300 Premium Edition Version 2020. Being an International Company, we have set their functional currency as USD and our Country Currency is KSH. Our Tax authority want all Invoices to be printed in KSH. For Kshs customers…