Sage 100

We recently updated our Sage 100 version from 2018 to 2022 and have been having issues processing credit cards (via Paya Exchange) from the "S/O Invoice Data Entry" program. We have no trouble adding the Credit Card info at the *Sales Order Entry* program…

The total is displaying as zero in Invoice Data entry I've written the script for the extension amount as follows. Can you pls clarify which column should be used to store the total?

Hi Team, Can someone kindly help me with displaying the invoices in the customer maintenance section? It appears in the data entry for invoices but not in the section for customer maintenance.

Hello All, I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…

I am using Sage 100 and invoicing in the Sales Order module. When I use a kit, no cost shows up, not on the invoice screen or when I print the invoice. However, if I act like I am going to post the batch (but don't actually post/update it) and go back…

hi, Greetings !!! I want c # sample code through which i can create invoice entry through object matrix dll for sage 100

We created an invoice through sales order and charged tax. The customer just sent us a payment along with a sales exemption form. Now I need to reverse the sales tax on the invoice. How do I do this?

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…

Hello I am using VI to import invoices into invoce date entry. The import works fine-but when I hit print in order to post, it prints and then runs into an error. The error logs only lists the invoice numbers as the error. I dont know what the system…

Is there a way to get Sage 100 to Display the Value of the Items in each box when doing Shipping Date Entry? This would be for internal processing only. We're able to print out a packing list per box and indicate its contents, but we still need to manually…

I am not well versed in scripting, but I know it can do a lot of wonderful things. I'm hoping this will be possible. I have a customer that creates credit memos but they do not always apply them. They would like a way to checking their customer's invoices…

I know you can put multiple sales orders on one invoice for a customer but from what I can tell, if they have multiple shipping addresses, you cannot combine them on one invoice?

I understand how to associate the customers to the national accounts but when I try to invoice, I can only select sales orders that are under the same customer. I want to select multiple customer orders and place them on one invoice to the national company…

Hello, I have tried looking though out the forums for a way to select a batch number to use when trying to import invoices into Sage 100. What I have found was to use SelectBatch and pass the batch number I want to use as the parameter, but when I do…

Questions: 1) Please suggest how can we create AP invoice with different dates for details within and success import their via VI module? 2) Please suggest how can we add lines (details) to existing AP invoice via VI module? Description: Our…

One of my users brought me an invoice that has an invoice total of 0. However, the line item total on the invoice is 1441. The customer is on the nontaxable schedule. So, the Invoice subtotal would normally be 1441, Sales tax 0 and Invoice total 1441…

For years, we have processed shipments by keying data into Invoice Data Entry and bypassing Shipping Data entry. It works fine, but it does NOT move orders (or show inventory commitments) until the invoice batch is updated. If you do an inquiry on a…

When pulling the information in Accounts Receivable - Invoice Data Entry, I'm able to put in the terms under 'Terms Code' and it automatically generates a due date in the box above it. But when invoices are printed, the due date is nowhere to be found…

Hello, I have a customer who wants to have the Tax appear as the line item /TAX on an invoice. Here is what I'm inserting after the items get added: retVal = oSOInvoice.oLines.nAddLine() retVal = oSOInvoice.oLines.nSetValue("ItemCode$", "/TAX…

I am trying to hide 5 fields on the AR Invoice Data Entry Lines screen but nothing seems to work. The fields are visible by default in the grid. The script event is Post Column Validate on a field in the Header tab. Can anyone point out what I am…

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…