• 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…
  • 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…
  • COMMITTED ITEMS NOT ACTUALLY SHOWING ON ORDER

    Hey there I have an issue with an item showing that it is on sales order and its committed but we have no open sales orders with the item nor back orders. I'm also going to mention that we use multi bin and I can see that 7 are set in a warehouse but…
  • Reopen a Completed PO

    Is there a way to allow non-Admin Sage 100 users the ability to Re-Open Completed PO's? Quite often we get late Invoices or additional quantity received after the PO has automatically been changed to Completed status, due to 10% Completion rule or that…
  • 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…
  • Deleting Old Sales Orders

    We have hundreds, if not thousands of old quotes that had an expiration date of 12/31/5999. I would like to start deleting these, but don't want to have to go one by one. I tried a few of the utilities in a test account, but I'm not having any luck removing…
  • 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…
  • Sales Order / Back Order Updates

    Hope I am formatting this correctly. Running a back orders report for the month, I came across some inventory items that we for sure have in stock. Digging into the cause I found that data entry had manually entered some cancelled orders for one customer…
  • 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…