x Want to participate? Join the group to interact

  • CS0120 data to accpac finder in COM API

    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); …

  • Fiscal Period for Specifik Module Macro

    I have some problem in macro the case was, i want to get 2022-01 (yyyy-mm) fiscal period status of my IC module in ACCPAC using macro Can anyone have some solution for this? thanks in advance

  • create view - only some allow SQL?

    I am using the .net interface, but am fully fluent in VBA. Does anyone know of a “rule” when creating a view, and then using browse for the view? I have this snip of code that works just fine: myview = dbLink.OpenView("CS0120") myview.Browse(…

  • Help testing/writing AccPacCOMAPI for a client (I'm in NY)

    Hi - I have a client that would like to export A/R data from Sage 300 (specifically the Aged Trial Balance report) and upload it to my server (we are a SaaS provider). They have nearly 100 "companies" in Sage that they would like to do this for, and doing…

*Community Hub is the new name for Sage City