Notice of Maintenance on October 9th. Click here for further details.

x Want to participate? Join the group to interact

  • BOI script to print Sales Orders

    Hi Forum, Is there a sample BOI script to print Sales Orders on this forum, I remember seeing a thread on this time ago. Any suggestions? Regards,

  • SO Line Item Not writing

    retVal = oSS.nSetProgram(oSS.nLookupTask("SO_SalesOrder_ui")) set soOrder = oPVX.NewObject("SO_SalesOrder_bus", oSS) Set soLine = soOrder.oLines retVal = soOrder.nSetKeyValue("SalesOrderNo$","0001000") retVal = soOrder.nSetKey() retVal = soOrder.nSetValue…

  • How to add a change order to a job in the Job Cost module?

    Hello, I am trying to add a change order to a job in the Job Cost module using the BOI in the C#. I have taken the BOI course and understand the basics of how to interact with Sage using the BOI, and have been using the Object Reference documentation…

  • Receipt of Invoice Import

    I am trying to configure a VI job to import a vendors invoice that is referencing a "received" purchase order. Our AP goes line by line entering the qty invoiced right now, and also double checks the pricing. I wanted to import the qty invoiced and correct…

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

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

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

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

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

  • Invoice total displaying as zero

    The total is displaying as zero in Invoice Data entry I've written the script for the extension amount as follows. Can you pls clarify which column should be used to store the total?

  • Invoices not showing in customer maintenance

    Hi Team, Can someone kindly help me with displaying the invoices in the customer maintenance section? It appears in the data entry for invoices but not in the section for customer maintenance.

  • issue with an external BOI script to populate and post cash receipts entries

    Hello all, I'm seeing an odd issue with an external BOI script to populate and post cash receipts entries. The short story is that automatic posting results in a duplicate bank rec deposit entry and leaves an orphaned deposit record in AR_CashReceiptsDeposit…

  • Auto-Saving JE's Not Available in Sage Paperless Office

    Hello, We use Sage 100 > DM2 which has some additional journals that are not available with the standard Sage 100 product and therefore are not options to auto-save in the Journal and Registers Maintenance module. Is it possible using a user-defined…

  • Does anyone know how to control the invoice date and update date to prevent for updating the batch, until both are the same?

    Does anyone know how to control the invoice date and update date to prevent for updating the batch, until both are the same? This relates to all modules SO,PO, AR, AP, IM. If anyone knows how to custom script on how to handle this matter? thanks.

  • <NewObject Error 200> on Set oCC = oScript.NewObject("AR_CustomerCreditCard_bus", oSS)

    Hi Forum, We are getting an error 200 trying to create "AR_CustomerCrditCard_bus" object The customer uses Paya to pre-auth credit cards and for whatever reason it is not letting us create the object. This same code worked in Sage 2016. Upgrade…

  • A batch number is not set up when creating invoice using BOI

    Hi all, I was searching around and was not able to find issue that would provide me a hint on the problem I'm currently facing and was hoping to request some help from the community. I'm getting the error of.. A batch number is not set up here's the…

  • Message Box Showing Up Even When Intended Criteria is not Met

    Hi, A few days ago I had a Post that I was lucky enough to get help with. After getting some feedback from some of our shipping department, they let me know that even if they go in and change the Ship Date in Sales Order Entry, the message box will…

  • Checking if Ship Date is past due when Creating Packing Lists

    When opening a Sales Order # in Shipping Data Entry, I'd like there to be a message box if today's date is past the ship date of the order. I grabbed this code off of a previous question I asked in this forum and figured I could use most of it for my…

*Community Hub is the new name for Sage City