Browse By Tags

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…

Is anyone else having problems getting their sales estimates to flow to a sales contract to an invoice? I can go from an estimate to an invoice, no problem .... however to go from an estimate to a sales contract to an invoice it will not post. I can email…

Hi. In the Sales Journal, is it be possible to set up a transaction to debit a payable, instead of Cash or A/R? We am attempting to do the following transactions in Sage 50 2019 Canadian Edition: 1) Increase the size of petty cash for our shop; and…

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…

I'm trying to set a Hold Status when I create a Order via web service Save. I pass in the following, but never recognizes it, and always sets the HLDSTA to '1' (OK - no hold). Does anyone know if this is possible during the web service Save call, or would…

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…

Does anyone know what this means? We don't use "preparation". We started getting this error message recently, sometimes we can blow by it and sometimes we can't. This particular product is not managed so there is nothing to allocate. When you hit ok it…

Every Sales Order we process (Stock and Back to Back sources) requires a carrier (truck/rail) service to ship product to customer. We're integrating with a Transport Management System to help us with carrier selection. What's the best way to represent…

I need to setup a process to manage short term rentals. I have investigated the lease contract option, but it requires Fixed Asset setup and a large amount of transaction overhead. The best option I have found thus far is to use a Loan sales order followed…

We are getting the error below when we try to generate a Sales Delivery from the Sales Order. We are on Sage X3 version 12 Patch 21 Any ideas on how we can resolve? @X3.TRT/SUBSDHA$adx (4540) Error 6 : Variable Non-existent GLONTAC @X3.TRT…

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…