• Button Script to delete Sales order with cancel code

    Hello all,

    I wrote a script with the goal to delete sales orders with a specific condition. So I can delete sales orders just fine its just that when the orders are deleted the cancel reason code is not flowing to history it is staying blank. I am even…

  • Sage 100 BOI Script to Create Inventory Transactions

    I'm writing a BOI script to create Inventory Adjustment Transactions.  I want to use the next available entry number so I have the GetNextEntryNo(refNo$) function in my script.  What I can't figure out is what the "refNo$" needs to be.…

  • Creating PO via BOI Write Issue

    Hello All! I have an issue with creating a PO via BOI that I was hoping someone can help me with. We're using  Sage 100cloud Premium 2019 Version 6.10.4.0. Here's my code:

    using (DispatchObject poObject = new DispatchObject(pvx.InvokeMethod("NewObject…

  • Purchase Order Receipt not properly saving

    I'm working on an integration for a client and am trying to create PO Receipts using c# and Sage 100's BOI. The end result shows the vendor when I look at all PO Receipts, but the receipt is empty when I view the full receipt

    Here are the current…

  • Paperless Office Email from AR Invoice History Printing Report through BOI

    Experts,

    I have an issue with automating invoice emails through Paperless from the AR Invoice History Printing report. The code below works fine in my test environment but fails (without an error) in the target environment.

    My test environment is v20…

  • BOI - Bypass Separate Check Popup

    I'm working on a BOI script to create Manual Check entries from a CSV. 

    Everything can import successfully, except when the invoice was set with SeparateCheck = "Y". In regular UI, you get the popup message "The Invoice ____ is flagged for separate…

  • Copy invoice from AR_InvoiceHistory to flat file

    I have most of this script working but am hung up on the part reading from the line detail object.  I have created a button on the AR Invoice History Inquiry panel so that the end user can find the invoice they want to copy, press the button, and the flat…

  • oSession.UserName object required

    Hello,

    We have a customer using our button for a form in Sage 100. We are on 2020 advanced, with script for button to execute on the server. The username:

    oSession.UserName

    worked but now it is throwing an error, nothing seems to have changed as we…

  • Logging to find cause of "The column is not in the IOList."

    Hello, I have taken over an existing installation that does not have any documentation or support on it. Our website uses a custom sync tool to push orders into Sage.  Everyone once in awhile (10% of orders or so), I will see an error, "The column is…

  • Script on SO Lines, Visual Bug

    Apologies for the large block of text but this is a strange one.

    I have a script that recalculates the Unit Price of a parent Kit item based on the component items' standard prices, and recalculates whenever a Quantity Ordered is changed for any component…

  • Write on Production table using script

    Are we able to write on the Production table from the Sales Order Entry UI?

    I have items that based on the S/O Entry need to be put on a Production Entry so was wondering if after they are entered in the SO and the Picking Sheet is printed, I can write…

  • OLE Error 424 - for some users only

    Running Sage 100 Advanced 2018: I have created a UDT to hold key information needed for our accounts by zip code, and a Button Script to look up the data by zip code, populate certain fields, then show a message to the user. I can run the script just…

  • Missing record to calculate taxes

    I am getting this error "Missing record to calculate taxes." while trying to import Sales order in Sage using BOI.

    Has anybody faced this issue before? OR anyone has some idea how to solve this.

    Appreciated your help

  • creating an order

    Hi 

    I am trying to create an order using C# but I get an error with the "invoke" as below

     An unhandled exception of type 'System.Reflection.TargetInvocationException' occurred in mscorlib.dll
    Exception has been thrown by the target of…

  • Exception on nWrite in CI_Item in C#

    Experts,

    I have a small app that writes to CI_Item. It has been working with no issues in Sage 100 v2017 Premium for my client in a Sage Server / Terminal Server setting. Now they are on v2020 Premium in the same setup (new servers), but we are running…

  • BOI Print PickingSheet resets form code to STANDARD

    Hi everyone, would you please have a look at this and see why this is running erratically?  I've seen some sample scripts here and there, and the bulk of my script is from the other posts on this forum.  I must be misunderstanding what objects and what…

  • Strange Behaviour when Setting a Date UDF from Button Script

    Hi,

    I am setting a Date UDF from a Button Script for the line that currently has the Focus in the GD_Lines. I tried setting through SetValue as well as InvokeChange. With both methods the date shows as YYYYMMDD in the UI until I refresh the grid or move…

  • Is the Sage 100 6.20 BOI 32-bit or 64-bit?

    Sage 100 2020 (6.20) I have written a Power Shell script to import PO ROG. The script, when run stand alone works great.  When the exact script is copied to a 3rd party program and run from there it fails.  I think I might have a 32-bit vs 64-bit conflict…

  • Print to PDF and electronically deliver Sales Order via BOI

    I want to thank everyone in this forum in advance for the wealth of information you have posted and gathered here.
    With that information, I have been able to apply a script to automatically print Sales Orders once they are entered.  
    The script below runs…

  • Consolidated billing query with AR_InvoiceHistoryDetail

    We are trying to write a query or stored procedure to identify the cash receipts for each of our franchises (warehouses) but ran into some trouble with consolidated billing. Since payments aren't applied to the line items we need to create a lookup table…

  • The Column is not in the IOList - Error setting UDF on SO_Detail

    I have a UDF on SO_Detail table I'm attempting to populate with a BOI script (written in C#).  This field is set to datetime type, the data I'm sending is being parsed from string to datetime format in the script. 

    I'm sending the SalesOrderNo,…

  • run script without admin (COM exception failed to initialize provideX library)

    I see that there are lots of questions about this in the past, but I can't seem to find a concrete answer on how to move forward with it. I realize it has something to do with DCOM, registering the DLL, running client side verse server side.... But I…

  • BOI IM Transaction Entry Delete Line

    Have written a BOI app for scanning pallet tags.
    Tag has Pallet ID No., Item, Lot and Qty.

    We are doing Sage IM Transaction Entry - Transfers.
    We are loading product on one of our trucks to go to our distribution center.

    The app is up and running, working…

  • I can't seem to set an event for an item change

    I am trying to get an event trigger when an item quantity changes so I can perform a real time update in a UI.  I have tried setting Post Write Events on IM_ItemWarehouse and IM_ItemTransactionHistory, but although I can see the DB Tables changing/updating…

  • Set Sage field equal to UDF (user script?)

    Earlier this year I created a mobile application for pulling orders. To integrate, I made a rather barbaric implementation: when the mobile application backorders an item, update SO_SalesOrderDetail.QuantityBackordered = External.QuantityBackordered.…