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

  • generating a PO from a sales order

    I would like to know if it is possible to only create Po's from a sales order for items we don't have in inventory?

    If I create a sales order that has lets say three items two that I can pull from our inventory and one that I don't have any in…

  • Automatically print backorder pick tickets?

    With raw materials and shortages we have found that we are shipping more shipments leaving a backorder in our system than ever before.  Historically, shipping would go in and print a new ticket with the backorder and keep it until it could be filled.  Our…

  • Sales Order Entry / Totals Tab / PaymentObj

    I believe the Deposit Payment Type on the Totals panel and other data reside in PaymentObj.  What table is associated with this object?  Where/how can I find the data?

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

  • Shipping data entry sending items in multiple packages with packing list for each package

    We have a client who has a customer who wants a packing list for the items that are in each box shipped for the order and not the whole order on the packing list.  Does anyone have a similar issue?

  • Adding Last_Total_Unit_Cost of an item by warehouse to SO field

    Hello Everyone!

    I am looking for a quicker and easier way to ascertain the last total unit cost of an item in a specific warehouse. Our organization has multiple warehouses and sometimes landed freight charges vary for different items based on their warehouse…

  • Sales UOM Pricing - SO using the Standard UOM

    We have some items where the Sales UOM is EACH and standard is KG.  When adding these items to a sales order, the sales quantity shows as EACH however the price is coming over as the standard price x the KGs per EACH.  This only occurs for a handful of…

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