• Email SO Invoices with Attachments

    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?
  • How to print Extended Description on Sales Orders?

    I was unable to find anything online, how can I print item's extended descriptions so they will show up on printed Sales Orders? Or alternatively how can I increase the 30 character maximum that the SOs will currently print? Thank you for the help.
  • Inventory Adjustments - Profit Margins

    Hi Everyone A purchase order was received in with a higher unit costs than it was supposed to be Sales orders were processed and updated Found mistake did a return of good and re-received at the correct unit costs How do I now fix the profit margins…
  • Print Copies of Picking List According to Item Quantity Per Order

    Hello everyone, I created a picking sheet form to print out as a thermal label customized to a merchant's specification. The label has two unsuppressed sections (rest suppressed), Group Header SO_SalesHeader.SalesOrderNo and the Group Footer. The Group…
  • Automatic Sales Order Entry

    What are the best options for getting automatic entries for new Sales Orders? Looking to integrate orders placed through online sales and have them directly entered into Sage. Currently on 2020, but looking to update.
  • 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…
  • 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…
  • 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…
  • Automatically Distributing Lot Number in S/O Invoice Data Entry through Visual Integrator

    Hello All, I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…
  • Can an Inventory Depletion be Linked to the Receipt???

    First off, our ultimate goal is to look at an Invoice in AR_InvoiceHistoryHeader and Detail and know what the Landed Cost is. The Purchase Order Module's History Files does a pretty good job of tracking Landed Cost History by Receipt Number. However,…
  • Anyone know of any Performance issues with Sage 100c ADVANCED v2021 PU1

    I'm preparing my upgrade from v2019 to Sage 100c Advanced v2021 with PU1 (due to Scanco Operations Mgmt compatibility) and notice KB articles referring to slow performance issues with STANDARD and PREMIUM. But nothing with ADVANCED. Does anyone know…
  • How do I split incoming EDI sales orders into appropriate warehouses while also considering stock status?

    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…
  • Visual Integrator Import Sales Orders Referencing a Master Order

    I use VI to regularly import sales orders. In this case, I would like to reference an existing master order, as the only data that needs to change per order is the header comment. As I have several master orders to reference, it would be nice to populate…
  • User Defined Fields Data

    We use UDFs on our Invoices to populate fields with both product codes and lot numbers. If those items are already part of the products invoiced, all is good. If we have to manually enter product codes or lot numbers, we have a weird issue. I'll try to…
  • Issues opening Sales Order with Script Sales_Order_UI

    I have used this code for years me and a handful of others, but we have a few new users that are having issues and can't appear to use my app to open Sage Sales Order. The only indicator they get is SO_SalesOrder_UI in a message box. Here is the…
  • Business Insights List Query

    Hello! I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer. It would be nice if i could filter a whole list of orders…
  • How to add Quantity Ordered and Back Order to Additional Packing List

    Is there a way to add the Quantity Ordered and Back Ordered fields from either the SO_InvoiceDetail or SO_PackingListWrk tables to the SO_AdditionalPackingListWrk table? I've tried creating an UDF via CM under SO Additional Picking List Work, but I…
  • Invoice Batching – Can't Set the Cost Account Key

    When invoicing RMA's, we use logic in a custom script to set the cost account key and the sales account key on the line items based on based on the customer division. When I go to the newly created invoice, the sales account key has the correct value…
  • Can I use table IM_ItemWarehouse to trigger script?

    Hello I was just wondering If I can trigger a user defined script, with table IM Item Warehouse? I'm looking to trigger a script when there are changes on an item inventory. I see a field named Available on Item Maintenance > Quantity, I'm assuming this…
  • Need help with a script invoked on the button click to validate the customer's open invoices

    Hi friends, We have a business requirement to have a vb script that would pop up a message box on the sales order entry as soon as we tab out of customer no field or set as a user-invoked button. If the customer has any open invoices that are past…
  • What is the maximum number of UDF's you can create for the Sales Order Detail table?

    In general is there a maximum number of UDF's per table. And is there a maximum number of UDF's that can be added to a form? In particular, I am looking at adding 120 UDF's to the Sales Order Detail line - is that possible? It will be Sage 100 Premium…
  • Error in File Sales_Order2...ErroKind

    Unfamiliar with this Error. Can't Print Sales Orders. Is there any knowledge on how to correct?
  • Add a column in BIE? Help, I am not that smart!

    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…
  • How to prevent a SO from being invoiced with negative quantities because the PO hasn't been received

    The Subject pretty much sums it up. We create a SO with a BO, we order the product. The product arrives but the PO isn't always received into Sage 100c before the SO is invoiced. Is there a setting that won't allow the SO to be invoiced or to prevent…
  • Log who printed Picking Sheet

    I am trying to create a script that writes the current user key when the user prints the picking sheet. Has anyone done this before? My script doesn't appear to work and I am unsure which event I should use to accomplish. My code is below: retVal…