• 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…
  • 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…
  • Serialized device floating in limbo.

    I was in the middle of Transferring two Serialized Devices from one Warehouse to another. While in the middle of this sage crashed. Now when I go back in the devices still say they are in the same warehouse but they are not available. How do I fix this…
  • Bad debt and write offs

    My question is what's the correct way to bad debt an inventory item? We have an item that we want to take out of inventory and put to bad debt. I have played different scenarios in my head but not sure which way is the proper way and which GL's it's going…
  • 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…
  • Price level bug?

    I don't know if anyone experienced this: I setup a price code for our product. with price level 1 being the heaviest discount, level 2 being the lesser discount and so forth. i applied the price code to our product lines. however i notice in the price…
  • How to revise G/L account?

    When I enter the purchase order, I s elect the standard order type as shown below. And the PO already has been issuing invoice and batch also has been run. So now the amount of PO shows as inventory G/L account. But it should be purchase G/L account…
  • How to add inventory to a vendor PO

    All, I am new to Sage 100 and have been impressed with it so far. I currently have an issue I have been wrangling for a bit now and would like to hear my options on the subject. I would like to know if there is a way to add inventory to a PO. So here…
  • Transferring FG inventory from one warehouse to another

    Hi! We have recently created a second warehouse in our system and are trying to find the most efficient/effective way to transfer the inventory in the system as well as physically. I know there is a transfer option in inventory management, but we are…
  • PO and mfg variance calculations (PPV)

    I'm trying to understand exactly what is in the the PPV amounts (and how calculated) on our Sage income statement so we understand the information reported, if the manual JE's are correct,a and if we need to change our processes. We have two GL accounts…
  • Serialized item on hand but not available.

    I am trying to assign a serial number that shows it is on hand, but when I try to assign it to the sales order, it is not available? How do I correct this? Sage 100 v.2017 v 5.40.1.0 Any suggestions on how to correct this would be appreciated.
  • Purchase Order for Tools, Supplies, and Non-Stock Items

    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…
  • How to append a Lot # when transferring from 1 Whs to another?

    To start off, we are on Sage 100c Advanced v2018.2 How can we append an original Lot # when transferring qty from 1 whs to another? Create PO for Qty = 100,000. ROG the full Qty 100,000 to an offsite warehouse ("OFF") with Lot # 12345. When when…
  • 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…
  • What is the best explanation of how OVERDIST (over distribution) tiers that are created using FIFO?

    I understand how negative OVERDIST tiers occur, but a bit fuzzy on how positive OVERDIST tiers occur. Is there a good write up that someone has done that explains this process for both myself and my clients?