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…
Is there a way to upload an Inventory List into Sage 50? I have around 70 items that would be a million times easier to upload once, in lieu of keying them in individually.
I have searched the Sage Knowledge Database, but cannot find any articles…
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…
My file sizes are past the quantum limits and I’m starting to get errors, so I’m exploring options. I’m at 300kb quantum recommends 250 max database size
1 Will the Quantum database sizes be expanded anytime soon? Maybe an enhanced version of Quantum…
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…
Here is the field description for the "unit cost" field: Numeric (Real) - Unit cost for the line of distribution; it gets ignored for negative inventory adjustments, but gets used for positive inventory adjustments. ( Note: If this field is not included…
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 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…
Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…
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
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…
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…
