Sage 100

How would I carry PO credit forward when the invoice received is for less than the original PO? It keeps closing invoices as I enter them when there should be a balance left for future invoices to be applied to. Please advise. Sage100 C Most of our…

Hi, I purchased the above mentioned course on Sage university but I was not able to access the material as the payment was pending. Also, I got a auto mail from sage informing that one of their sales person will contact us for payment part, but I…

Is there a way to Recalc Cost on a PO similar to the Recalc Price function on SO? We have many open POs in our system where we need to update line item cost to new vendor cost based on price increases. Those new vendor costs are uploaded to the SKU, so…

First off, our ultimate goal is to look at an Invoice in AR_InvoiceHistoryHeader and Detail and know what the Landed Cost is. The Purchase Order Module's History Files does a pretty good job of tracking Landed Cost History by Receipt Number. However,…

We regularly import products from overseas and prepay 100% of those purchase orders. Sometimes we end up changing items, leaving us with a credit with that vendor. They typically apply it as a credit on future purchase orders. What is the best practice…

We are network cabling contractors using Sage 100 with Job Cost and lost our Sage 100 support person. We have a CPA, but need someone for quarterly/year end closings. Located in Orange County, CA near John Wayne Airport. Any referrals would be appreciated…

Hello, I am very familiar on how to post intercompany transactions but not with intracompany. I am hoping someone can assist me. My business for privacy is called ABC. ABC has 3 locations, WV, KY, TN. We utilize the WO module to purchasing, including…

For some reason quite often when i do a receipt of goods invoice a few days later the invoice shows for $0 with lines "0" invoiced. I do multiple invoices in batches and i always make sure that the quantity being invoiced matches what we received and…

Hi everyone. I am wondering if there is any way to Un-Delete a PO. Have a PO, it is in PO History it is listed as a Deleted Order. is there any way it can be put back to Active/Open Status? Peter

Desire to attach PDF of Invoice paperwork to Invoice when Raw Materials are received. In P/O Receipt of Invoice, there is no Memo icon for Invoice Number. Per Sage Support, you can not create a Memo for the Invoice while in P/O and it flow through…

Hello all! I'm working on a script to auto approve batches but I am running into some issues. I looked through the BOI course and there is an example in there that updates the SalesOrder so I adapted my code from that. I'm not sure if I'm setting it…

Hi, I'm trying to figure out why the button to enter multiple purchase orders against one receipt in the receipt of goods is now showing, I've followed the help files and made sure the four fields, dealing with ship via, tax schedule, etc... were…

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…

Hi guys We posted a receipt of invoice batch earlier and some items seem to have updated to item maintenance and other items have not. Some items are showing as received in Receipt of invoice but not showing on IM. We ran a rebuild for the PO and…

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…

Working with Sage 100c Advanced v2019 and need to clean up Purchase Clearing Report where some PO's on report have Misc Charges on them, they go back years. Example: Qty Ordered = 7.00 Qty Received = 0.00 (Can't receive Qty on a Charge) Qty Invoiced…

We have a vendor that does welding for us and we pay him by unit, i.e 20 welds. 1- I have created weld under Miscellaneous items with allow in PO and BOM 2- When I try to create a PO for the vendor, it does not allow me to enter quantity. 3- In…

Recently was working on a large project to change the Standard Unit of Measure for thousands of SKUs in our company. The change necessitated that we change the thousands of open sales orders and purchase orders and work orders that were using these SKUs…

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…

Sage 100 c - We noticed on an inventory item in inventory inquiry that the amount on PO was incorrect...meaning that when we looked at the open POs for this item, they totaled 7 on order, but the inquiry screen is showing 24 on order. In the past in MAS200…

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…

Hi, I searched this question, and found some answers but they were all from several years ago. I want to be sure I'm getting current information, in case anything's changed. My receiver mistakenly created two receipts of goods. Since he hadn't updated…

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…

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…