Sage 100

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…

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…

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…

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…

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…

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…

Experts, I am working on a script that modifies the comment on a batch, sets it to private, and eventually attempts to post batches. I am getting the following error message when attempting to do the nSelectBatch on the SO_SalesJournal_upd object: …

I am using BOI to automatically create production entries in BOM in Sage100 ERP. I realize Sage100 ERP support is obsolete, but it is what our company still has and we plan to update in the next year. I have some code I threw together below for testing…

I've been using c# to insert customers, now I'm trying to insert an order, I don't get any error but it don't find the order, I reasearched needed values but maybe I'm missing something int TaskID = (int)oSS.InvokeMethod("nLookupTask", "SO_SalesOrder_ui…

Hello all! I'm working on a script to auto approve batches but I am running into some issues. I looked through the BOI course and there is an example in there that updates the SalesOrder so I adapted my code from that. I'm not sure if I'm setting it…

Hi All, I'm hoping I'm making a simple mistake in my coding and someone can help me out. Below is a snippet of code where I'm reading serial numbers and importing into Receipt of Goods Entry (with an invoice number, in case it matters). I'm looping…

Just starting out using the BOI and I am having trouble finding out how to create an AP Invoice with sales tax values. When the option "Calculate Sales Tax in A/P Data Entry" is on then how do you set the tax values on an AP Invoice? I've used the…

Hello I am trying to edit a existing sales order using BOI,... i am able to make header level changes but when i am trying to change line level data ( ie: item code) a new line is getting created.... And when i am trying to add a new line and over…