Concerns on growing uncontrollable of Transaction Ledger for Inventory
Hello Phil, I've a question on managing inventory using transaction 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.