Skip to main content
Solved

End Date parameter of a GI is not working accurately for released date.


Forum|alt.badge.img

Hi, 

We wanted to create a GI to get the inventory in and out details for a given time period hence we created a GI joining PX.Objects.IN.INTranSplit and PX.Objects.IN.INTran tables. Inquiry title is Inventory Transaction History Inquiry.

Then we gave start date and end date parameters using the release date in InTran table.

The end date parameter seems not working properly. For example, if we give the end date as 3/31/2022 the data shows only up to 3/30/2022. 

Is there any reason behind this behavior or have I not set the GI in a correct manner? Please assist me. 

Best Regards 

Amanda 

 

Best answer by Naveen Boga

Hi Amanda, This issue is due to the Time part that is considering the GI parameters with the field Release Date Time.

I have added Time Part for the Released Date Time field in the grid field.

If you see my example, I created an issue at 11:32 PM on July 3rd but when select the paramters 

Start Date  → 07/03/2022 and End Date → 07/03/2022, GI is not fetching the results due to the TIME part.

Please find the screenshot for reference.

 

 

 

View original
Did this topic help you find an answer to your question?

4 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • July 4, 2022

Hi @apallawala21  Can you please share the XML format of GI that you created?


Forum|alt.badge.img
  • Author
  • Freshman II
  • 30 replies
  • July 4, 2022

Hi @Naveen Boga 

Please find the attached XML. Thank you very much for your kind attention. 

Best Regards

Amanda 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • Answer
  • July 4, 2022

Hi Amanda, This issue is due to the Time part that is considering the GI parameters with the field Release Date Time.

I have added Time Part for the Released Date Time field in the grid field.

If you see my example, I created an issue at 11:32 PM on July 3rd but when select the paramters 

Start Date  → 07/03/2022 and End Date → 07/03/2022, GI is not fetching the results due to the TIME part.

Please find the screenshot for reference.

 

 

 


Forum|alt.badge.img
  • Author
  • Freshman II
  • 30 replies
  • July 5, 2022

Hi @Naveen Boga 

 

I highly appreciate your kind attention to this matter. Indeed this was very helpful. 

 

Thank You


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings