Sage 300

Hello everyone, How can I configure email on SAGE 300 under the company profile to invoke the a clients outlook such that also the sent statements are stored on the sent folder in the clients Outlook? I'm using SAGE 300 2022.

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 …

Hi alll, I am trying to compile my module ID but having this error: makefile(19) : fatal error U1052: file 'ACCPAC.MAK' not found - Sage 300 SDK 70A is already installed and activated to few companies (I have ~15 companies, SDK is activated on…

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…

I'm unable to HIDE the delete button in A/R receipt batch and A/R receipt entry screen using UI profiles. The method works with A/P and other screens. but, not with A/R. Any Advice would be appreciated. Thanks Nish

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?

Currently trying to insert a AR invoice detail line by line transaction and the optional field is set as auto insert under the AR/Setup optional field. . Problem: Detail lines are inserted under the AR invoice without the optional field. Source code…

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…

Hi folks, I work for a foster care/adoption agency and we're trying to modify our child care cost sales invoice templates in Sage. Usually our invoices have the client listed as a county department of jobs and family services, and billed to the foster…

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…

HI, I have a .AVB file and I want to see the contents of this particular file. After a lot of research I came to know its a macro file and still I m new to sage so doesn't know how to open this file to view its contents. Any help is really appreciated…