Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Hello,
I've used VI jobs for various import and export jobs to import things from sales order info to bill structure. I dont use a lot of conditional based columns.
What im trying to do is have the ShipExpireDate be 5 business days added to the order…
Hello,
We are wanting to further specify Quote orders as 'New', 'Converted', or 'Expired'.
Is it possible to add an entry to the 'Order Status' drop down in sales order entry? I'm assuming I will need to do some script/UI customizations to complete…
After Job Cost was updated to the Business Objects Interface Sage confirms but has not corrected two major problems (for us). When Sales Order is integrated with Job Cost there is the ability to create a new job from Sales Order Entry. When entering the…
Where does the QuantityOnHand value come from in the SO_OpenOrderWrk file? The field value is always zero when I try to use it in an Open Order Report. I would like to pull the QuantityOnHand from the IM_ItemWarehouse file based upon the WarehouseCode…
Hello,
I am trying to come up with a counter for the number of orders (Standard or Backorders) that an item is on. So far I have tried a script that counts the line inside of SO_SalesOrderDetail but it won't write to the two UDFs made in CI_ITEM. Has…
Hello,
I'm working on creating a barcode that needs to meet USPS requirements.
Currently the formula I am using is:
BarcodeUCC128("420" & "56901" & "92" & mid({SO_InvoiceHeader.UDF_TC_USER_8},3,24))
The font for the barcode Code128.
…
I am trying to make a custom report in Business Insights Explorer that shows:
Item Code
Item Description
Product Line
Quantity on Sales Order
Total Quantity on Hand
But I cannot link a "Qty. on Sales Order" column to the rest of the report…
Hi Guys
We have our "Profit Margin Percent Display Warning" set to 15% on Sales order options but we have some customers who have items set to under 15% and when we add these items to a sales order we don't get an alert. Anyone know why this is and…
Hello all,
I know that the "PO Number" field within Sales Order Entry is used for Auto-generating PO's from Sales Orders and creating drop ship PO's from a Sales Order, but I wanted to know if it has any other purpose? I wanted to use this field for…
Hello all,
I am trying to find a way to solve an issue that I have with how the Quantity Available field is displayed in Item Inquiry. It's kind of a difficult issue to explain but I'll try my best here:
Lets say I have 300pcs of an item On Hand.…
Hello,
I am trying to make a custom quote form for the Sales Order module. In particular, I have created three miscellaneous comment codes that I would like to use in the form to act as a type of specialized input for our business' needs. However, when…
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…
The back order fill report included drop ship line items from sales orders. It would seem best to exclude drop ship as those lines will not be filled from the warehouse.
Rich Garrett
DSG, Inc.
I'm working on a button script ("Execute on Server" selected, MAS 200) that will export a PDF of a Sales Order to a specific location without prompting the user. I'm running into some strange issues and was hoping someone has seen some of these things…
Verify the application is installed and running. Contact Sage 100 Customer Support if the problem persists
Has anyone seen this error before? It is happening when I try to write a sales order with SO_SalesOrder. It happens on the nWrite. It actually…
Sales department came into accounting and wanted to know if they could take 3-5 different sales order numbers and merge all orders into ONE sales order?
Any help would be appreciated.
Thank you,
Charlene
Why is it that I have had some customers get invoiced twice in a batch in shipping data entry?
Steps that I do:
Scan sales order into Scan Force
Scan items and send data to Shipping Data Entry
Wait a little bit for the data to send over
Scan…
Hi,
I got this "The Records is not in editable state" Error while delete details from SO_SalesOrderDetail_bus object.
Please anyone give hint to solve this issue.
Given below is my code
int TaskID = (int)oSS.GetType().InvokeMember("nLookupTask…
Currently, we're on Sage 100C 2017 v 5.4, this was a recent upgrade from v 4.9 last September.
One of our user is noticing that deleted orders in the SO Shipping Data Entry batch is showing up in the SO Invoice Data Entry batch that is billing to the…
I have a SO with 14 line items. When I print the picking list, it only shows 13 items. Item #3 from the SO is missing. The picking list shows #1, #2, #4, etc. Any ideas on what might be happening?
80020009
Same problem here - SO and PO modules.
Upgrading from Sage MAS 200 4.40.0.5 to MAS 100 2013 5.00.7.0.
Tried on XP, Windows 7 (cmd as 32-bit), Windows 2012 Server Standard (cmd as 32-bit)
support.microsoft.com/.../896456 (%windir%\SysWoW64…
