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…
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…
I am using Dell Boomi software to retrieve data from our customers Sage Pervasive DB.
In order to do that, Boomi needs class name and connection url. It uses java and jdbc to connect to db.
Class name is: com.pervasive.jdbc.v2.Driver.
URL is in…
Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging.
Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…
Does anyone have any comprehensive form of databse schema or detailed data dictionary for Sage 300 CRE when trying to access using ODBC? I have been trying to find one for some time that details the table locations of data fields and have found Sage documentation…
I'm wanting to add about 600 items to an already existing list of products in our datasbase.
So, I exported 3 lists:
I opened I/C “Items”. I created a script that would contain all the columns we use in that first tab (of the Items Module), and the…