• Inquiry or Report


    I'm fairly new to Sage and I'm hoping someone can help me.  I am trying to build either a custom report or inquiry,  I need to be able to access the JC-Job and JC-Transactions index's and I'm not sure how to do it.  It needs to be…

  • 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.Browse(sSQL, true);

  • Inventory transfer macro is failing when negative levels allowed

    I have a client who needs to run their inventory with negative levels allowed. We are running Sage 300 2021 with update 2

    I recorded a macro of doing an inventory transfer from location 1 to 2 with a qty=5.

    Location 1 had zero of these items and so it…

  • Payment Processing

    How to I store preauthorization information into Sage that I have gotten from an external tool? I see that tables like YPTRAN and OEPAUTH get populated but I can't get the macro record to show me how it is done.

  • basic macro question

    I'm trying to add 2 new optional fields to about 4000 standing orders, because Sage does not auto-insert opt fields when activating from a Standing Order.  I have a macro that works for one, or when I "mailmerge" to repeat the code for a certain number…

  • Order/Purchase Order Detail Records

    How does I get the detail record of an order or purchase order if I only have the item number? Item Number is not a Key field.


  • how to go to a line in a PO

    I know in OE  can do something like     OEdet1.gotorecordnumber 3      for example to go to 3rd line in grid

    but when I try this in PODET1 view  (POPORL) I get an automation error

    i can podet1.gotop  and podet1.gonext and browse all the details

    how do i go to the…

  • How to do data filtering in macro VBA?

    Hi all,

    how do I do data filtering in macro? Lets say I want to filter by invoice number in OE0520

  • Indicator for a successful and failed insert in Order Entry

    Hi all,

    I am making a macro program to insert OE transactions in bulk by reading a csv file with a lot of Order transaction.

    Some of the Order might have error while trying to insert. So, I need an indicator that this specific transaction failed or successfully…

  • Error on using ACCPAC libraries for custom 3rd Party Application

    Hi all, 

    I am developing an app using ACCPAC libraries:

    I have difficulty to do an Order Entry from my application, especially on setting the value of CUSTOMER (OE0520) and ITEM(OE0500), to do RecordCreate(ACCPAC.Advantage.ViewRecordCreate.Insert) fu…

  • API: OE with Ship all and Post Invoice

    Hi all,

    I try to add new Order Entry with ship all & auto create invoice using API with the following json

    {"CustomerNumber":"2347", "OrderDetails":[{"LineNumber":0, "Item":"A11030", "QuantityOrdered":10 ,

  • Remove Generated Code from Solution.

    Hi All, 

    is there any automatic way to remove code generated by Code Generation Wizard? 

    Thank you.

  • What is LINENUM

    Hi All,

    what is LINENUM? In OEORDD, Initially I though of it as the line number of the items in an Order Entry. So I was expecting the value would be LINENUM=1,2,3 and so on.

    But the value is 32, 64, 96, in so on in increment of 32. So what is it exactly…

  • REST API Question - using the GET ARReceiptAndAdjustmentBatches and APPaymentAndAdjustmentBatches calls

    I have developed a 'payment' process that calls Sage 300 API APPaymentAndAdjustmentBatches for vendor payments and ARReceiptAndAdjustmentBatches for customer payments. I'm currently running these processes (one for each API call) multiple times…

  • Need Inquiry help for Payroll State Tax Problem

    Does any have a Payroll tax inquiry already made at the level of each state tax type, per Quarter for current fiscal year? Yesterday we found out that Sage PR was not calculating taxes correctly and we need to make adjustment, but I can't find correct…

  • FRPOST Help

    Hi All,

    I am fairly new to using the Sage FR module and I have 2 quick questions regarding FRPOST.

    1. I have been able to use =FRPOST("TRANSAMT","","(JRNLDATE = 20190909)") to retrieve the daily amounts no problem but on days where there is nothing posted…

  • Global Software Alerts 5.1 on Windows 2016

    I am upgrading servers from 2008 to 2016 and my inventory alert is not working on Windows 2016 server installation. All other  alerts are imported from 2008 server and working fine . I am receiving fallowing error :

     Incorrect syntax near '<'…

  • Sage 300 Web Screen Inquiry


    In older version I remember there is a possibility for us to custom and add more inquiry into the web screen. Now in 2019 is this features is still available? That we can add more data to be part of the standard Inquiry which is available. If yes…

  • amount of payroll detail in job cost


    In Job Cost my payroll posts a line and cost per category.  How can I get it to post one line of data per Cost Code? I still want to see the units, but the total of the wage and burden can be combined to one line of data.  I can not figure out what…

  • Sage 300 web api not uploading data

    I can do GET operations, but attempts to do POST appear to have the data ( curl -d element) stripped or munged by the time they get to the Sage engine.  If I do ARInvoiceBatches, for instance, it will create an empty Batch with no batch data and no attached…

  • CS0120 - reusing the view.

    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


  • Using the CS0120 superview to execute a SQL transaction

    If I use a transaction that has two statements in it, only the first statement executes
    In the example below only the UPDATE statement executes and I am not able to retrieve the result

    csUpdateW.Browse "BEGIN TRANSACTION; " & _

  • CS0120 view to update DB

    Is it possible to use the CS0120 view to execute a SQL update query? 

    I'm looking to update the print status field. Just wondering if I can use the CS0120 view or if I have to use ADO. 

  • Sage 300 ERP 2016 %1 error when I try to edit or run macros in Order Entry in Windows Server 2012 R2 Terminal Server

    %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

  • Does anyone know what application YC is?

    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…