Sage 100

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…

I want to Download in Excel (from Sage 100) an Accounts Receivable Open Invoice Report. The problem is that the reports that I found in the AR module shares excel columns, for example, the AR aging will share the customer name with the invoice number…

I'd like to pull posted AR invoices from each of our 5 companies and update a table daily. Can anyone tell me how to find/distinguish the data for each company? Any recomended procedure to pull this data to the table? Thanks for all responses!

Is there an ERD or easy way to identify the AR Invoice tables. We are using SQL Server as our database and trying to pull the daily invoices to a table. We currently have about 10 companies setup and need the data from all companies. Thanks

Hello I have several prepayments that where entered in the system and need to be applied to the corresponding invoice in AR Can someone walk me through that process?

We have some customers who are on credit hold. We require that they pay either a percentage of the order or the entire order before the items are shipped. How would we create an invoice from the sales order listing the items and their cost and then once…

i am trying to update a UDF in line level using script on a button click Dim count Set fso = CreateObject("Scripting.FileSystemObject") Set dict = CreateObject("Scripting.Dictionary") If (fso.FileExists("C:\XIDT\line.txt")) Then Set file = fso.OpenTextFile…

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…

Is there a way to change the ship to address on an already posted invoice without deleting and re-entering the whole invoice? I need to make the ship to match the other documents for an international shipment. Any insight would be helpful... I am leaning…

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…

I need some help wrapping my head around creating this AR Terms Code. This is what I need: Invoice dated 1st - 15th payable 15th following month Invoices 16th-31st payable 30th following month Thanks for any suggestion!

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 Everyone, I am attempting to put together this ODBC query against the Sage database, and I am trying to return values from the past year, specifically using this parameter: WHERE AR_InvoiceHistoryHeader.InvoiceDate > DATE_SUB(now(), INTERVAL…

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…

I am trying to figure out how to create a report that will show my sales tax by zip code or city. Either by adding a column to the Sale Tax Report already in Sage 100 ERP Accounts Receivable or by creating a new report. Does anyone have any suggestions…

Hello, I am creating AR_Invoice via BOI. We have Account Receivable Division check box unchecked. I assume ARDivisionNo$ is optional. Here is my code //Set the A/P Invoice Header record retVal = oARInvoice.nSetValue("InvoiceDate$", _invoiceDate…

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…

Hi there, We're trying to get Sage 100 Advanced set up to send our A/R invoices to customers via e-mail or FAX. The basics are up and running. However, it's common to need to include supporting documentation when sending an invoice. I can attach a file…

Hi All, Could you help check this issue. I use the sample company 'ABC' to testing sales invoice creation. But when I delete the invoice '0100057,the invoice still appears in the invoice list. And then try to select this deleted invoice to delete again…

Hi All , I am trying to post a Invoice that is not related to a Sales Order using the A/R Module >Invoice Data Entry . However when I post I get the following errors : A Customer number was found that is not on file . ( Customer is clearly…

How do I reverse an already posted invoice to a customer in Sage100? I believe I have to issue a credit memo but cannot seem to figure out how this is done.