Sage 100

On sales order invoice items can successfully use BOI to retrieve the SO_Invoice items, and for each item access the lines, however have not been able to collect item serial numbers for each line. For reference a screen capture showing these serial numbers…

I have been trying to import invoices from one vendor through the visual integrator, I can pull up the invoices in vendor maintenance in accounts payable but the transactions are not posted to the ledger accounts. I visited invoice register to post but…

Hi, I'm trying to write a code that gets all the invoices which were fully paid. My idea was to take all the invoice and remove all the open invoices from "AP_OpenInvoice". But, I see invoices in that tables that have 0 balance. So probsbly it doesn…

Hi, I run a net sales report from AR explore=>customer history invoices view. I use the invoice total minus sales tax, which gives me the net sales for that period. However, this number does not tie my income statement number. My June net sales total…

I know there are several posts about adding a line to an invoice to charge a fee. I've modified a script I found either here or in a Sage scripting class, but for some reason, I can't get it to work this time. When I put it on the Pre-Write event, it…

I have discovered that I have some invoices that have been paid, but the invoice is no longer showing up in transactions or history. The payment is there though. I'm not sure what happened but it puts my expense GLs out of balance. What could have happened…

Hello, Is there a way to show which PO's that have been received in are missing an invoice? We just switched over from Sage 50 and when the warehouse would receive material in, they would check off the box "waiting on bill". That way I could then just…

Hello, We are having an issue with our invoices not closing out because the actual kit is marked as 'backordered' as opposed to 'shipped'. However, all components of the kit have shipped. For example, the KIT named ABC-KIT has 3 components: ABC…

Hello, We are having some issues with a miscellaneous charge item we made for a small order fee for our sales orders. Currently I have a script in SO_Header that controls who gets the small order fee. The pickers once they know that the order is completely…

A unique printing problem just occurred. We have multiple companies set up. For one of them, all of a sudden we cannot print invoices. The printer selection drop down is grayed out. It is set to a printer that is not at the location of the company. (It…

I have a VI Job that imports sales order invoices into a batch. I have scripting that does some zip code validations and then uses scripting to interact with 3rd party integration buttons that are installed (Vertex tax software). The scripts work perfectly…

Hello everyone, I'd greatly appreciate help with generating a total revenue report for all customers within a certain date range. I've tried using the "Revenue by Customer" report and wasn't successful. I wasn't allowed to select all. I've tried…

Our company was just served with a subpoena that is requiring us to produce a very large number of old invoices. It appears our customer is suing one of their customers and the entity being sued is requesting invoices from a several year period for certain…

When opening AP > Check Printing & Electronic Payment > Invoice Payment Selection we are expecting to see many more invoices available in the selection list. We select the following options: We see about 25 invoices listed when we click select. However…

We do service work that in some instances calls for a "fixed" price per job. We will bill for the total cost of the project on one line item. We add additional items to the SO for costing purposes. Does anyone know of a way to suppress the print on the…

I'm attempting to import an invoice using VI import and encountering a "HS Record Invalid or Write Failed. The Vendor Number is Required" condition. I've confirmed that the Vendor record exists but it continues to fail on the import. This error also…

Why is it that I have had some customers get invoiced twice in a batch in shipping data entry? Steps that I do: Scan sales order into Scan Force Scan items and send data to Shipping Data Entry Wait a little bit for the data to send over Scan…

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…

Our sales department is trying to iron out a good process for backorders on sales order whether anticipated or unanticipated. Without knowing the accounting side of Sage I have come to a small bump in the process. When items on a sales order are moved…

Is there a way to assign form codes (invoices/picking sheets mainly) to different customers or customer types? We're considering upgrading to Sage 100 2016 and am wondering if it is a feature. I have seen some comments that it's available in other Sage…

Hello, I'm inserting invoices for a client and they have requested that they all go into the same batch. I can't figure out how to create a new batch and keep using it. The best I can come up with is creating a new batch for each invoice. I pull…

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…

I am running a COGS report for the week ending 4/15/16; however, not all of my invoices are coming up. I verified that one particular invoice in question was correctly posted in that time period, and the items are allocated to the correct GL accounts…

I just expanded the item code length to 30 characters. Now none of the item codes, descriptions, quantity, etc are showing on our Sales Orders and Invoices. We are running MAS 200 version 4.50.7.0 Any help would be greatly appreciated as we need to get…

This may be a dumb question, but emailing my invoices have been working terrific and have not had a problem with it at all and was just stuck on one thing. I am having trouble with one email address that keeps getting sent back to me as Undelivered Mail…