• Modifying Order of Secondary Grid Lines for All Users on Sales Order Module

    I'd like to modify the order in which lines are displayed in the secondary grid in the Sales Order Module (Sales Order Entry). 

    We have several UDF's in that grid, but I am having trouble seeing the list of fields within that secondary grid. Using…

  • Button Script to delete Sales order with cancel code

    Hello all,

    I wrote a script with the goal to delete sales orders with a specific condition. So I can delete sales orders just fine its just that when the orders are deleted the cancel reason code is not flowing to history it is staying blank. I am even…

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

  • SO entry screen

    We just did the SAGE 2021 update and something all of our people are finding an issue with is  In SO entry screen under the lines tab we used to be able to have the columns in the order we wanted and have what we wanted to see and it would remember it…

  • Is DeactivateProcedure usable on external scripts?

    I've used DeactivateProcedure on scripts running within Sage, but not on external scripts.  I'm working on a script that requires me to disable procedures in SO Entry.  I've tried a few variations, but I'm getting "Object doesn't support this property…

  • Bug re default forms if perpetual - Any movement on this?

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

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

  • SO Shipping Batch No. missing on Invoice

    Occasionally we get an Invoice that is missing the Batch No. from when it was created via Shipping Data Entry.  We have multiple batches a day, usually separated out between EDI and Non-EDI orders and/or AM vs. PM shipments; totally anywhere between 2…

  • Order Total on Sales Order Totals Tab is Zero

    We are running 2019 100c Advanced.  From time to time when entering a new SO the Order Total on the Totals tab is zero, while the total on the Lines tab is correct.  Oddly, the system allows the SO to be saved in this condition!  To correct the imbalance we…

  • Bulk delete empty Sales Order batches

    We have a process synchronization from our online store into Sage using the SData API. We had a glitch that caused a large number of empty Sales Order batches to be created. There are no invoices on these batches, so I was wondering if there was a way…

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

  • SAGE100 Premium VS. 2020 HEADLESS ORDERS !!

    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?

  • Phanton Users Sage 100 2019

    Hey All,

     Just received our upgrade from Mas90 4.3 to Sage 100 2019 a couple of weeks ago! Woohoo. One thing I'm trying to sort out is how to eradicate Phantom Users. I'll explain:

    We are having trouble fixing some valuations in Sales Order Entry…

  • Fields not being saved on customized Sales Order form

    I have a client who has a fairly heavily modified SO form (although we cut back from what we had previously done by quite a bit).

    The client will have an issue with the Freight amount not saving on the Total tab.

    I will go in and recreate the customized…

  • Extension Amount on System-Generated, Partially Shipped Backorder Lines, is Incorrectly calculated on Order Qty not Backorder Qty

    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…

  • Missing record to calculate taxes, Sales Order Invoice.

    I'm getting this error if I leave off the sales order number. I want to be able to enter the sales order invoice without a preexisting sales order. All the code seems to work and the data is being input into Sage, however the tax fields never populate…

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

  • Script on SO Lines, Visual Bug

    Apologies for the large block of text but this is a strange one.

    I have a script that recalculates the Unit Price of a parent Kit item based on the component items' standard prices, and recalculates whenever a Quantity Ordered is changed for any component…

  • Write on Production table using script

    Are we able to write on the Production table from the Sales Order Entry UI?

    I have items that based on the S/O Entry need to be put on a Production Entry so was wondering if after they are entered in the SO and the Picking Sheet is printed, I can write…

  • Can you print a shipping label from sales order entry

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

  • Missing record to calculate taxes

    I am getting this error "Missing record to calculate taxes." while trying to import Sales order in Sage using BOI.

    Has anybody faced this issue before? OR anyone has some idea how to solve this.

    Appreciated your help

  • 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 only…