Sage 300

I had a customer that wanted to email out invoice in Sage 300 but before she selected the range of invoices, she selected delivery method of customer and clicked print. OOOHHH NNNOOO!! Panic!!. over 4000 invoices were going to either be printed or emailed…

Good day community, I am trying to retrieve a bank reconciliation report as of November 31, 2023. I am in January 2024 and I am unable to go back to that specific date (November 31, 2023) Is there an alternative way to retrieve this report? My error…

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…

Does anyone have a month-end procedure that they follow in Sage 300? Reconciling accounts payable to the balance sheet, etc? I'm looking for something to have everyone follow to ensure that everything is entered correctly.

We restored a backup of one of our companies to test and now when we enter sage login info it just crashes with no error. Other companies work so it has to be the database but it is the same as in production. I change the database setup to go straight…

Hi Team, Could you provide the endpoint to receive multiple contacts via API from Sage 300? I used this documentation https://cdn.na.sage.com/docs/en/customer/300erp/2017/open/Sage300_WebAPI_EndpointReference.pdf and didn't find the endpoint.

Hello, we built a web Point of sales app and we want to integrate some api from sage300 (sales api, inventory, customer info api). we only want some of our api to integrate with sage300. please how do i start ?

Hi All, I posted an AR Refund Entry that is using Cash Payment, No Bank Code, use Cash Account instead. It does not have a Bank Code so I cannot use the Reverse Transaction from Bank Transaction. Any other way to reverse this refund? Thank …

Hi everyone, I started using an AP automotation software by Beanworks which is tied to our Sage 300 system. When I view our tax authorities within the Beanworks environment, it shows some tax authorities as inactive but when I go to the tax authorities…

Hi everyone, Does anyone know a solution to this error when running G/L Financial Reporter to Print Financial Statements? We are using Sage 300 2022 and 32-bit MS Office 2019 Pro Plus on 64-bit Windows 10 Pro. I've enabled all macros and did a repair…

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…

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

Am trying to import misc payment in AP Payment batch but all misc payment amount is duplicated Am using Sage 300 Standard 2020 PU 5

Hi, a customer is using Sage 300 Premium 2016 and they were wondering if it is possible to modify a behavior for AP batch upload. Currently when they upload a batch CSV if there is a problem with a particular AP invoice entry the upload will error out…

Hi, I am new to Sage. I am making orders on Sage300 using REST Api. I have created customer on Sage using the API successfully I am using C# for integration I am unable to create order on Sage. The API returns Internal Server Error. I have check…

I am producing steel pipe (item 2) from a coil of steel (item 1). for example an 8000 kg steel coil produces 1200 - 6 foot pipes and 34 kgs of waste steel. How do I deal with the scrap steel?

Hi all. With American tariffs changing a lot recently, and therefore being volatile and different between types of products, we are looking for a way to add customs duties as additional costs based on each of the individual duty/tariff rates for each…

What is the correct method of permanently removing a company from Sage 300? I found the "Database Setup" utility, where it appears I could delete the two databases (data and system) associated with the company. Is that the "right" way? If yes, does…

Looking for someone who knows their SQL tables here. What is the SQL table or view where I can query the Sage 300 ERP "Type" field as it relates to the CRM person record? Through the integration, the new fields "Sage 300 ERP A/R Contact" or "Sage 300…

Hi All, I am brand new in Sage 300 world. Even I don't have enough experience in operating and implementing ERP systems. However no one became expert from his mother's womb. Therefore I want to learn and here are some stupid's questions. If anyone clarify…