Sage 100

I know how to add attachments to emailed invoices, but I understand all recipients get the same attachment. How do I email invoices, each with it's own unique attachments?

I thought I read a post about this, but now I cannot locate one. When we have Vendors with SSNs, like in this ABC Vendor below, we expect the First Name and Last Name fields to be filled out, but they are not: Of course we get this message, which…

Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…

There are 2 buttons designated to printing the pick list and also the work ticket. When clicking on the Pick List print button it allows us to print the pick list with no issues. However, when trying to print the Work Ticket we are met with an error …

Hi all, We do most of our customer reports based off the GL_DetailPostings table. I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to…

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…

In the SO module we currently use paperless Output Office for printing SO's and SO invoices. Is there a way to use paperless for printing the picking sheet "Pick Sheet"? Thanks

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

When I print the purchase order it does not show the item description on the purchase order. How do I fix it to show the description on the purchase order? Thanks

How can I print a label from Sales Order Entry with the ship to address? Thanks for any help.

I want to thank everyone in this forum in advance for the wealth of information you have posted and gathered here. With that information, I have been able to apply a script to automatically print Sales Orders once they are entered. The script below runs…

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…

Has anyone found a way, including third-party enhancements, to attach and print a document associated with a sales order. We have a customer that wants to print a document with shipping instructions after the sales order prints. Any help is greatly…

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…

Unfamiliar with this Error. Can't Print Sales Orders. Is there any knowledge on how to correct?

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…

Hello everyone, I'm hoping someone will be able to help. Our AR invoices have an additional section at the bottom, beneath the Invoice Total, showing payments/credit/discounts applied, with a Final Balance Due. That way, once someone pays the invoice…

Hi All, I am struggling with this issue. Everything I read says it should work this way but it does not. Client is on Sage 2017 Standard. I created a report that uses a silent connection. It is 64bit and I have set it up as a System DSN. Works fine…