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…
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…
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 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
Hey Everyone,
I'm sure this was answered in the past but I can't find the post, maybe someone can help me out. I have Sage 50 2015 Canadian edition, I imported over 16,000 items (yes, 16,000) as we are moving from DacEasy 9.0 to Sage. All my items are…
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…
Hello,
Is there a way to import Vendor Price lists from excel so that the prices are updated for existing products and so that new products are added into inventory?
Thanks,
Dave
Hello All,
We are currently experiencing a bottleneck where our yearly/bi-yearly pricing increase from our 700+ vendors are not being updated in our inventory system effectively. It seems like a very manual process where we receive pricing increase…