Sage 100

I am trying to add and edit customers. I can successfully edit a record where the customer already exists. I get a 1 return from nWrite. However, when I am adding a new record I get a 0 return. I checked LastMsg and nothing is set. I am trying to figure…

I'm having trouble trying to figure out how to access Cash Receipts History, any examples anyone can share? I'm using .Net Sage100.ObjectManagement. Thanks

I'm trying to add a few fields into a Sales Order Entry screen - Job Address, Name, Country, Zip, City, State - from the Job Cost module. I remember there was a way to kind of "cheat" it by linking them as business objects into a UDF or something like…

Hey Guys, I am currently trying to automatically create Sales Orders via a different application and that application after creating the Sales Order opens the Sales Order Entry UI. I Am successfull in opening the UI, But What Problem i face is it opens…

I am using the code below to get the specific sales order invoice data in my application. I need to get the selected "Lot number" for the line item in this order. (attached image). How should I get the lot value in the code from this sales order invoice…

I am using the code below to get the specific sales order invoice data in my application. I need to get the selected "Lot number" for the line item in this order. (attached image). How should I get the lot value in the code from this sales order invoice…

I am using the code below to get the specific sales order invoice data in my application. I need to get the selected "Lot number" for the line item in this order. (attached image). How should I get the lot value in the code from this sales order invoice…

Dear Support Team, I hope this message finds you well. I am currently in the process of integrating Sage 100 APIs into our system and require access to the "Returns all Countries" API as outlined in the Sage 100 documentation. To proceed, I understand…

We have several customized screens for sales order, customer inquiry, invoice history inquiry, and inventory inquiry. The other day I went in looking at one of the screens and I noticed my settings had changed. We had hidden any sections that showed unit…

I've made 63 entries with the wrong posting date, but I already closed out (posted) my batch yesterday. The only way I know how to fix that is to create a credit invoice for each one and then re-entering all the invoices with a .1 or an 'a' or something…

Can anyone give me a quick explanation of how to use break points in the debugger. I can't seem to find any examples anywhere.

With identical UDF names in both tables, the original value set into the SO Header UDF via a ColumnPostValidate script from a standard field works to flow the value to SO History Header, but subsequent successful updates directly to that SO Header UDF…

I hope this is something easy that I'm overlooking. I'm looking up an invoice in the AP_OpenInvoice table that I know exists. I have confirmed that I'm passing the correct vendor division, number, and invoice number. But I'm getting a 0 return value.…

I have encountered a strange issue with a button script that enters data into a UDT. I have been using this script in testing for about a month now and it hasn't had any issues until yesterday - even after a server restart. The first time clicking this…

Sage 100 Code: CI_ValGrpPORequired, Message: A purchase order number is required. when calling nSetValue with parameters InvoiceNo$, {InvoiceNumber} Could anyone please help me with the meaning of the error code CI_ValGrpPORequired. I have made…

Hello, I was hoping to get some advice on scripting the BOI via a Button script that was placed on S/O Invoice Data Entry that would act as a "Quick Tax Credit" button. We use a third party cloud vendor to calculate our taxes but that shouldn't affect…

In Customer Maintenance's Invoice tab I am wanting to allow accounting to have the ability to edit the Comment field from the AR_OpenInvoice table. Since this isn't the history table, it wouldn't affect the comment line for invoice history reprints, so…

Hello everyone, I'm stuck on a problem. I wrote a script to run from a button on the address tab of Purchase Order Entry. I made a field to collect a Sales Order number that the user types in the clicks the button to generate the ship to address from…

Hello, getting an error: Invalid or missing header on the code below- can anyone provide a working example of creating a purchase order in BOI? using (var sySession = new MasSession(homePath)) { sySession.InitSession(sessionLogon); CI.ColumnNames…

I've noticed that we have just over 14,000 records in the SO_SalesOrderHistoryDetail table where the SalesOrderNo field is null. This is causing some issues with trying to do a copy into a MySQL database due to the Primary Key not accepting null values…

Hi Team, Please, help me with this scenario. Scenario: Order is already created in the ERP Using BOI, write an Invoice to ERP that Integrates into an Order (The invoice will contain the Order document number(DO_Piece)). a) This invoice can also…

Hi Guys So we recently upgraded to Sage 2023. Since the upgrade some users have being reporting that the Customer Last purchase history (Red Binoculars) is not populating for them on sales order. I first thought it might have been a permissions issue…

I created the following script to populate ShipWeight$ in the CI_Item table when either of 2 UDF's are changed. I am now receiving an error 88 type mismatch (error window below). Any thoughts? START OF CODE Dim retVal Dim cpwgt Dim cpwgtstr Dim…

I am writing an API in C#.net, that POSTs sales order entries to Sage 100, using BOI. I am using much of the same code that I've used for other integration projects with success. The client for this project is upgrading to Sage 100 2022 Premium- and testing…

Experiencing an issue where my login crashes while no one else's crashes sage. Works fine on other computers. Made new login account copying my own and it crashes too. Issue only starting happening this morning. Worked just fine yesterday. I removed…