E9.2 F4111 - Pull Last Date

[richchipper]

We have 300 branch plants set up and I'm looking for some ways to organize them. A couple of categories we'd like to have are "Never Used" and "Dead". Is there any place where dates are stored for last used in the Accounting Ledger and/or Inventory Ledger versus trying to go through them one by one?

 

[DaveWagoner]

I'd write a "quick" sql (depending on how big your ledgers are and how beefy your server is) to get this done in one fell swoop. Branch Plant, Last Accounting Ledger Date, and Last Inventory Ledger Date. Run whatever analysis you want after pulling it into excel.