Sage 300

%1 error when I try to edit or run macros in Order Entry in Windows Server 2012 R2 Terminal Server Trying out simple order entry macros Sage 300 ERP 2016 Windows 2012 R2 using Terminal Server

I have it showing up in a set of sample data when I try to work with a datasource using BK0001. RVSpy shows: [4fb0.7ff.43dc] BK0001: BKACCT [07:39:17.15].Read(view=0x10C6D314) [4fb0.7ff.43dc] BK0021: BKTNUM [07:39:17.15].Put(view=0x10C6755C, field=1…

I just discovered that CS0120 has a limitation on the length of a given field name. In my query I had two formulas and I gave them friendly names: select idcust, (select xxxxxxxx) as CurrentPaymentNumber, (select yyyyyyy) as Current PaymentDate from…

I have created a new database container and most of the field in the container are available for filtering, but a couple of them are not. I really need to use one of the fields to filter my report. Why are some field not allow to be used in the parameters…

How do I write a SQL query to select only today's date in OEINVH.invdate. I see that the invdate is not in a date format but in a decimal format.

Customer recently upgraded their Sage 300 1012 to 2014, and since then, our module that creates Sales Order stopped working, with error message "Error Code: 2147467259 - Automation Error - Unspecified Error". This module that we built works fine with…

What view and field can I retrieve an A/R customer balance from?

I am trying to pull data out of an ACCPAC SQL Database and I cannot find a way to link the GL tables to the purchase order module (Invoices). Can someone tell me what the relevant fields are? The client is on version 5.6A. Thank you.