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…
How does one access Business Vision files from earlier years?
The program does not seem to follow Windows convention that clicking on the word File on the upper ribbon does not give an option to locate and load a file.
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
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…
What is the procedure to accurately import to Sage 50 new pricing on inventory items through an Excel spreadsheet? Specifically I am having difficulty in locating the file to import from, does it need to be saved as a certain type of file?
Hello,
I am still having an issue with imported product item numbers being skipped. I do not know what could be causing this as I have successfully imported 250,000+ items with the same number scenarios. Has anyone else had this issue and if so, how…
