Sage 300

Hello,

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…

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

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…

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.

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…

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.

Rob

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…

Hi all,

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

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…

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…

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 ,
"PriceList"…

Hi All, 

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

Thank you.

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…

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…

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…

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…

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

Hi,

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…

Hello,

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…

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…

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…

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; " & _
  "UPDATE OWID…

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. 

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