• Weird errors when creating a shipment

    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…
  • Custom Macro Development

    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…
  • Inquiry or Report

    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…
  • 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); …
  • 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…
  • 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. Rob
  • 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…
  • 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…
  • 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…
  • 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 , "PriceList":"WHS"}], "ShipmentNumber": "CASH0003…
  • 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…
  • 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 a day…
  • 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

    FormerMember
    FormerMember
    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…
  • 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 '<' but same…
  • Sage 300 Web Screen Inquiry

    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…
  • amount of payroll detail in job cost

    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…
  • Sage 300 web api not uploading data

    FormerMember
    FormerMember
    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 DBLink.OpenView "CS0120…
  • 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; " & _ "UPDATE OWID SET LASTVALUE…
  • 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.