• Reports not matching and Database Utilities tool not working

    I am having an issue with inventory reports not matching, and showing false negative quantities. The inventory quantity report will sometimes show negative Pending Sales Order quantities, and currently I am seeing negative quantities for some items only…
  • Fix Inventory count without adjustments?

    FormerMember
    FormerMember
    I realize this question may be very similar to others, I did look around though the forums... the answers to me didn't seem like they were what I was looking for, but I'm not an accountant in any stretch and started using Sage 3 weeks ago so please bear…
  • Inventory Variance and Discrepancy between Balance sheet GL account and Summary

    Hi all, I have a question regarding inventory variance that appeared after correcting inventory location in a purchase invoice. Instead to take out an inventory item from one location and put in to other the system created a huge inventory variance entries…
  • RE: Fix incorrect item cost due to inventory going negative

    If this was a blog post, I would title it 'Negative Inventory is Mostly Evil'. So first, this advice : 1. Talk to an accountant about the implications of switching to FIFO from Weighted Average Cost (if you haven't). 2. Make every effort to get ready…
  • RE: why/when would you allow negative inventory be useful

    "...presumably the purchase invoice is adjusted when the actual invoice is received ?" If you use the (minimal!) functionality of un-checking that an invoice is received, for receiving items before invoice, then you would adjust the purchase to put…
  • RE: Negative Inventory, using average cost valuation

    Hi Kirk, This was discussed at length in this post: http://sagecity.na.sage.com/support_communities/sage_50_accounting_ca/f/162/p/70218/213573.aspx#213573 To answer your questions: 1) Average costing of sales invoices works the same when using…