Sage 300

Hello, I am very new to development with Sage 300 and using the SDK -- in fact I have not started yet, but before I get started I would like to ask a question. First off, I need to clarify that I'm talking about a version of Sage 300 installed on a server…

I have a single user with an issue in a single company (all other users and all other companies for affected user are OK). The user opens the Vendor lookup and then users the search for a vendor - the subsequent search window with the expected list of…

Good Morning Sage Hub, Hopefully I'm posting my question under the correct area "general discussion", if not please forgive me. My company uses Sage 300 to do all transactions, have been using for around 12 years now, not many things I don't know how…

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…

We are encountering an issue when trying to Get ARCustomer Details using an Optional Field as a filter. We have tried using the following syntax CustomerOptionalFieldValues.OptionalField eq 'IDCARD' however we get the following error message …

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…

In sage 300 I can define the bank code: A/P -> A/P vendors --> Processing tab -->Bank Code However I couldn't find a way to set nor retrieve the bank account. Is there a way to do so in the application / via the RESTful API?

Hi All, In my table, there is value 3, 4, 5 in RECSTATUS column for BKTRANH table. But there is no entries for 3, 4, 5 in AOM. Can anyone help me on what is the RECSTATUS value for 3, 4, 5 in BKTRANH? Thanks.

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…

I would like to know how order entry staff can search for items in order entry by the manufacture's item number. Any suggestions? Thanks, Andrew.

Hello, I was trying to perform some oData filter on the ReceiptOptionalField2s collection but the return from Web APi is: statusCode: 400 { "error": { "code": "InvalidParameters", "message": { "lang": "en-US", "value": "The request parameters are…

I am trying to validate some data for our team and am stuck trying understand the data layout. My boss is using stonefield reports to generate a monthly sales report and he has 2 versions generating different #s. There seems to be confusion on what date…

Using the Search Finder to list all Vendors, the result gives only a short list of about eight Vendors out of 200. The Vendor list includes Vender codes starting with a numeric character only. I dumped the data and loaded into an off-site system.…

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

Hi, We need to know the quantity available for one location only. Is there an inquiry for that? Thanks, H

Anybody know any search report name or report ID feature in Sage Intelligence?

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…

I am just trying to get all detail of a vendor with the account numbers he was paid for.

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'm trying to create a query for a client to find items that haven't been used since a certain date (ICILOC.LASTUSED). They don't want to see items that were created recently and haven't been used yet (LASTUSED=0), but still show items that were created…

I'm calling the browse method and trying to find an order by number. This code takes around 4-5 minutes. Are these method really that slow? var view = OpenView("OE0520"); view.Browse("ORDNUMBER = 5555555555", true);

Hi All, I want to get only the specific invoice by DocumentNumber in Sage.CA.SBS.ERP.Sage300.AP.WebApi.Models.Invoice, but failed. I try to use the $Filter field => DocumentNumber eq 'IN00000000000000000031' but I just got error

Hi all, I want to get the username of current login user in macro. What Roto ID should I use?

Hi, I am doing customization to add multiple lines to GLJED. But I get multiple error that I cannot find out why it is happening, note that I only trying to add to GLJED, not GLJEH Below is my code. Instead of getting the record by Batch in GLBCTL…