I am trying to create a second FlowField on the Item table which is exactly the same as the Inventory (Field No. 68) field except it will not sum posted returns in the item ledger table.
So the logic would be "Sum everything in the Item Ledger table where the Location Code IS NOT RETURNS). RETURNS is a location we created for returns.
Is there any way of creating this flowfield?
Thank you,
Leo
0
Comments
Then it is better to create some function which will calculate what you want and display on your form like in any statistic form (sales or puchase document).
What the real question here is, is it possible for me to use "NOT EQUAL TO" logic in the CalcFormula field?
Create a boolean field in the location table name it "Return Location". Put a check mark on the location which you named 'RETURNS'.
It will not create any problem in calcFormula and will also resolve the issue if you want to change the return location to some other location
Ritesh K Singh
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n