We have a GI that provides PO Receipt Information. We would like the GI to exclude Returns and associated PO lines (hide them). Is there a function similar to VLookup that can be used? Below screen shot is one of the examples we are using.
We tried the below formula but that is not working.
I have attached a xml file of the GI. Any suggestions would be helpful, thank you!
Best answer by Robert Sternberg
View original
+8
How about adding the condition OrigReceiptNbr IS EMPTY? Would this accomplish your goal, if not could you elaborate on the issue you are trying to solve.
Thanks!
+11
If I’m understanding correctly, you need to add a filter condition on the Conditions tab of the GI like this:
POReceiptLine.OrigReceiptNbr Does Not Equal POReceiptLine.ReceiptNbr
(assuming this is accurate logic; the main thing is using the Conditions tab, not the Results tab)
Hi
Below is an example:
If the return contains the original receipt nbr and if the line nbr is the same - we would like to exclude the receipt line completely.
That is if concatenation of (OriginalReceiptNbr, LineNbr) is the same as Concatenation of (ReceiptNbr,Linebr) then exclude. (In this case it needs to exclude the highlighted line in green)
Which is why we wanted to know if there is a function similar to Vlookup in acumatica GI. Can this be done in acumatica GIs? Thank you!
+8
Not sure if I have an answer for you yet but I would like to read back your question and see if I understand correctly now.
Goal: Exclude receipt lines that were returned.
Use Case: This GI will display ‘receipts without returns’ and ‘returns’. (excluding ‘receipts with returns’)
Does this sound accurate for what you are trying to achieve? If so, we can probably use an aliased table to gather the required information.
Hi
+8
Yes that's correct. Here are the steps explained, I also attached the working Generic Inquiry.
Hope this helps!
Hi
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
