Skip to main content
Solved

-Seeking Help- Creating a GI to Track Transfer Orders

  • March 5, 2021
  • 6 replies
  • 232 views
  • Translate All

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

6 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20

Hi @byates 

Could you please share the GI, which you created.

 

 

Translate

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

See attached. Probably not much for you to go off of……..

 

Thank you

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20

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)

 

Translate

Forum|alt.badge.img
  • Author
  • 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. 

 

Translate

jhouser
Captain II
Forum|alt.badge.img+7
  • Captain II
  • 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.

Translate

jhouser
Captain II
Forum|alt.badge.img+7
  • Captain II
  • 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. 

Translate