Sage 100

Hi there, I hope you can help me. I created a job to import data for a positive inventory adjustment, and I need to specify the unit cost. We are using Scanforce multi-bin software, so we also need to specify the bin and lot. The issue is that the job…

I have a PO with returned item still showing as received. 15 ordered, 20 originally received, 5 returned, 15 invoiced The PO shows the goods receipts for the 20 and (5), GLs are debited and credited as expected and inventory is correct. However, the…

Hello everyone, I was wondering if it is possible to edit a PO quantity ordered in the lines tab without having to reverse the receipt of invoice. From everything I learned, I always thought we had to create a reverse receipt of invoice first, then…

What would be the best way to get around the issue of receiving items at the incorrect cost? The issue we're having is that the receivers are just receiving in the items with no knowledge of cost differences on the p.o. vs the invoice we receive from…

I don't work in shipping but I had a shipping question brought up to me. We have a customer that placed a rather large order. They notified us that they made a mistake and ordered too much of one item. To avoid a ton of work, I did a return of just the…

Hello everyone, I am trying to close old POs that weren't properly received previously. We have a PO that on PO Entry/Inquiry shows the line as ordered and invoiced, but not received so the PO is considered Back Ordered. When I go into Receipt of Goods…

There is a PO in my system where everything is completed, but it shows as a backorder and says ***over invoiced*** on the open po report. Any ideas on how to get this to a completed status? Thanks, Dan

Greetings! What do I do when there's an open purchase order and an invoice that's been entered through the Accounts Payable instead of linking it through the Purchase Order Receipt of Invoice Entry? The method I've used involves zeroing out the invoice…

Where can I find a detailed explanation of how Item Maintenance works and what each valuation does and setting up Units of Measure? We have a terrible habit of just copying what is done for other items that have been set up in the past. I want everyone…

I just want to bounce some thoughts around. We're a manufacturing and distribution company. We are trying to take into account how many boxes we use for packing our finished goods. These finished goods are sold to our intercompany via p.o and receipt…

Hey All, I saw this post https://www.sagecity.com/us/sage100_erp/f/sage-100-distribution-manufacturing-and-internet-modules/94349/you-cannot-proceed-with-unposted-data-in-physical-count-entry , but I want to elaborate a bit to see if I can find the…

USING SAGE 100 ADVANCED 2021. Is there a way to create a warehouse that does not apply any unit cost to an item? we want this new warehouse code to hold items that will eventually be replaced by the factory. so if we receive a container full of…

Hello, I posted an AR invoice to the wrong customer, so I went back in to Invoice Data Entry and adjusted the invoice to 0, using the same miscellaneous item codes. I then posted the invoice to the correct customer. The two GLs involved are only showing…

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…

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

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…

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…

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…

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…

In Sage 100c Advanced 2016, Updated a completion step of Work Order. Some items posted to scrap with all the cost and some items posted to inventory with no cost. Somehow the cost was all posted to scrap. Now if we complete other steps in the Work Order…

I have a PO that was invoiced at less than we received the goods in at. I cannot complete a return of goods as the product has already left as a finished good (zero on hand). How do I process the receipt of invoice in a manner that will allow the purchase…

We have two companies that buy and sell from each other. We use purchase orders and invoices to move inventory between the two companies. I accidently received a PO and paid the invoice to the second company. But, we never received any product from…

We are experiencing an issue with our Purchase Order receipts on one particular POO we have recently received. The PO was received, but never post ed the items to our inventory. Went back to review the PO, but it is now show zero items in it, but the…

We have the module Bill of materials, we typically receive an order from a customer for an item (Program) that has to be built. We create an invoice for that item (Program) and in a few days when we have enough orders to build the item (Program) it will…