You can total all your minerals you have in stock then the total can be subtracted from the amounted needed to complete the order. You would have a calculation field or a summary field to compute totals. This information could then be displayed on the layout. A report is a layout designed to be printed, which you can print any layout.
Ah, the summary field was what I was after.
Sorry, still new at FileMaker.