How to track inventory up to 12 months

[filemaker_project]

Hello,

Is there a way to have my Inventory stock keep track of orders and purchase orders for up to 1 year before not being in the on Purchase Order and Qty Sold displayed quantity.

Not sure how others deal with having to large of a quantity displayed after a year worth of orders and purchase orders reflecting the Qty on Hand on the Inventory module but I would like to have the transactions dissapear from the Inventory Info after a year worth of Orders and Purchase Orders that reflect the Qty on Hand.

Please let me know what is the best way to deal with keeping track of inventory for sold orders and purchase orders after a long period of time?

Thanks.

[qube99]

I'm no expert but perhaps a date range portal filter would do the job?