Sage 100

Hi Forum, Is there a way to update the Comment$ column in GL_CompanyActiveBatch table using BOI?

Hello Does anyone know what the root cause of this break between the SO and PO Lines. Since we upgraded to 2022 version (Sage 100 Advanced 2022 7.10.2.03 64 bit) This scenario has occurred on a frequent basis. I know how to correct it; however, we would…

Hi there, I really hope you can help me with something unusual that has been happening here for the past month. We've been experiencing some issues with SO backorders. Normally, when we print the Pick Ticket and there isn't a sufficient quantity,…

I'm on Sage 100 Standard 2020 (v6.20.1.0). We create sales orders, and then after each sales order ships, invoices are imported into a SO_InvoiceHeader batch. When the batch is posted, all the sales orders are supposed to disappear from SO_SalesOrderHeader…

I thought I'd done this before, but perhaps I haven't. The batch is empty. I've confirmed that. But the below doesn't delete it and the retval doesn't return an error. Am I missing something? I've confirmed that sBatchNo has the correct batch number value…

Hi, For one of our customers, we enter a sales order with the Deposit Payment Type of Pre-paid, but is there a way to see what GL account it is going to? I am trying to track from a previous order, and under the totals Tab that is where it mentions…

Hello, I am using Sage 100. I received an RMA about month ago and the Sales Order I thought was attached to it was either deleted or used by someone else. I wrote the SO # that was created in the "Generate Transactions" screen when initially receiving…

Hi Everyone! I forgot to zero out unit price for a received RMA that already has a created batch in the invoice data entry (already posted the RMA Receipts Entry). Is there a way to edit or correct? I would greatly appreciate any help!

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.

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…

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…

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…

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?

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…

Hello , We are new to using Sage 100 and have a few questions . After our sales people process a sales order we then go into Shipping data entry and then print the invoice. At the end of the day , we then update the register. My question is , how…

We just upgraded from 2017 to 2019 Sage 100cloud. Now when we post invoices using S/O Daily Sales Reports and Updates, we get a message "Not all invoices have been printed". We didn't use to get that. I poured over Role Maintenance and S/O settings…

I've been using c# to insert customers, now I'm trying to insert an order, I don't get any error but it don't find the order, I reasearched needed values but maybe I'm missing something int TaskID = (int)oSS.InvokeMethod("nLookupTask", "SO_SalesOrder_ui…

I have a VI Job that imports sales order invoices into a batch. I have scripting that does some zip code validations and then uses scripting to interact with 3rd party integration buttons that are installed (Vertex tax software). The scripts work perfectly…

Hello, I accidentally closed the update window and now I can't update my daily sales order transactions. It says "Unable to update S/O transactions while another update is currently in process." We are using Mas 90, version 4.3 Thanks for any help…

Can I create a Master Sales Order and Invoice/Ship off the Master, like the Master PO? Thanks - Darrin

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…

As we use Sage 100 not Sage 100 contractor, and since AIA forms don't integrate with anyone thanks to copyrights, we have to use SAGE like normal to track inventory and revenue through invoices, but those invoices don't get mailed. To keep our accounting…