Skip to main content
Solved

-Seeking Help- Creating a GI to Track Transfer Orders


Forum|alt.badge.img

Hello,

I am trying to create a GI to help assist in tracking Transfer Orders. Mainly the corresponding shipment and receipt (if already received). 

 I am looking for the following at minimum: 

Date (SOOrder.OrderDate)

Transfer Order Number (POReceiptLine.SoOrderNbr)

Shipment Number Ref (SOShipment.ShipmentNbr)

Receipt Number Ref (POReceipt.ReceiptNbr)

 

Essentially, I want to create an inquiry so I can quickly identify what transfer orders have been created, the corresponding shipment ref and then final receipt ref. 

Additionally I would like to add the From Warehouse, To Warehouse and quantity(this is not completely necessary). I took my first shot at creating one from scratch and the GI just times out. Just learning GI builds and it is a tough slog. 

 

Any help would be greatly appreciated. Thank you

Best answer by Naveen Boga

Hi @byates 

I just checked the above GI, you have added tables but there is NO relation between them.

Can you please confirm the below one?

  • Are you creating a purchase order from Transfer Order? (If NOT can you please explain how the transfer order is related to Purchase Order)

 

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

6 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3409 replies
  • March 6, 2021

Hi @byates 

Could you please share the GI, which you created.

 

 


Forum|alt.badge.img
  • Author
  • 74 replies
  • March 8, 2021

See attached. Probably not much for you to go off ofโ€ฆโ€ฆ..

 

Thank you


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3409 replies
  • Answer
  • March 8, 2021

Hi @byates 

I just checked the above GI, you have added tables but there is NO relation between them.

Can you please confirm the below one?

  • Are you creating a purchase order from Transfer Order? (If NOT can you please explain how the transfer order is related to Purchase Order)

 


Forum|alt.badge.img
  • Author
  • 74 replies
  • March 8, 2021

I am using the Purchase Receipt to receive a Transfer Order. I would like to have the receipt number listed as that would quickly tell me the the TO has already been received as well as the document details of the corresponding receipt. 

 


jhouser
Captain II
Forum|alt.badge.img+3
  • Captain II
  • 107 replies
  • July 3, 2023

@byates Did you figure this one out? If yes, could you please share the solution? I am trying to do the same thing.


jhouser
Captain II
Forum|alt.badge.img+3
  • Captain II
  • 107 replies
  • July 3, 2023

I figured out what I was looking for. Needed the TR Order# with all 2-step transfers not received. Attached is XLM of GI for anyone interested. 


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