AnsweredAssumed Answered

Fields and calcs

Question asked by DavidDicken on Oct 16, 2013
Latest reply on Oct 16, 2013 by philmodjunk

Title

Fields and calcs

Post

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.  

      

Fields.png

Outcomes