Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I have modified the Packing LIst to show a total of items being shipped per page. On my system everything works fine. It prints 8 lines per page and shows the page totals very nicely. On my clients computer it only prints 7 lines per page, but the page…
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);
…
Up until now I've been setting my CS0120 variable to Nothing and then opening it up again like this:
Dim qry as AccpacComapi.AccpacView
DBLink.OpenView "CS0120", qry
qry.browse "UPDATE sometable ... blah"
set qry = nothing
DBLink.OpenView "CS0120…
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…