Sage 300

Hi Team I have extracted the data from Sage 300 source system using the below source tables. OEORDD -> SalesOrderDetails OEORDH -> SalesOrders ARIBD -> InvoiceDetails ARIBH -> Invoices But we have the data until 2016 and the data in these tables…

Hi All, After Uninstall and re-install SAGE 300 on windows 11 now very time I try to print anything this erro shows: "Sage 300: Error: -2147467259 Class not registered." I did try: run regacc.exe - as administrator, Remove and re-add Net framework…

debug to line : FieldsOEHeader.FieldByName["CUSTOMER"].set_Value(); is error Error HRESULT E_FAIL has been returned from a call to a COM component. help me, please

Sage300 v6.2, Customer use v6.2 over 8 years ago. This message is the first time. Customer shipped Item with Lot in a Order Entry > Sales Order. Then, Customer want to clear shipment in Shipment Entry(before Invoice). There is 1 item with 2 lot…

Brand new install of Sage 300 2024 and PU1 on 2019 Server and 2019 SQL Server - not new workstations. Always have problems with the same 2 out of 6 workstations (all within 1-4yo) when it comes to Sage 300 workstation installs. I'm putting this out here…

when i try to logging via http locally, any help please

Where can I find the time an order was created? I can only seem to find the day in the ORDDATE field in the OEORDH table. Does Sage store this somewhere in the database tables? Thank you

When making changes to a production system such as updating SQL passwords, changing SQL servers, or using a different SQL account, how do we get to the edit screen for the Vault and Store databases configurations? Alternatively, is there a way to make…

Hi all, I keep on encountering the error below while trying to do my database setup on Sage 7.0 Can anyone help with this please? Thank you.

Team, I need your help. I would like to use the following request to receive payment: {{BASE_URL}}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARReceiptAndAdjustmentBatches?$expand=ReceiptsAdjustments($filter=DocumentNumber eq 'PY00000000000000000133') But Sage 300…

Hello all, I've come across an issue that I can't seem to find a solution for. My PC at home is Windows 11, all drivers and OS is fully updated. Even have a 64bit adobe reader installed as per another post similar to this. I'm a student, using cloudpaging…

Hello Sage Community, I am currently working on an integration project to post transactions into my Sage 300 ERP database via an API. While posting transactions directly from the Sage 300 ERP interface to the GL as a journal entry, everything works correctly…

Hi Sage City community, I am currently working with Sage 300 ERP 2023 and trying to access general ledger account balances programmatically. I need to retrieve this data for a custom integration that I am doing. Could anyone guide me on which specific…

I have active companies on this version, but I want to activate new company profile. I got an error The user Input E-mail Password cannot be blank.

Is it possible to import updated unit price in order details using excel file, I import data using excel but unit price can't be updated , it automatically pick the price from the finder.

Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS

Hi We are getting more inquiries about setting up multiple outgoing email accounts per document type. Eg Email order confirmations from [email protected] Email invoices and statements from [email protected] Just wondering if…

I cannot find the Tables names and field description for the Manufacturing module in Sage300. Anyone knows where to get it Something similar to this Thanks

We are adding a large number of new products to our Inventory Master list which requires new part numbers, adding each part to the Pricing list, entering the quantities for each part and its location. What is the most efficient method to add this information…

Ever since 2019 version of Sage 300 ERP I have to run application servers on Windows 2016 because Sage is running much slower on Windows 2019, plus we experiencing frequent application hang in 2019. Did anybody else noticed same thing? For example it…

I am getting the following error when trying to run any government report: The procedure entry point ?selectNodes@CAXMLNode@@QAE?$shared-ptr@VXCAMLNodeList@@std@@PBD_N@Z could not be located in the dynamic link library d:\Sage Accpac\Taxfiling\aatrixforms…

After upgrading sage from 2021 to 2023 I got error Error HRESULT E_FAIL has been returned from a call to a COM component on accessing web screen. What would be the reason of this and solution ?

Hi, i am experiencing error 40960 when i tried to login into sage 300 database on 3 separate workstations while other two workstations connected successfully. I have checked the DSN, redirected it and ensure everything is right BUT the issue still persist…

Am trying to send post request to sage API concurrently where by many requests are sent at once. I got an error 'Record Conflict {en-us I/C Options. Record has been modified by another program' and debug .Net debug pop up Everything work fine…

I am trying to validate some data for our team and am stuck trying understand the data layout. My boss is using stonefield reports to generate a monthly sales report and he has 2 versions generating different #s. There seems to be confusion on what date…