Sage 100

I am a new controller to the company, and I have very little experience with Sage 100. We need a solution to send a customer one invoice (containing multiple jobs), and only show a summary as if it were one job. Our business is in manufacturing, and…

Having added a UDF to the AR Invoice history Called Enhatch order Id. When trying to print a copy of an invoice from this record the UDF does not print and it has been added to the form. Any ideas as to what link I am missing? To see the invoice printout…

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…

Hello , We are new to using Sage 100 and have a few questions . After our sales people process a sales order we then go into Shipping data entry and then print the invoice. At the end of the day , we then update the register. My question is , how…

I'm in search of a consultant that can help audit our invoicing process and make recommendations on how we can streamline it and make it more efficient. It is extremely painful and there has to be a better way. Can anyone make a recommendation for a consultant…

Our developers have written an interface to pull and push AR customer data. Invoices (IN) are not a problem, but prepaid invoices (PP) produce no results and no errors. I'm pasting the code below. Any ideas? using System; using System.Collections.Generic;…

I'm trying to set invoice object to a single record and not having much luck. What I'm trying: oSS.nSetProgram(oSS.nLookupTask("AR_InvoiceHistoryInquiry_ui")) Dim oInvoices As Object = oScript.NewObject("AR_InvoiceHistoryInquiry_svc", oSS) oInvoices…

Sage 100 Advanced 2018. I have a script designed to fire on AR Invoice Header PreWrite: If a BillTo account is specified in Invoice Header it should confirm the checkbox UDF_BTST is checked in AR_Customer, and if not should displays a message reminding…

I go to cash receipts entry and I double click. I created a new batch I click accept, then I created a new deposit number I type the total deposit amount and click accept, then I look for the customer number hit tab then I type check# then I type the…

Hello Everyone I am trying to update UDF in sales order line using script, i am not getting any error but it's not working i am adding the the code that i am using any kind of help will be really great Thanks ____________________________________________________________________________________________________________…

Hello I am trying to edit a AR_invoice using BOI in VB.net i have tried to set key but no matter what i try i am getting some kind of error can anyone please help me out on how to set key for a ar_invoice that code i used : If Not (CBool(ar_invoiceObject…

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…

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

hello, i am trying to read data("SO Line" line level data for a sales order) from the grid to a vbscript but i am only able to access data of selected line ..... can any one help me out in how i can read the data from the gird( read all lines…

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…

Hello, I am able to create AR Invoice using BOI, but I am not able to set the 'InvoiceDate$' to past date. No error being returned, but the date is set to current date. Not sure what I am doing wrong. Here is my code, string _invoiceDate = '20170105…

Hello all, I have a button script on repetitive invoice header which will pulls out a UDT. But what I want to do is not just pulls out the UDT, (cause it will show all the datas) but also filter the UDT values that shows only for this particular customer…

Hello, Need help with setting line amount for AR Invoice. retVal = oARInvoice.oLines.nAddLine(); retVal = oARInvoice.oLines.nSetValue("ItemCode$", itemCode); retVal = oARInvoice.oLines.nSetValue("Amount", amount); <--- Not sure what is the correct…