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…

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 …

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?

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…

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

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

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?

I was recently asked if there was a way that one could change the default sorting method for the selection of documents in an A/R Receipt Entry. It defaults to "Order By: PO Number" however, it was requested that I change this to default to "Order By…

Hi all, I would like to know if it is possible to filter by CustomerNumber in Invoice Model using $Filter I try to do as below but I am getting " The child type 'Invoice.CustomerNumber' in a cast was not an entity type. Casts can only be performed…

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?

Hello, We have an internal app to read the Sage tables to display invoice and order related data. There are times that the query returns empty result. but after a while, it works fine. I wonder if it is normal Sage behavior? Is it because a Sage user…

Below URL is my Request URL to fetch Active GL Details "localhost/.../GLAccounts? %24filter=Status%20eq%20'Inactive'&%24select=UnformattedAccount%2CStatus " Am getting following Error "erro r": { "co de" : "InvalidParameter s", "mess age ": {…

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…

We have a customer, still on Sage 300 2012, that also uses Sage Alerts and Workflows. They want an email message to go out each time Day End Processing is run. Has anyone set something like this up? I have set up plenty of alerts based on database queries…

Hello. We are trying to create a bridge between our custom rental management system and Sage 300. The goal is to push data from our system to Sage using SData to create invoices. Based on what we have read on Stephen Smith's blog and found on Sage Guru…

Hi Does anyone remember the software vendor that had a add-on program to net balances between customers who were also vendors? TIA Bill