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
Hi all,
I am able to promote company as admin. However, my user unable to promote company to Sage 300 Customer/Vendor, stating that the Customer code already exists in Sage 300 Company, but the customer code does not exist yet.
My user setting:
…
Hi all,
My customer is having error while installing the Workstation setup on Sage 300.
Checking the log file, a lot of things cannot be found. how do I fix this?
The following properties have been set:
Property: [AdminUser] = true {boolean…
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,
Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank.
Could someone share…
We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…
A data dump was made and restored on Sage 300 ERP. At the point of opening sage the below error message were gotten with the list of modules which are already installed.
sage 300 has detected module update inconsistencies that requires activation. The…
We are implementing Sage 300 ERP on premises. Due to current situation, implementation taking longer than planned. The simple question is, how can we migrate current FY data back to January from our legacy Peachtree Quantum system to sage 300?
Comments…
Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, kindly advise me
ANY BODY HERE TO HELP OUT MY…
Hello,
Is there any method/setting, that can ‘Restrict’ certain Customers (with specific Group code) that are created within Sage 300 from getting into CRM as company record?
I know that if we tick the suspend A/R integration to CRM checkbox from…
Deductions for 1/1/2020 - How will you make a mass update to HRMS if you haven't been tracking deductions in HRMS?
We have HRMS and Timberline. We use a 3rd party for Benefits Open Enrollment and monthly maintenance and enrollment.
Every year we have…
Dear All,
I am unable to do multi select option in all the list box fields in sage crm, this is happened only after installting the sage 300 2019 integration setup. Sage CRM ver 2018 R3.
Please refer to the bleow url which is from sage CRM Community…
I'm sending adjustments to Sage 300 ERP Server for 'posted' invoices and I know that the transaction are successful because the webapi call returns a reponse code is 201 and the response message contains the information I sent but when I open the adjustment…
I have a challenge...can someone familiar with the Sage 300 database tables give me some advice?
I would like to query the database to find out if a certain document date correponds with a fiscal period that is currently locked for Accounts Payable…
Hi,
A little background... We were asked by a client to create a.Net application to do a few things. The more effort we put in the less success we seem to be having.
We are trying to create POs, Time records, and add Cost Codes to the DB.
Reading…
Hi All,
I have performed an OE import successfully in most of the cases. However, I have encountered the captioned error for some items at zero stock level at the moment which could be imported as OE successfully for one OE, but not the others at different…
Hi,
I'm trying to work through the C# sample project in the Sage 50 Accounting SDK (Simply) but for some reason I can't get the opendatabase connection to let me access the database. I have set up my user in the Sage app and I know my username and password…
We have noticed that the CompanyID field in the GLJED table does not tie up with the actual company AUDTORG field.
The bulk of the record have the correct company ID, however many have either blanks or random company ID's
I have checked this at several…
We running SAGE 300 ERP and we have a problem with Qty in Bin Location not matching IC Qty.
How do I get SAGE to automatically sync the Bin and IC Qty?
Doing each transaction manually takes way to long.
Thanks
Hi,
We ran the Data Integrity Check and we have the following error message:"E: Database XXDAT uses an application CS that is not installed.
1 Error found in Administrative Services.
Any ideas?
I'm working on extracting data from the database sage 50 CA, but in the documentation containing the data definition , I have not found the relationship of the payment terms with customers, or where it is stored ( table).
Here is the information that…