• Purchase return in Weighted Average & FIFO Inventory Methods

    Hello to all, Have a question regarding Weighted Average Cost and FIFO when returning purchases to vendor 1- Weighted Average Cost we have following purchase: 10 unit @ $20 & 5 unit @ $15 so average cost per unit is $ 18.33 = (10*20)+(5*15)/15 after that…
  • Inventory adjustments and return of goods

    Greetings everyone, I'm new to the community and have been lurking for a bit on subjects that I'm unaware of. I decided to register and stick to the community. Welcome! Before my time, some of the books were a complete mess. We are slowly correcting…
  • Old FIFO tier is stuck. What causes this? Can I see details?

    I have a client with an item that has 2 FIFO tiers: 1 from 2013 with 4 on hand (original qty of 8 when it came from PO) & 1 from 2016 with 5 on hand (original qty of 7 when it came from PO). Total on hand is correct, but they have had a bunch of POs…
  • Inventory value with zero quantity using FIFO

    Note: Current version is 4.4, going to Sage 2015 live this weekend. This is regarding items with all IM_ItemCost records having zero quantity (meaning, Negative cost tiers, if any, have been applied), yet one of the records has and extended value cost…
  • 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?