x Want to participate? Join the group to interact

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

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

  • 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 and…

  • 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 I…

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

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