Pick and Pack Manager Shipping Type not showing type from Sales Order

[former_member1095830]

We are currently running SAP B1 8.82 (8.82.068) PL: 06

When I got to Inventory>Pick and Pack> Pick and Pack Manager, enter the "Ship Date" range, and select ok. It brings up the Pick and Pack Manager screen listing all open Sales orders to be shipped.

The problem I am encountering, is the Shipping Type column does not reflect the shipping type listed on the Sales Order. Often times it will list multiple shipping types for the same Sales Order. Some will come from the order itself, some will come from the inventory item's shipping type (See attached image: all items are from same order yet depict 3 different shipping types).

Does anyone know why this would be the case? I need to reflect the Sales Order shipping type. Is there a certain means by which one type "trumps" another?

[KennedyT21 · Accepted solution]

Hi John Bird

Displays how the order is to be shipped, as specified in the sales document. For example, air cargo or courier.

Regards

Kennedy

[former_member1095830 · Accepted solution]

Thanks for the quick response! I understand that it is supposed to show the shipping type in the sales document, however, it is not doing so. Please look at the screen shot provided. You will see all line items are from a single sales order, yet they show 3 different shipping types.

[KennedyT21 · Accepted solution]

check with the order with the line items what is the shipping type

[KennedyT21 · Accepted solution]

select TrnsCode from rdr1 where docentry='301803'

check does the order number is correct...

[KennedyT21 · Accepted solution]

select TrnsCode from rdr1 where docentry='301803'

check does the order number is correct...

[KennedyT21 · Accepted solution]

in the above posted query it retrieves only one value then it is bug... If not

you have different shipping type in order so the functionality is right ,.....

Hope helpful

Regards

Kennedy

[former_member1095830 · Accepted solution]

No results on the above query. Ran this instead:

SELECT T0.[TrnspCode] FROM ORDR T0 WHERE T0.[DocNum] = 301803

Returned 1 row with single freight type.  

[KennedyT21 · Accepted solution]

Hi John...

SELECT T0.[TrnspCode], itemcode  FROM rdr1 T0 WHERE T0.[DocNum] = 301803

Post the screen shot...

Regards

Kennedy

[former_member1095830 · Accepted solution]

The full error at the bottom is "

1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'DocNum'.

2). [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'TrnspCode'.

3). [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement 'Blank"

[KennedyT21 · Accepted solution]

Hi John...

Sry small mistake Try This

Select Itemcode,TrnsCode from rdr1 where docentry='301803'

[former_member1095830 · Accepted solution]

Thanks for your continued assistance!

[KennedyT21 · Accepted solution]

No Mention Buddy...

Can you say the whats is the origin document for Pick and Pack?

Select Itemcode,TrnsCode from rdr1 where docentry in (

Select docentry from ordr where T0.[DocNum] = 301803 )

Regards

Kennedy

[former_member1095830 · Accepted solution]

[KennedyT21 · Accepted solution]

Hi John

Select Itemcode,TrnsCode from rdr1 where docentry in (

Select docentry from ordr where [DocNum] = 301803 )

what i am trying to say if you have multiple shipping type in sales order row level then it will pick the same in the pick and pack manager ...

try with the above query and reply

Regards

Kennedy

[former_member1095830 · Accepted solution]

I understand what you are saying. If the item level ship type overwrites the document ship type, why even have a document level option? It would appear that if you add the items, then go to the logistics tab and change the ship type to the default (which was already chosen) It then applies to each row and changes all corresponding rows. Do you have the same experience?

[kothandaraman_nagarajan · Accepted solution]

Hi John Bird,

This is standard system definition of SAP. System considers item level  ship type rather than document ship type.

Please refer SAP notes:

1719340 - Shipping Type in row is different than the
document

Hope helpful.

Thanks & Regards,

Nagarajan

[KennedyT21 · Accepted solution]

Hi John...

Yes, You are correct Pls close the thread with the correct answers

Regards

Kennedy

[former_member1095830 · Accepted solution]

Thanks for both of your help. I appreciate it!