Item ledger (cardex) f4111 info and purging

[ingiuk]

When i compare a branch/item/location record using p4111
more records are returned than doing a database sql query on the f4111 direct. what tables does the p4111 use apart from the f4111...need to purge old data away and replace with a summary transaction within the cardex.
many thanks

 

[mdalton]

I just would not do that. Move the data off to storage and query it as needed. Creating a summary record in the Cardex opens yourself up to bad mojo.