AnsweredAssumed Answered

Concerns on growing uncontrollable of Transaction Ledger for Inventory

Question asked by henryhu91 on Nov 5, 2013
Latest reply on Nov 5, 2013 by philmodjunk

Title

Concerns on growing uncontrollable of Transaction Ledger for Inventory

Post

     Hello Phil, I've a question on managing inventory using transaction ledger 

Managing Inventory using a Transactions Ledger

     I've been testing out and using the idea in my database. I'm concerned about having the transaction table growing so big and take long time to load up for users to use. 
     I'm tracking my parts quantity with even when parts are on the way (Pending). so I take me 4 records at least to process one part. 
     from when it gets Order(Pending), Receive from Order, Ship to different location (Pending), Receive from Shipping.
     can you give me any thought on it? I'm using FM12 Pro advanced and hosting my db on the server with FMS12.

     Thank you 

Outcomes