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…

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…

Hello, I'm dealing with a situation that I'm not sure how to manage. Let me explain: Suppose I have a Sales Order for a customer, in which I have only one line containing two units of a product that we produce. I also have a Work Ticket linked to…

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…

Hi Everyone A purchase order was received in with a higher unit costs than it was supposed to be Sales orders were processed and updated Found mistake did a return of good and re-received at the correct unit costs How do I now fix the profit margins…

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.

Sales Order Entry person created an account. Bill-to and ship-to set up as same address until she received the correct bill-to. In the meantime, she entered a sales order with the addresses as the same. Received the correct bill-to, updated in customer…

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…

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!