• Expanded Price Levels (DSD IMXL)

    I have an end user that is considering DSD's Expanded Price Levels enhancement. I am a little nervous adding an enhancement that will have such a large impact on Sage 100. Just wondering if anyone has any experience with this enhancement. If so, are you…
  • SALES ORDER: Bill-to Address Randomly Reverts After Being Changed, Cannot Replicate

    Sales Order Entry person created an account. Bill-to and ship-to set up as same address until she received the correct bill-to. In the meantime, she entered a sales order with the addresses as the same. Received the correct bill-to, updated in customer…
  • Retainage

    Good afternoon, I need help coming up with a way to correctly track Retainage and if Sage 100 can do so? Retainage is sitting in our A/R and skewing our A/R Turnover numbers. Is there a way to invoice retainage separately or track separately? Any help…
  • Sale order zipcode import issue after upgrading from Sage 2018 to 2021

    Hello, We just recently upgraded to Sage 2018 to 2021 and our third-party web service(Deposco) sale order imports are now having issues after migration. Error response: FAILED : Exception: Error trying to set property BillToZipCode$ with value 46550…
  • Copy UDF Values from AR_CUSTOMER.M4T to Equivalent UDFs on new Sales Orders

    New to this forum, and new to using the Business Object Interface. Scenerio: I'm on Sage 100 2022 Standard, and am about to implement Sage Alerts & Workflow. One of the tasks I will be creating will periodically look at all open Sales Orders and automatically…
  • Sales order entry - unit price goes down to 0$ after changing quantity

    Unit price drops down to 0 when changing the quantity of "ordered" on the same line item. Is this normal behavior, or was this intentionally implemented at some point? Can anyone point me in the direction of an article to reverse this? Thanks!
  • Duplicate SO (PO's) being imported via True Commerce EDI in Citrix environment

    Upgraded from Sage 100c Advanced v2019.2 to v2022.1 on new Win2022 ERP server and separate Win2019 Citrix server. When we import EDI PO's from True Commerce Transaction Manager v2 integration into Sage 100 which become SO, of course, we get duplicate…
  • Sales Order - Stock Status on Sales Order Quantity and Sales Order by Item Report Quantity are Different

    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…
  • Split Sales order with a script

    Hello everyone, I was wondering if anyone has been able to split a sales order into two separate orders based on line information using a script. Would something like that be feasible?
  • Default Warehouse Precedence

    We want the default warehouse for specific customer ship-to locations to carry over to sales order line items. I have successfully set it up so that the warehouse is set correctly on the sales order header based on the ship-to location. However, the…
  • Disable Auto Increment for Lot/Serial Number Distribution in Shipping Data Entry

    Upgraded to Sage 100c Advanced v2022.1 with OM PU1 from v2019.2 Shipping Setup Options has Auto Increment disabled, but when distributing Lot Numbers in in Shipping Data Entry, the Auto Increment in the Lot/Serial Number Distribution window is enabled…
  • Tracking Deleted Sales Order w/SKU detail

    We have numerous SKUs with a reorder point of 0 and most are treated as special order product. We often find that special ordered material arrives from the vendor only to find out the customer cancelled, the SO was deleted and no way to look back at transaction…
  • Import Orders with Visual Integrator

    I'm wanting to get orders imported started with a J and have them increment for every new order that comes in. I managed to get the J in there, but with using the "NEXT" order number. Is there a way to have the vi job check for the last order, then…
  • Item Bundles??

    Hi. we are currently on Sage100 Advanced 2021. We are a drop shipper which normally only sells the items it receives from overseas in the same box it is received in. We are looking at grouping items as bundles and trying to sell as a collection. …
  • Sales Order digital approval process

    Does anyone know of a product that integrates with Sage 100 where a Sales Order quote is emailed to customer and they can digitally approve it and that digital approval turns the quote into an order?
  • Does SAGE 100 offer paperless for SO Picking sheets

    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
  • All "lookup" windows Sage 2022

    We recently upgraded to Sage 2022.1 and one of my employees was frustrated because every time she resized columns in the Sales Order lookup window, they would revert back - even after creating a custom view. I tested it on a few other lookup windows…
  • Script to Synchronize Customer Billing Address in Sales Order Data Entry

    I was attempting to create a VB Script (to be executed via an External Link button) that would update the billing address within a sales order from the customer's AR address. Currently our admins do not have the ability to manually change a customer's…
  • How to enter Purchase order and create Sales Order using API

    My team has been using desktop Sage 100 (2021) to enter purchase orders to generate sales orders, but we would like to do this via API. https://help-sage100.na.sage.com/2021/FLOR/index.htm#Program_Listings/Program_Listings_Overview.htm?TocPath=Program…
  • Getting total pieces ordered on a SO to print on the SO

    is there a way to get a sum total of all the pieces ordered to calculate and print on the SO, Packing list or bill of lading. I am looking for the grand total of all the items. Having a grand total of the items shipped would also be helpful. Than…
  • C# Create Sales Invoice From Sales Order; nSetKey() fails, sLastErrorMsg = "The [InvoiceNo] is invalid"

    I am on Sage 100c Standard 2016 (Version 5.30.5.0) (yes, I know it is very old, and have plans to upgrade to a supported version). I am attempting to create a program in C# that creates a sales invoice from a sales order. When my program executes the…
  • Void credit card authorization on sales order

    Several versions ago we were able to void a credit card authorization on a sales order but haven't been able to get it to work on Sage100cloud Advanced 2019 Version 6.10.2.0. We are using Paya. I have confirmed that the Library Master, Security settings…
  • How can I verify where items are committed? Sales Orders/Backorders/Etc.

    My company manufactures products that we categorize by Lot #. As an example, I have an item with Lot # ABCD that we delivered into Sage 4,143 bottles. Of that Lot #, I can confirm that 3,628 have been invoiced and sold, leaving 515 left, which is exactly…
  • SAGE Formula

    I have a formula in my SO picking sheet it puts different words on the header depending on the number of days between the order date and the ship expire date. I want to edit this formula that the < 4 is actually 0 to 3 Business days. before the wording…
  • 100E - Sage 100 - Object Interface Course Purchase Issue

    Hi, I purchased the above mentioned course on Sage university but I was not able to access the material as the payment was pending. Also, I got a auto mail from sage informing that one of their sales person will contact us for payment part, but I…