Sage 100

I am currently using Sage 100 and Trucommerce Transaction Manager. Our current setup is incomplete. Transaction Manager sees what state the sales order is shipping to and then assigns the appropriate warehouse code so that the order will ship from the…

A SAGE100 Premium VS. 2020 has occasional missing S/O order header records. The order lines are still there. The order is completely there in order history. The order has NOT been invoiced. Anyone seen this?

Most but not all Backorder lines are incorrectly calculated based on the Order Qty but should be Backorder Qty. As a test, I copied the Live company into a test company at the end of our shipping day just before running Daily Sales Reports and Updates…

We just upgraded from 2017 to 2019 Sage 100cloud. Now when we post invoices using S/O Daily Sales Reports and Updates, we get a message "Not all invoices have been printed". We didn't use to get that. I poured over Role Maintenance and S/O settings…

Is there a way to get Sage 100 to Display the Value of the Items in each box when doing Shipping Date Entry? This would be for internal processing only. We're able to print out a packing list per box and indicate its contents, but we still need to manually…

What is the fundamental logic difference MAS uses when entering line items to sales order that exceed available quantity? To be clear, suppose you're entering a sales order line item that has an available quantity of 5. If you enter quantity 6, you…

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…

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…

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…

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…

Good morning. I have created some routings which have 5 key steps to them for 5 key phases of manufacture to improve visibility. I have made these steps standardized across routings. The step numbers are set off by 100s so there is a step 0100, 0200…

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…

We are having an issue where line items are being deleted from active sales orders either manually or via our pick/allocation process. We can see these deleted line items in Sales Order History, but is there a table with history as to when/who deleted…

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 import our Web Sales orders with Credit Card Pre-Auth and getting this error. Anyone know what this error means?

As we use Sage 100 not Sage 100 contractor, and since AIA forms don't integrate with anyone thanks to copyrights, we have to use SAGE like normal to track inventory and revenue through invoices, but those invoices don't get mailed. To keep our accounting…

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…

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

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…

We have a client who would like to create an invoice for items that are scheduled to be shipped later. Any thoughts on how to accomplish this?