Sage 300

Hello, Any recommendations for this add on other than Orchid? Ty.

Hello, I would like to know if there is a way to have component quantities print on a pick list for a kit. is this a form modification or is there another modification that needs to be completed? I am able to see the component list which is part of what…

Hi, Can I have optional fields in ITEMS set as required only in certain scenarios, such as an item category? We dont need all optional fields for all types of items but when we do need it I want to require it. Whats the best way to set that up?…

Hi everyone, I am new to PJC. Can I please have a Contact Maintenance import template, i am failing to make one for Materials (Items) Regards

Sage300 - Functionality that allows for the electronic signing of purchase orders

Hi all, I would like to know if it is possible to create my own WEB API to get/post data with "GET/POST" method. I am trying to do something like this: - create a new table with roto ID using Orchid Extender - create my own API using Sage Web SDK…

Dear Experts, I wanted to check what is the best workaround for overcoming the 60 Character limitation for Optional fields? is there a way we can alter directly the table and add a field to load the full length description of the Item and using some trigger…

I am trying to update the order detail lines, specifically setting the "PickingSlipPrinted" flag to true, what would be the minimum data I need to send to the service? I've tried the below, but, it just keeps returning that certain fields cannot be…

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…

Hi all, I want to make the email field in AR Customer unique, means only 1 email for 1 customer only. How can I do that? I assume I just set the email to be unique in database level, is there any implication to expect? Thank you

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…

Hi SageCity, which framework can I use to have the same user interface as Sage 300, Border Size, Title bar color Example Sage Interface : My Interface :

Our customized Visual Process Flows cannot be opened after applying Sage 300 2021 PU1. Also, available Sage templates cannot be edited after applying PU1. When you right click on them and click Edit, nothing happens. Can anyone help me to solve this?

How easily can a budget from excel be uploaded into Sage? And what is an easy template to build the budget?

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?

I'm trying to run the HRMS and Sage Link Automatically by setting it up in the Schedule Profile Configuration and Schedule User Login Configuration under Sage Payroll Link- Sage HRMS Setup. I'm following the steps provided to me in the user guide (attached…

Is it possible to have a statement of account for a specific range of date including payments? When we are trying to do so it either shows all transactions since the customer was opened or not showing anything if I specify a date... Thank you

I am looking to maintain my price lists. Currently I have inherited 150 old ones. I want to delete them. How do I do it? I am also looking at importing new price lists? Is there a template. Is there a way to update base price changes and add new items…

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 are using Sage Payments with our Sage 300. We'd like to change the Card ID on the Credit Cards tab in AR Customers for a specific customer. We will just be appending zeros to the existing number. I see that IDCARD exists in OEORDH1, YPPMTINF and…

Hi All, I am practicing to add custom fields on Order Entry - Shipment Entry Screen. I have followed tutorial in Sage300-SDK-web-2019\docs\customization\Sage300SDK_WebScreenOrderEntryCustomizationTutorial.docx, except the I change the screen to Shipment…

Using only the Sage 300 APIs which API call can I use to retrieve 'reversed' transactions? (Bank Reversals) In Sage I can see the reversals with a transaction type of 'Returned' on the AR Customer Inquery page but when I try retrieving the transactions…

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…

Does web UI has a similar function as "F9" (to make one line (detail) to one screen, like PO or OE)?

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.