Hello ,
I’m working on creating a GI to fetch all my Sales Price along with Alternate ID but I need to use a Union Join to get the Alternate ID.
Thank You
Jennifer
Best answer by darylbowman
View originalHow to use an Union Join in GI(Generic Inquiry) and bring a column data through a sub query?
+11
Your GI works fine for me if I disable the following Conditions:
- ARSalesPrice.CustPriceClass (not applicable to my instance)
- InventoryItem.usrDT (obviously I don’t have this field in my instance)
- ARSalesPrice.CuryID (I use USD)
Hello Sir,
My Alternate ID’s are repeating and I want that Alternate UOM should match with Sales Price UOM because I haven’t used Alternate ID in ARSalesPrice.
Thank you
Jennifer
+11
Try this join instead:
Sir,
It is showing correctly now, but my Original Item code is also having an Alternate ID , is there any way that I can make it blank and from next line it will show Item code with alternate ID?
Jennifer
+11
I'm not sure I understand. Are you saying you want the ‘Inventory ID’ column to be blank?
Sir,
Is it possible to show if in Alternate ID the UOM will be as 3Pack then automatically the Sales Price will multiply EA Price *3 and show me in the price ?
Jennifer
I'm not sure I understand. Are you saying you want the ‘Inventory ID’ column to be blank?
I want that the first line of every Inventory ID’s Altrenate ID will be blank.
+11
Sir,
Is it possible to show if in Alternate ID the UOM will be as 3Pack then automatically the Sales Price will multiply EA Price *3 and show me in the price ?
Jennifer
In my understanding, cross-references should only be used for giving an item a different name. If your customer requests item X and you want your system to recognize that as a 3-pack of item Y, that would be a job for Cross-references. But item X should not have both a 3-pack of item Y and a single unit of item Y as cross-references. I could be wrong.
In this way, the price of an item will match the price of the cross-reference as well.
I'm not sure I understand. Are you saying you want the ‘Inventory ID’ column to be blank?
I want that the first line of every Inventory ID’s Altrenate ID will be blank.
If you literally mean that you want the first row of the GI to have a blank Alternate ID, I’m quite curious why. The first row could obviously change depending upon how it is sorted. I’m going to need an explanation in order to recommend something.
I really appreciate your speedy work on my case. Thank you so much Sir!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.