Browse By Tags

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…

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.

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

Could someone please post a sample C# code for iterating the detail records ("OE0500") for a specific order? Stephen Smith has instructions to "Set detail key into the detail view." - but not sure how to interpret this. After composing my views, I…

Sage 300 2019 PU4 http://XXXXXXX/Sage300WebApi/v1.0/-/XXXXXX/AR/$metadata#ARPostedDocuments The above query returns 100 records only. Is there a way i can increase the threshold to 1,000 or remove the it completely?

Hi, I have create a new program using C# to be used inside Sage300 as a program. Currently to create a session, I hardcode the companyID for the parameter. However, the program is going to be used by multiple companies. Hence my question, how to pass…

Hi, I want to create a Business Intelligence Report by using Report Manager & Connector. In this report, I want to get rows from table APPYM of all Companies database. But first, I need to know which database is actually a company database for Sage…

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…