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 am trying to create a shipment in Sage v6.0. I did a recording first and feel like I have replicated in C#. the issue is that I get an error when trying to update the shipment detail after I add the lot numbers to an item.
shipments.Init();
shipmentFields…
Hi,
Does anyone know who can create macro to import autosimply MF Issuance and MF Assembly Receipt?
We have a different system to control manufacturing and I need to import this automatically and periodically (so ideally we need .exe file to execute…
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 similar to a…
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);
…
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…
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…
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…
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…
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…
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":"WHS"}], "ShipmentNumber": "CASH0003…
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…
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 a day…
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…
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 '<' but same…
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…
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.OpenView "CS0120…
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 SET LASTVALUE…
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.