Sage 100

When the Open Purchase Order Report is run, the report shows backorders on lines that have future dates. This occurs on multiple line PO's with deliveries over a period of time. The required quantity shows up as a backordered quantity even though it has…

Is it possible to create purchase order from a back order? Tried it earlier today & got the following error message. 'The order type Back Order, has not been selected as a default setting at the Sales Order Type to Generate From field in Auto Generate…

We usually do receipt of invoice first and then receive the goods separately. When we receive an invoice, we have a miscellaneous field for commission that is due to our vendor (/Comm) going to a specific GL account. I made a mistake when receiving…

We have products that we purchase from multiple vendors. We have the Vendor codes and descriptions set up as Vendor Alias' in Item maintenance. When we make a PO for a vendor and enter an item that has multiple Alias codes, it will actually print out…

"Invoice History Printing" let's you reprint invoices. Is there an equivalent tool for Purchase Orders? We are an importer. We send the original purchase order to our vendor overseas. Once the goods ship, we add the container number as a comment on…

We are on version 2016. Does anyone know in later versions does this 'Copy From' functionality update the vendor pricing when the vendor code is changed after copy? In our version the copied pricing remains the same even if vendor code is updated.

Hello all, I know that the "PO Number" field within Sales Order Entry is used for Auto-generating PO's from Sales Orders and creating drop ship PO's from a Sales Order, but I wanted to know if it has any other purpose? I wanted to use this field for…

Hello all, I am trying to find a way to solve an issue that I have with how the Quantity Available field is displayed in Item Inquiry. It's kind of a difficult issue to explain but I'll try my best here: Lets say I have 300pcs of an item On Hand.…

Hello, I am trying to include I my purchase order the amount of the tax for my purchase, any idea how it work. I am buying sometimes items that are taxable and in order to match my vendor invoice and my PO is to include in the amount of sale tax…

I have a customer that is being charged a restocking fee by his vendor in order to return goods. I tried to set up a misc. charge *RESTOCK, but I am unable to enter this as a negative number. There doesn't seem to be anything in the kb or forums. What…

I want to know what is the right way to make purchase orders (or equivalent entry) for items that aren't going to be sold like tools, equipment, machine, and supplies. Is a PO the correct entry for this? I do not think it is appropriate to receive these…

I have a customer that wants to the line comments in Purchase Order. They are thinking of buying GetX by xkzero. Does anyone have an opinions or experience that could give me some information on that idea? Thanks, Sidney Kay Wells

SAGE 100 - Purchase Order Receipt We are using Scanforce to receive Purchase Orders. At times we will have two unloaders both using their own login to enter the receipt of goods for the items they unload. The PO is entered using the Freight Amount option…

I run an open PO report each week. My problem is that it shows PO's that items have been received but just not invoiced. For example, the part shows ordered and received but because it hasn't been invoiced yet, the PO is still open. I am okay with that…

The back order fill report included drop ship line items from sales orders. It would seem best to exclude drop ship as those lines will not be filled from the warehouse. Rich Garrett DSG, Inc.

How does one correct an item received at the wrong price and billed at a cheaper price? The item cannot be returned as it has been used from inventory. Example: Item 1234 received at 1.80 ea, but billed at 1.65 ea.

Hi. I have a drop ship PO that was invoiced at a higher value than what the PO states. It is a freight issue, however even when I add the freight to the open PO, it still does not close. I'm wondering if this is because the line items show as special…

A client has a great deal of drop ship purchase orders that are not purging and I found out that the the system requires that the status must show completed and the completed date be populated before the purchase order can be purged. What step sends…

Hi everyone, We are having an issue making a connection between an outside processing PO and the work order.This is what we are currently doing: (1) Make a sales order for part Y (which is part X plus an outside vendor processing step (i.e. painting…

Is there a way to print the Receipt of Goods Entry and Receipt of Goods Register without showing the unit costs? They would just default to what is on the PO without letting the user see the costs?

Most of my vendors give discounts after a specific dollar threshold (like 20% off on orders of $500) but I can't find a way to set that up in Sage 100 Advance 2017. Does anyone know how to do this? It looks like someone asked about this three years ago…

Client just noticed that if you create a new purchase order by copying from purchase order history that the g/l account assigned for a * item defaults to the default from setup options not from the actual purchase order copied. Seems logical to me that…

Hello. I hope all is well. We have multilevel BOM's defined as a KIT type in the BOM system. We wanted the ability to create a sales order for a manufactured item that consists of several levels of BOM's. The reason we went with the kit type is that…

We frequently generate Purchase Orders from Sales Orders - but when I use the Open Purchase Order report and look up a PO I know for a fact is linked to a SO, it does not list the SO. I see in Crystal Reports the Open Purchase Order Report should, there…

The purchase order had the wrong vendor. We received goods against the PO. Then we realized the error. I did a return of goods so that the Vendor Name could be correct. When that was done, I went back in to re-receive the goods. The line items are…