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
Hello,
i've database file. i need to load data in my sage cre 300.
I've installed sage cre 300 in my local machine but not found database dump and database load application.
Could you guys help here how to connect with this database?
Thanks, …
A customer has a third party quoting and bidding software running with SQL Express. They want to move it into the same instance in standard SQL as Sage300 to allow more memory availability. Any issue with this or would a separate instance in standard…
Upgrading from 2019 to 2022 and for that purpose deploying new virtual server. Server is running Windows 2019 and SQL is running on a separate machine. I am able to convert data but when trying to run SAGE receiving error in OE and IC. PO seems to be…
Hello,
Could some one please advise where the description would be stored on the sql server please ? Which table would it be under as I am not able to find it. Thank you - Shashank
Hi,
I am new to Sage100 and customer is using Sage100 advanced which comes with ProvideX ODBC driver which only allows to read data from Sage100.
I did some research on the functionality to write back the data in Sage100 but was not able to find any…
I am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…
As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…
link SO to WT .docx
I'm trying to find a file that contains the quantity on WorkTicket shown on the Sales Order line if exploded. see attached word doc for screen shot.
The SO detail file contains the work ticket number and the item number but not…
We are working with a company using Sage 300 on a Pervasive SQL database.
They are interested in exporting data such as GL, AR, and AP transactions and other table information, such as accounts, customers, and vendors.
I'd like to know if there are…
the following error message appeared unprovoked today:
firebird database error
cannot attach to password database
class: EIBNativeException
code: 335544653
i can't even open the database. the minute i double click the icon, the error appears…
Hello All,
We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty.
SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts
In the below example, in main I m seeing a open PO qty but in…
Hello,
Currently, I created a C# project for getting Purchase Order, Sales Order values in sage 100, and used PO_PurchaseOrder_bus, SO_SalesOrder_bus business object interface to get these values.
shall I use the same business object interface to…
We run SAGE 100, and recently I purchased BizNet 5, but I also have BizNet 7 datasets - A/R, A/P and IM.
The BizNet tool works well when I am pulling general ledger information, but for our inventory, accounts receivable and accounts payable there…
Please I cannot start my Simply Accounting Set up.
It keep telling me cannot connect to Connection Manager.
What should I do.
Will Need an URGENT ASSISTANCE
Hello,
I'm working on a project and I need to be able to pull the same information the "Invoice History Printing" report pulls for a date. For my selected date, in our database we have about 3,000 invoices. The report, however, only pulls about 140…
Has anyone had experience with archiving the PO module? According to KB articles, moving POs and COs to history is the first step in improving performance in the PO module. Clean out all those old records. I have done this in a test environment and can…
can any one help i had to update my sage accounts 50 because i moved my computer and all of a sudden the sage couldnt recognise the computer.
so i was advised to cahnge and upgrade to v25 of which once i had done that my main computer worked. what i…
For some reporting purposes I need to normalize the bill of materials exactly how it shows in the BM_SummarizedReportWRK report into a SQL table. How do I do this? I've been attempting to backwards engineer from the regular and accessible Bill Of Materials…
Hello,
I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table.
When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…
Hi,
I am working with a client using Sage 300 version 9.5(?). When I open PCC I am unable to see the PRM tables. After some research I think that the reason the PRM tables (among others) do not show up is because the DDF files do not contain the schema…
