• How to automatically create Work Ticket in Production Management from Sales Order using BOI

    I have built an order importer that automatically creates sales orders based off of an EDI file from our customers. It works great. We are currently upgrading Sage 100 to include Production Management Plus and I want to be able to add in the ability to…
  • 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. Does anyone have…
  • 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
  • Sales Order Import Error

    HELP!!! 'm getting a runtime Error 440 < Error: 0 in Method ADDLINE> after the MsgBox "Add Lines" What's the issue? im Answer As String Dim MyNote As String 'Place your text here MyNote = "Import Orders into Sage?" 'Display MessageBox Answer…
  • Import into the BM_ComponentReportSelection.M4T!!!!

    Is there any way to populate the BM_ComponentReportSelection.M4T without manually keying it in the Gross Requirements Report? It is not an available table to import into for Bill of Materials. https://solitaire.onl/ https://9apps.ooo/ https://bluestacks…
  • BOI SETVALUE/CLEAR Error Handling

    Hello, We recently ran into a problem while importing AP invoices as a batch. Here is a summary of our code in C#: // Loop though AP invoices a batch foreach (var invoice in batch.NonInventoryInvoices) { try { service.Call("nCLEAR"); service…
  • Script to import lot/serial into so_invoicetierdistribution

    Does anyone have a vbscript sample for importing serial numbers into so invoicing? We currently have a script to import into so invoice but need to add serial numbers.
  • Why am I getting this error trying to write credit cards into sales orders?

    I am following the example in Knowledgebase article 85796 regarding how to add cards to an existing order. I just want to capture the card information as a zero dollar deposit. SalesOrderNo = "W123456" PaymentType = "MC/V" ccNo = "4111111111111111…
  • Unable to read line level data

    Hello I am trying to read data from SO_SalesOrderDetial i tried setting key value to read data for a given sales order i am able to get data using GetResultSet but i am not able to read values like price , ordered etc and when i am trying to use…
  • Error 26 : variable type invalid

    Hello i am trying to read data for each line in sales order and i am getting a error , i am not sure why i am getting this error cause the same code is working for few lines but not for few this is my code ##################################################################################################…
  • item price using boi in sage 100 /mass 90 /mass 200

    Hi i am trying to read item code, item description,and item price of all the items, i am able to read both item code and item description in an object but i am getting item price as null or empty string . can any one help me out on how to read a…
  • BOI IM Transaction Entry - Error CI_LineEntry_Header 'Missing or invalid Header'

    Running what should be a simple Transaction Entry test for BOI. I can create all the object I need, test for and create the Batch. Set Key values. But the call to SetKey is continually returning 0. Last Error Text is 'Missing or invalid Header' and…