• VI Job for Inventory Adjustments

    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…
  • returned item shows as received on PO

    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…
  • RECEIPT OF GOODS VS P.O. VS COST DETAIL

    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…
  • RETURN AND ALLOCATIONS

    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…
  • Inventory Adjustments - Profit Margins

    Hi Everyone A purchase order was received in with a higher unit costs than it was supposed to be Sales orders were processed and updated Found mistake did a return of good and re-received at the correct unit costs How do I now fix the profit margins…
  • Physical Count Situation

    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…
  • ZERO COST WAREHOUSE?

    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…
  • AR Invoice Adjustment not reflected in GL

    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…
  • Receiving multiple purchase orders with one receipt

    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…
  • Goods Received incorrectly reflected in wrong Warehouse.

    Hi All, I had an issue with my receipt of goods entry... Basically the Goods entered as Received in Warehouse 008 but its balances is reflected in warehouse 001 in Inventory valuation report. What causes this and how do i rectified it?
  • Purchase order and invoice price discrepancy

    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.
  • Work Order Adjustments

    FormerMember
    FormerMember
    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…
  • Inventory receiving issues

    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…
  • How do I adjust inventory valuation for a certain item?

    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…
  • Check was unused by vendor but all invoices paid

    I recently took three checks to our local tax office to get registration on vehicles (five vehicles on each check). I got the registration costs from the tax office website. However, I was told that I had overpaid by over $500 dollars. Instead of giving…
  • Fixing Average Cost

    If I do not currently have any inventory for an item, do I need to wait until I do have inventory to fix? Found this on another topic: Typically, the only way to fix the average costs is to do an IM transaction entry to 0 out the quantity on hand…