Hi,
Trying to build out a GI and needing some help on an IF statement.
Here’s the scenario.
If Qty in APTran more than 0 (red check), it will return data Inventory acc ID (yellow checks) else will return AP Acc ID (Blue Check).
So, here is my formula:
Receipt Account=IIf( [APTran.Qty]>0,[InventoryItem.InvtAcctID], [APTran.AccountID])
and when applied it on Receipt Account field, it revert to “something else” value which shown above did not return as well as they taken individually.
Need your advice on this problem.
Thank you in advance.
