• How to filter OptionalFields collection via Sage 300 WebAPI

    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…
  • Vendor Search Finder issue

    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.…
  • Charles Schwab 401K export file

    I know this is a very specific question and I may not get any replies. But I thought it was worth the ask. We are transiting our 401K fund to Charles Schwab. They have a quite extensive file spec for uploading payroll data in regards to 401K deductions…
  • Description: Error occurred when activating Sage 300 Data Source.

    I have a program that was written a while back. Specifically it uses the AP Invoice Entry screen and does some things in the background when they enter an invoice. All is well unless they close the screen, re-open the screen, and then they navigate to…
  • [Sage 300] I cannot add optional fields.

    Hello Team, I cannot add the optional field for A/R Documents. Previously, I used the button Create New Example: But in Sage 300 2022 the button is absent. Example: Could you clarify on how to add the button 'Create New' optional field?
  • Functional Currency and Home Currency

    we have a client running Sage 300 Premium Edition Version 2020. Being an International Company, we have set their functional currency as USD and our Country Currency is KSH. Our Tax authority want all Invoices to be printed in KSH. For Kshs customers…
  • Extending GL Account Groups

    I am aware that the Account Groups , particularly with the latest version of Sage 300 ends at Group 26 and the Group Category Codes ends with 210. My question is whether it's possible to extend and create new Group Category Codes beyond what the system…
  • Sage 300 Windows 2020 SDK Development

    Hello, I am new to Sage SDK development ,I am creating add-on in Sage 300 windows 2020 by using SDK.So I want know number of views we can created in add-on .I also want to know how to generate unique key (both long,Integer and string type)? How to compose…
  • Locations Inquiry

    Hi, We need to know the quantity available for one location only. Is there an inquiry for that? Thanks, H
  • T4 Date range is wrong, not pulling Jan - Dec

    Hello, Our T4's pull employee income from our fiscal calendar date range instead of the require T4 date range of Jan - Dec. How do I edit the dates it is using to pulling it? I can't seem to find anything. The only option I have when printing t4's…
  • Increasing the Size for G/L Account Description to 120 Characters

    My client is running Sage 300 Premium Edition Version 2020. They want the G/L Account Description field to be increased to 120 Characters. Is there an available utility for doing this? How can I achieve it in the easiest way possible? All responces…
  • Proforma AR invoice

    Hi, Is there a proforma invoice in AR? Thanks! Helen
  • Sage 300 and AutoSimply Barcode application very slow

    Hello fellow Sage 300 users and IT Admins, We are using Sage 300 2022 and we use AutoSimply Barcode application along with our Sage 300. We currently are on the latest PU for Sage 300 2022 and we even have the latest customized AutoSimply Barcode 2022…
  • How Can I insert a company logo in an email body sent from Sage?

    We are emailing RFI's, Submittals, etc... out of Sage. Is there a way to autopopulate a signature into the body of an email sent from Sage? Or do we have type our name and contact info into the message block?
  • Some Characters are visible

    Good morning, Some characters are not fully display in AP module. For example, I can only see some numbers in check number.. Could some help me please.. See picture attached.
  • Speed of the Browse Filters

    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);
  • Sage 300 Web API: How to filter item by field in Sage.CA.SBS.ERP.Sage300.AP.WebApi.Models.Invoice?

    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
  • Chart of Accounts in Web Screens

    I cannot seem to find the "Chart of Accounts" screen in web screens. Is this not available or am I missing something? Thanks, Ubaidullah Nubar.
  • How to get username programmatically in macro

    Hi all, I want to get the username of current login user in macro. What Roto ID should I use?
  • Custom macro to do AR Receipt Entry: can I bypass ARPOOP and insert directly to ARTCR?

    Hi all, I am making an AR Receipt Entry import to import the receipt in bulk from an excel file. I follow the recorded macro to create it. And I see that the ARPOOP (in recorded macro is using ARRECMAC1detail4) set the APPLY value to "Y" on line 124…
  • Import Optional fields using Interop SDK for AR

    Hi, Can any one help on this optional field in .Net API Problem: Optional field can't be inserted. Only the tick mark can be viewed in AR invoice entry UI screen Source code: ARINVOICE1detail4.RecordClear(); ARINVOICE1detail4.RecordCreate(ViewRecordCreate…
  • How to see the payment (receipt) exchange rate on UI?

    Hello Team, Could you clarify how to see the payment (receipt) exchange rate on UI? I opened a payment, but I cannot find it.
  • BUDGET ON OPTIONAL FIELDS

    As per my understanding Sage 300 budget linked to Account code (on GL). How can I handle objective based budget? Objectives are like optional fields: Eg: Acccount 1010 : Allowances Objective 1: budget $100k Objective 2: budget $200k
  • Notes and attachments

    Hello, Any recommendations for this add on other than Orchid? Ty.
  • 2014 sage 300 advanced - kit items do not print component qty's on pick list

    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…