Link between SAP B1 Picklist and its target document such as Delivery, A/R Invoice

[anandrd]

Dear Experts,

Could you pls share some insights on how to get the Link between SAP B1 Picklist and its target document such as Delivery, A/R Invoice?

While Checking the Delivery, A/R Invoice child such as DLNxx & INVxx, We couldn't figure out any references, likewise PKLxx also doesn't seems to store the information.

Best Regards

Anand Ramachandran

[mgregur]

Hi Anand,

there is no direct and 100% correct link between Picklist and Delivery / Invoice. What Felipe mentioned might be correct only and only if a single Sales Order line is picked on a single Picklist (which is not always the case). The only correct way is to check which Picklist is linked to a Sales Order line, and then what is the link of that Sales Order line to a Delivery / Invoice.

There is a possible workaround where you can create a function which would log into a UDT all the Picklists and when they are converted to Delivery / Invoice their respective links (line, quantity), but there is no out-of-the-box solution.

BR,

Matija

[Felipe_Lima]

Hi @anandrd ,

The link lies in the picklist details table (PKL1) and its related document details table, which could be DLN1, INV1, etc.

With Delivery Note as example:

(Object) - PKL1.BaseObject links to DLN1.BaseType
(Entry ID) - PKL1.OrderEntry links to DLN1.BaseEntry and also PKL1.AbsEntry to DLN1.PickIdNo
(Line) - PKL1.OrderLine links to DLN1.BaseLine

I hope it helps.

BR,
Felipe

[LoHa]

Hi Felipe, as far as I know, you are not right. the order lines ares only from where the PickList started. If you have a look in the relationship map, you won't be able to see the delivery note. And the DelNote is always base on the Order. A way could be to look in the DelNote, get back in the Order and then into PKL1 regards Lothar

[Felipe_Lima]

Hi Lothar,

I understand your point and I might have oversimplified things. And yes, your approach of starting from the end (DN) moving backwards do make sense. But that's just to give a clue about where to start digging.  

In this perfect scenario, where the process is SO > Pick > Deliver, I think we got a direct link (DLN1.PickIdNo - PKL1.AbsEntry). And, by assuming this flow, BaseLine/OrderLine and OrderEntry/BaseEntry will also find a match. Again, I'm not considering complex scenarios without picking lists, multiple picking lists to a single DN, partial picking, manual adjustments post-picking, etc. This would require a deep analysis of the specific case, as it normally depends on the business process.

BR,
Felipe