Browse By Tags

  • 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…
  • When Confirming Goods on a POP Return, can we be able to ‘choose’ which stock is returned to the Supplier. [Currently only possible if the stock item is made traceable and Actual costing method is used.]

    With Purchase Order Processing it is quite common for the stock to be invoiced before receiving it, therefore in this type of example once the stock is received it becomes part of the overall stock system. If a mistake has been made, or some goods are…
  • Sage 50c rounding off the Unit Cost/Amount inconsistently between different Journals?

    Hello, We're using Sage 50c Premium ver. 2021 and have set up our inventory ledger based on FIFO and not allowing negative inventory. For one particular "Item ABC", we purchased 200 units at USD 1.1 each, and at the exchange rate of 1.2607. The Inventory…
  • Changing the FIFO dates in X3. Manually.

    Currently when product is received into X3 to any location it is tagged with a receipt date. This is the date that travels with the product and drives the FIFO order for each product. Is there a way to manually FIFO inventory to give more versatility…
  • Using/Understanding FIFO

    It seems that X3 defaults to some form of FIFO. Is there any documentation that goes into detail how to control this feature? A specific example of what we are trying to do that relates to full pallet product pulling. We have X3 set up to pull full…
  • 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…
  • Negative Tier

    Hello All , I have a problem maybe someone can assist : ) We post SO to product that has no PO in yet . PO is delayed to paperwork. This causes a negative qty. After the PO is posted the qty is 0 however the item is still in Negative Tier report.…
  • Purchase Price Variance for FIFO?

    I understand that when using FIFO, any adjustments resulting to PPV is posted towards the inventory account when the quantity is still in stock. How can we address a requirement to have the variance posted towards a PPV account (not inventory, so it does…
  • 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?
  • Stocks et service 101 avec Sage 50 Edition Canadienne

    Certains utilisateurs pourraient avoir des difficultés à démarrer avec Stocks et Services dans Sage 50. Ce blogue passera en revue certaines informations de base de ce module. Le module de Stocks et services est utilisé souvent pour faire le suivi…
  • Inventory and Services 101 on Sage 50 Canadian Edition

    Some users might have a hard time getting started with Inventory and Services module in Sage 50. Today’s blog will review basic some information about that module. Inventory and services module is used more commonly to keep track of physical items…
  • RE: Inventory Costing

    I personally use FIFO and have no problem with this method. In the USA, If you are changing your costing method, you must get permission from the Internal Revenue Service. I would urge you to check with your Government Tax Office and make sure this…