Sage 100

I am calculating a UDF (by script) on each SO Line. I need a script that will accumulate those Line amounts and save it to a header field. I'm hoping some smart guys knows how to do this.

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!

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?

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…

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…

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…

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…

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…

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…

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…

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…

Does anyone that knows how to control and allow salesperson to be able user lock the by the salesperson to be able to see only see their only their customer statement and sales order invoice but no other sales representative. Currently, the lookup is…

I want to have all SO Invoice lines default to an order quantity of 1 and a ship quantity of 1 (currently the default is zero). This is Sage 100 2019. I wrote the following script and attached it as a post-validation event to the Item Code column, but…

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…

Hello, We have an issue where an order is currently marked as an "Active Order" under Sales Order and Quote History, but this file is not accessible inside of Sales Order Entry. We get the message: "The Sales Order number already exists in the History…

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

Hello, We have recently had many complaints about Sales Order Entry freezing when users click accept after creating a sales order. We plan on restarting the servers this weekend but I am not confident that this will resolve the issue. I have searched…

We have many sample orders that go out at no cost. Is it best to have one master account, then add shipping locations for each order? What is the best practice for keeping an inventory of those items?

Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging. Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…

Does sage have the ability to prevent shipping on certain dates like Christmas or plant closures?

I created two credit memos in the SO module and noted that they should apply to two specific invoices. However, the invoices had already been paid. Now the customer wants to take these credits against a different invoice. When I go to cash receipts entry…

Hello, We are implementing some new charges for the new year and would like to begin using the Miscellaneous Items feature. I've set up my Charges and have tested adding them during a sales order creation on the Lines tab. Seems to work great, except…

I am looking to run a report that has all Sales Orders for each salesmen for the year. I can figure it out if it just has the Open Sales Order but I also want the closed /invoiced ones too. Any ideas? Thanks in Advance. --Tracy

A customer needs to bring in a sales order from a SQLdatabase in Sage 2013 using the BOI. The SQL server is separate from the MAS server, both in our data center environment. We believe permissions are OK. Our code is doing: PathHome = "\\machinename…