Fields and calcs
FMP 11 advanced
To give you a better idea of what’s going on, here are the field calculations that we use now.
Part number, Part Name, sell cost, uom and loc are not relevant here.
Quanity on hand : Calculation= (SumItem+Returned)-(SUM Used+Qty Change)
Cycle counted: is a number field for manual entry.
Inventory adjusted: Calculation = (Cycle Counted Amount-Quantity On Hand)
Returned: is a number field for manual entry.
__Davids qty Total: Calculation =Quantity On Hand * SellCOST
What I need to do is have FMP automaticlly put the result of inventory adjusted in the returns field.