Sage 100

Is there a PO Return of Goods History Report? I see Inventory Sales History, Inventory Receipts History, and Inventory Issue History Reports under IM module, but I don't see an Inventory Return of Goods History Report. Nor do I find one under the PO…

hello guys!!! I have a trouble, im new in using SAGE100 but i can't identify teh difference between qty on Hand vs Qty after shipping SOs??? Someone help me to explain what is the meaning of qty after shipping SOs?? I mean, for example: I can…

I am looking to sort my open orders in a specific way that I cannot figure out with the standard open sales order report/open orders by item report. I would like to sort all the open orders first by product line. Then when I have all the open orders for…

For one item / warehouse (that we know of so far), the On Sales Order quantity listed on the Stock Status report and the quantity on the Open Sales Order Report by Item report do not match. Actually a difference of 4300. Can't seem to find a reason. I…

Solution ID: 111860 dated 8/24 - would love to see a hot fix on this SOON......

Hello, Is there a way to show which PO's that have been received in are missing an invoice? We just switched over from Sage 50 and when the warehouse would receive material in, they would check off the box "waiting on bill". That way I could then just…

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…

We have need to reprint a packing list for a shipment which has already been invoiced and posted in Sales Order. Not finding anything in Sage City or the Knowledgebase, so I'm assuming those who know will tell me that it is not possible. Please confirm…

We recently turned on Scanco Multi-Bin in SAGE 100. Sales Order -> Picking Sheet Printing allows the ability to add a Form Code MB_Rows and select Multi Bin Rows picking sheet. This works fine. My question is how do I ability to print that .rpt…

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. …

Months ago I created this post about the Stock Status Report and Sales Order Qty: https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-distribution-manufacturing-and-internet-modules/110446/inventory-valuation-which-shows-available-balance…

Hey All, I'm having an issue where all the options are enabled for documents to print after clicking "Accept" in Shipping Data Entry, and now no print prompts come up when clicking "Accept." Traditionally, we've just clicked "Accept", the packing list…

We have an issue where when we have kits exploded, the picking sheets (which are sorted by bin location) will seperate the kit item code and then the kit components all over the picking sheet. This is very confusing. Is there anyway to have the picking…

We want to know if there is a way to set certain line items in an sales order to not print on any forms. We want to do this to track packaging materials used to fullfill an order. We clearly do not want to have the packing used to show up on invoices…

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.

Hi all, We're looking for ways to better manage/track pick tickets in the warehouse and we'd like to tweak the form a little bit too.... The SO_SalesOrderHeader.PickSheetPrinted flag is set to " Y " after the initial printing of the pick ticket. …

Looking for some insight no matter what I do after creating a Rental Contract or Sales contract my Total Weights is listed as 0. This function worked just fine a few months ago then after a recent updates stopped. the individual items have weights assigned…

Every month, we send a "Top 100 Best Sellers of the Year" email newsletter to our customers. In Sage 50, we could create a "best sellers" list simply by creating a Stock Report, selecting to add the column for Sales Qty Year to Date, exporting to Excel…

We frequently generate Purchase Orders from Sales Orders - but when I use the Open Purchase Order report and look up a PO I know for a fact is linked to a SO, it does not list the SO. I see in Crystal Reports the Open Purchase Order Report should, there…

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?

We have MAS200 4.5 (we are just about to upgrade to 2015. In the meantime, I noticed that in Sales Order, there are three Sales Order Reports. They are Open Sales Order Report, Open Order by Promise Date, and Open Order by Item. We report in two units…