Hi All,
Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script.
I right clicked on the…
Project and Job Costing (Job related) PO Receipts getting the error "Damaged data. Receipt. Table PORCPH1 not found.". All other PO receipts have no issues. Please help us to solve this issue. Our Version is Sage 300 ERP 2019 and Database is Sql server…
Hi,
I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error - Could…
In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM"
What is this?
I write reports, and get client databases to work in. This is the first time…
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…
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…
Sage 100 Version 5.20
Crystal 2011 for Sage
Window server 2012 R2
Ok, here is an odd one. We had been having incorrect data running a Inventory List via Crystal. We have a total of 600 items. When I add a filter for Category 2 data I am getting…
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?
We using Sage 300ERP V.6.0 PU2. The error message when day end is show "Transaction History. Database error (Operatin=INSERT) (Error=824). Please advise, what happen and how we can solve this problem.
Hello!
Our legacy data includes special characters and odd formatting for part numbers that I guess we made up along the way and I want to standardise them.
Is there a way to wholesale change part numbers where, for example:
export part numbers…
Timeslips 2012
When using transport.xfr I get the following error message. I tried a DATA VERIFICATION on both machines and have NO errors. I can exchange clients and professionals but NOT tasks or expenses - tried each separately.
Any help would…
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…
I'm an admin for a law office and we use Timeslips 2008 for our billing. Only yesterday, when I went to edit a slip, I received the following error:
"Directory in use by earlier version of Paradox.(13314)
Area: Database
Code: 4
Address: Exception…