Sage 100

is there a way to export the line details on current open AR invoices. When I use Business insights the current open AR invoices just give the balance of the invoice not the line detail for those invoices. If I use invoice history I get more then open…

We use UDFs on our Invoices to populate fields with both product codes and lot numbers. If those items are already part of the products invoiced, all is good. If we have to manually enter product codes or lot numbers, we have a weird issue. I'll try to…

Does Sage 100 have the functionality to incorporate invoice and PO approval work flow without 3rd party software or add-in?

Hello, I am trying to put together a report for tax purposes and am not confident I am pulling paid invoices correctly. My initial thought was that all invoices in the ar_invoicehistoryheader table were paid, but I was told that these invoices are…

Hello everyone, I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions: Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…

Hello All! Sage 2019 ERP.......We have used Paperless office forever and had relatively no issues but I fear we are not using it to it's ability (like most of this product). I'm wondering if I can do the following: I have a customer number in our system…

Hi We have a requirement, where when a new invoice is getting entered in AP, using a VBScript copy the Invoice Date to a new UDF. I did try to put the same using the Post Validate event on the Invoice Date, but it's not copying the data into the new…

We have recently experienced a 10 second lag when trying to pull up an invoice from a customer invoice history. It used to open immediately, however now it takes at least 10 seconds. Has anyone else noticed this or know of a fix?

I am not sure why when I run the VI export job, the tax amount from SO_InvoiceDetail appears to be 0 in the exported result file. All other values are being exported correctly. I have also check ed manually in the sales orders and invoices that the tax…

Our invoice has a field that doesn't show prices on items that have a markup. I would like to be able to have the new item prices (with markups) printed on the invoice. How can I create a field for this? Thank you

Is there an easy way to have customer invoices carbon copied (or blind carbon copied) to the salesperson when we use Paperless Office to send them to the customer? It seems like the only way is to set them all up as an additional e-mail address in Paperless…

I’m new to Sage 100. We’re running V 4.50.7.0. I am trying to find where I can change the logo on the invoices and PO’s. I’ve searched through Sage in “Setup”, “Paperless Office”, “AR” & “PO” and can’t find the forms anywhere. Can someone point this newby…

We have a number of customers who require their item# to print on the invoice and packing slip and I'm running into performance issues when trying to get a customized SO Invoice Print form to work. I've added those customer specific item #s to the IM_AliasItem…

Has anyone ever retrieved values from the AR_InvoiceHistory Header & Detail tables from inside a vb script? At the end of the day I am trying to duplicate the logic behind the "Copy From" button on the sales order header screen so that when a user creates…