Sage 100

v2017 Adv - Physical inventory. Does anyone have any best practices for computing the book to physical in Sage - especially when it takes two and a half months to do the physical count roll up (don't ask). So now, we are ready to update the count, then run some report as of 12/31 to get a valuation so that we can do a final adjustment to balance the GL to the valuation report. is the IM trial balance ""fairly"" accurate when you dial it be two months? What reports do others use to balance the valuation to the GL? TIA

Always use the same date for updating the physical count, as you used when you froze the inventory. Yes, the Inventory Trial Balance Report for the 12/31/2017 date should provide valid balancing to the General Ledger. As a side note, to be sure you are not having any balancing issues... the Current Inventory Trial Balance should balance to the current Inventory Valuation Report (or use a future TB date of 12/31/2018). If you see significant differences between the TB And the Valuation Report... well, then you have other challenges.