Sage 100

 View Only
  • 1.  v2015 standard client is finally done counting the

    Posted 03-02-2017 09:57
    v2015 standard client is finally done counting their physical inventory (only took them two months this time, a remarkable improvement). We captured the physical file on 1/3/17 and the count will be updated as of 12/31/16. Is there any reliable report that can be used to value the physical as of 12/31/16 and be used for the book to physical $ adjustment. Is the inventory valuation report by period reliable? TIA


  • 2.  RE: v2015 standard client is finally done counting the

    Posted 03-02-2017 10:12
    Have they ever purged Inventory transactions?


  • 3.  RE: v2015 standard client is finally done counting the

    Posted 03-02-2017 10:27
    Nope


  • 4.  RE: v2015 standard client is finally done counting the

    Posted 03-02-2017 10:34
    You could construct something out of the IM Transaction History. There isn't really anything. The Inventory Valuation By Period only works under rare circumstances and I'm pretty sure this isn't one of them.


  • 5.  RE: v2015 standard client is finally done counting the

    Posted 03-02-2017 10:50
    Actually, I had to do that for them a couple years back because they forgot to freeze the inventory. Perhaps next year, we will copy the IM module at year end to use as a baseline.


  • 6.  RE: v2015 standard client is finally done counting the

    Posted 03-02-2017 10:56
    I've built a Crystal Report before. I'll try to find it.