x Want to participate? Join the group to interact

  • Cannot update Comment$ column in GL_CompanyActiveBatch_SVC in BOI

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

  • Sales Order Invoices don't get emailed from BOI script when run with Windows Task Scheduler.

    I created a BOI script that selects a batch of invoices, PDF's them, emails them, updates and PDF's the sales register and updates and PDF's the DTR in 2022 Advanced. The script works fine when run manually from the desktop. When running it from Windows…

  • Work Ticket BOI Change QuantityOrdered and Rescale Labor and Materials

    Using Sage 100 Advanced 2023 and the Production Management Module, I am trying to use BOI to update the Quantity Ordered on a Work Ticket but want it to automatically trigger the rescaling of labor and materials like it asks when you change the quantity…

  • Auto create Sales Order from Master Order Promised Date

    Hi Forum, Is there a way to update the Promised date on a Sales Order from master order using Auto Create task in Sales Order with a Vbscript? Regards,

  • Matching Receipt of Invoice Line with One of Multiple Receipts of Goods

    I've got the following scenario: I create a PO with qty 1000 of Item A on it. I receive against the PO at two different times, so I make two Receipts of Goods against said PO. The first receipt I receive 500 of Item A, and add a charge to the…

  • Deleting a batch - am I missing something or is this a bug?

    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…

  • Added credit card fee to a sales order

    I'm trying to calculate the extension amount of a miscellaneous charge code. When "/CCFEE" is entered as the charge code, I want the extension amount to be the total amount multiplied by .025. Here is my script. I'm getting the following error when…

  • PO Receipt of Goods - Set OriginalOrderQty on existing item

    As a follow-up/refinement to my previous question, I am wondering how to set the OriginalOrderQty on a line on a Receipt of Goods that I have entered by hand. In an effort to isolate my issue, I have created this PO ( here ) and this Receipt of Goods…

  • PO Receipt of Goods - Receiving existing line and adding new line not writing new line quantity

    I have a PO that I am receiving against. I want to receive part of the line that exists as well as add a new line. The existing line is received as expected. However, when I try to add the new line, it creates a line with the item code and unit cost…

  • SO Batch Invoice Multiple Orders

    We can batch invoice certain SO's, however the problem is changing the tax schedule, I had found a work around with two scripts. Since we upgraded we are having trouble with the second order we batch invoice not getting "closed" out. The SO field on the…

  • Alternate Item Auto SO Line Entry

    https://www.sagecity.com/us/sage100/f/unique-business-challenges/190272/un-hemmed-pants-inventory/476813#476813 I am revisiting this topic, would scripting be an option to automatically select the first alternate item with sufficient available inventory…

  • Error in Process Report Method

    We've been trying to automatically post SO Invoice batches at the end of the day. While we have tried using the task scheduler within Sage, we found that for SOME batches (batches created by the shippers in shipping data entry), the sales journal would…

  • QTY On Hand showing incorrect figure

    Hi Guys We are having an issue with an item that is showing a QOH of 2 but on the history tab its actually showing the correct amount which is -34. I have ran a rebuild for modules IM, SO & PO to see if this would correct this but it didn't fix it.…

  • AP Invoice Batch Posting Issue

    BOI-Experts, We are running into an interesting phenomenon. A BOI script creates AP and PO invoices in multiple companies, and then posts the AP and PO batches company by company. A lot of times that works just fine. Every now and then the invoices…

  • Select an existing batch number

    Hello, I have tried looking though out the forums for a way to select a batch number to use when trying to import invoices into Sage 100. What I have found was to use SelectBatch and pass the batch number I want to use as the parameter, but when I do…

  • How to avoid triggering pre-total events for each line of the same imported invoice?

    I've developed a script that, for some customers, discounts TX ItemCode's to absorb their AvaTax calculated sales tax and present a invoice total including sales tax (but not freight) equal to the original net invoice, but when the invoice is imported…

  • BOI Create Completion Transaction for Work Ticket

    I'm trying to use Business Objects to create a completion transaction for a Work Ticket in Sage 100 2022. I can't seem to figure out how to add the work ticket to the actual transaction. Below is a slimmed down version at its simplest form of what I'm…

  • Delete Change Items in BOI

    Is it possible to do this? I've been able to populate the IM_DeleteChangeItems table using BOI, but I can't figure out how to actually apply the changes to the item codes using BOI. If it's not possible that's okay, but please let me know if that's…

*Community Hub is the new name for Sage City