I'm looking to modify a standard FM template - the one called Purchase Order. There are three key things I wish to achieve:
1) Add 3 new fields to the template, that calculate at the bottom.
2) 2 of those fields will have simply formulas applied to them to make the calculation
2) Allow the template to pull data from a tab deliminated .txt (?) inventory file. For instance; if one types the product code into left of the screen, template will grab the matching data from the .txt inventory file and fill in fields such as description, price etc.
That's about it....
Sample .txt product data file attached
screen shot of stock Purchase Order database attached
Priority and higher pricing will go to the bidder who does not send a generic service list PM. This job will lead to opportunity for future tweaks on the template also. Thanks in advance!