By using this website, you agree to our Terms of Use (click here)
My goal is to get the following result in my GI, i am trying to do an Aging Inventory report but I have a field that is 0-30 Days (DETAIL): and I have the following
=IIf( DateDiff( 'd', [POReceiptLine.ReceiptDate], Today() )>0 and DateDiff( 'd', [POReceiptLine.ReceiptDate], Today() )<31,SUM(IIf( [POReceiptLine.POType]='RO', -[POReceiptLine.ExtCost], [POReceiptLine.ExtCost]), 0))
But the problem that I have is that I need the Sum for this [POReceiptLine.ExtCost], I tried to use the following sentence but It show me and error , Could please some one help me to see how I can get the Sum ?
=IIf( DateDiff( 'd', [POReceiptLine.ReceiptDate], Today() )>0 and DateDiff( 'd', [POReceiptLine.ReceiptDate], Today() )<31,SUM(IIf( [POReceiptLine.POType]='RO', -[POReceiptLine.ExtCost], [POReceiptLine.ExtCost]), 0))
what error are you getting ? what version are you on? i believe the ExtCost field was removed in 2018R2.
Thank you for your answer, I will verify if the ExtCost was removed. The other question that I have is, In the Generic Inquiry I need to + and - in order to get my formula
I wrote the below formula
IIf([POReceiptLine.POType]='RO',(SUM([POReceiptLine.ReceiptQty],[INsiteStatus.QtyOnHand])-[SOLine.ShippedQty]),0)
and I am getting the error
How I could resolve this problem?
Thank you
Looks like a grouping issue.
If you attach a screen shot of each tab in the GI setting or the xml file there is more chance that people can help you.
Thank you for help me
here is the screen shot of my group field
But I dont know why in my formula when I added the Sum is showed me that messaje, I am using this formula because I am doing an Aging Inventory report, and the field that I am calling Quantity is the calculation of the QOH + (Sum All receipts from todays date) - (Sum of all sales from todays) but I dont know or How I can modify it in order to get that Result
=iif( [POReceiptLine.POType]<>'RO',0,(([POReceiptLine.ReceiptQty] + [INsiteStatus.QtyOnHand]) - (SUM([SOLine.ShippedQty]))))
Thank you
Paola,
Based on the error, you have the POReceiptLine.POType and SOLine.ShippedQty in your results Grid, you need to include them in the grouping list as well. However, I am not sure you will get the results you want if you are including the SOLine.ShippedQty.
Dennis
Online Members
