Sage 300

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…

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…

I have a customer that we recently upgraded from CRM 7.2 and Sage 300 v2014 to CRM v2022 and Sage 300 v2022. In their old system they had and auto-assign customer number when they promoted a company in CRM. Clearly a custom process. I need to set this…

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…

i am reviewing the Sage 300 web API and looking for a means of updating a AP payment batch (eg. removing a cheque from the batch, updating cheque dates, removing invoices,etc...) and all I can see thus far is GET and POST for APPaymentAndAdjustmentBatches…

I built two macros that create IC adjustments for a certain class of items for a client. Works fine on the system in my office. I coped the two macros onto the clients server and when i go to edit either macro I'm getting an 'Out of Memory' error. …

Is there any way to reverse the I/C Options Allow Fractional Quantities? it is currently ticked on and greyed out, not allowing change.

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

Hi All, In my table, there is value 3, 4, 5 in RECSTATUS column for BKTRANH table. But there is no entries for 3, 4, 5 in AOM. Can anyone help me on what is the RECSTATUS value for 3, 4, 5 in BKTRANH? Thanks.

I have a client who recently upgraded from Sage 300 v2012 and CRM 7.2 to Sage 300 v2022 PU3 and CRM 2022 R2. On the old system, when they created a Quote in CRM (Sage 300 quote) the Quote Number was automatically assigned the opportunity ID. I assume…

I think I know the answer to this but is there any way to expand the field length for a field in Sage? We have customers with email addresses that are longer than 50 characters. Is there a 3rd party product that will handle this? Sage 300 2021

i was interested in trying to get the cancelled cheques reconciled through automation. after trying to record a macros while trying to clearing some cheques, all i see is the connection created to the COMAPI for the company link. shouldn't it create or…

Client tracks medical supplies with Lots and expiration dates, which are stocked in bins using Orchid Bin Tracking. They would like to add a few alerts and or processes; for example, when product has X days left before expiration, put it on Quarantine…

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.…

Back on the custom OE Screen. Here is what I need to do. Currently the 'Post' button is hidden for certain users and exposed for others so they can post orders and quotes. When the 'Order' is a 'Quote' ALL the users should have the 'Post' button available…

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…