SBX - Search With Button

SBX - Forum Post Title

Transfer Shipment & Transfer Receipt

Microsoft Dynamics NAV Forum

jsshivalik asked a question on 9 Aug 2018 3:58 AM
My Badges

Question Status

Verified

Hi

  How we can link Transfer Shipment Header & Transfer Receipt Header or Transfer Shipment LIne & Transfer Receipt Line

other than Transfer Order field

Thanks

Reply
bharathkarunakaran responded on 9 Aug 2018 4:04 AM
My Badges

Hi,

Can you explain in detail about what you are trying to do and what have you tried up to now.

Regards,

Bharath K

Reply
Amol Salvi responded on 9 Aug 2018 4:18 AM
My Badges
Suggested Answer

If you see these header and line always link together with Document No

Check for field Transfer Order No. which is common ..

Reply
jsshivalik responded on 10 Aug 2018 9:51 AM
My Badges

Hi

 That is ok. In a report i have DataItem Transfer Shipment Header , Transfer Shipment Line . In my case there are chances that in Transfer Shipment header there may be multiple Transfer Order of same no . I want to read only distinct Transfer Order No from Transfer Shipment Header in a report . Is it possible

Thanks

Reply
Charl van der Mooren responded on 10 Aug 2018 9:59 AM
My Badges

Why would you need a different field from the Transfer Order field that is your link?

Reply
jsshivalik responded on 10 Aug 2018 10:13 AM
My Badges

Hi

    np. Is it possible that to filter only distinct Transfer Order no in Transfer Shipment Header table. 

Thanks

Reply
Suresh Kulla responded on 10 Aug 2018 1:17 PM
Suggested Answer

Do you mean you want to retrieve only one shipment of a particular transfer order even if you have multiple shipments ?

Reply
Bodhi Chen responded on 10 Aug 2018 8:41 PM
My Badges
Verified Answer

why don't use Transfer Order No. for Transfer Shipment Header & Transfer Receipt Header?

for Transfer Shipment LIne & Transfer Receipt Line, the Item Shpt. Entry No.[Item ledger Entry No.] in Transfer Shipment Line is linked to Item Rcpt. Entry No.[Item ledger Entry No.]  in Transfer Receipt Line by table Item Application Entry

Reply
jsshivalik responded on 11 Aug 2018 12:40 AM
My Badges

Hi

 In Transfer SHipment Header i have same Transfer Order multiple times . In report i want it should be read only 1 time.

Thanks

Reply
Bodhi Chen responded on 10 Aug 2018 8:41 PM
My Badges
Verified Answer

why don't use Transfer Order No. for Transfer Shipment Header & Transfer Receipt Header?

for Transfer Shipment LIne & Transfer Receipt Line, the Item Shpt. Entry No.[Item ledger Entry No.] in Transfer Shipment Line is linked to Item Rcpt. Entry No.[Item ledger Entry No.]  in Transfer Receipt Line by table Item Application Entry

Reply
Amol Salvi responded on 9 Aug 2018 4:18 AM
My Badges
Suggested Answer

If you see these header and line always link together with Document No

Check for field Transfer Order No. which is common ..

Reply
Suresh Kulla responded on 10 Aug 2018 1:17 PM
Suggested Answer

Do you mean you want to retrieve only one shipment of a particular transfer order even if you have multiple shipments ?

Reply

SBX - Two Col Forum

SBX - Migrated JS