How to use an Union Join in GI(Generic Inquiry) and bring a column data through a sub query?

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

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

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 want that the first line of every Inventory ID’s Altrenate ID will be blank.

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.

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!