Skip to main content
Solved

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

  • Apr 1, 2022 11:30 AM UTC
  • 9 replies
  • 1174 views
  • Translate All

Forum|alt.badge.img

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

Try this join instead:

 

View original

9 replies

darylbowman
Captain II
Forum|alt.badge.img+17

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)

 

Translate

Forum|alt.badge.img
  • Author
  • Freshman I
  • Apr 1, 2022 2:11 PM UTC

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

Translate

darylbowman
Captain II
Forum|alt.badge.img+17

Try this join instead:

 

Translate

Forum|alt.badge.img
  • Author
  • Freshman I
  • Apr 1, 2022 2:56 PM UTC

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

Translate

darylbowman
Captain II
Forum|alt.badge.img+17

I'm not sure I understand. Are you saying you want the ‘Inventory ID’ column to be blank?

Translate

Forum|alt.badge.img
  • Author
  • Freshman I
  • Apr 1, 2022 3:04 PM UTC

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

Translate

Forum|alt.badge.img
  • Author
  • Freshman I
  • Apr 1, 2022 3:06 PM UTC

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.

 

Translate

darylbowman
Captain II
Forum|alt.badge.img+17

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.

Translate

Forum|alt.badge.img
  • Author
  • Freshman I
  • Apr 1, 2022 4:22 PM UTC

I really appreciate your speedy work on my case. Thank you so much Sir!

Translate