In which table ASN No is stored

[former_member225623]

Hi Folks,

I have created a ASN for one of PO.In which table ASN no is stored and how we can find ASN No related to that PO.

Thanks in advance.

[joaquin_fornas · Accepted solution]

Hello

Please, check table SHP_IDX_GDRC.

Regards

Joaquin

[former_member225623 · Accepted solution]

It showing error.Table does not exist.Iam working on SNC 7.0

[martin_renardy · Accepted solution]

Check table /1OM/DELVDLI3020. The PO Number is stored in field REFORDID.

With the order id you will find the order header in /1OM/DELV1HDR020.

ASN number is in table /1OM/DELV7MP2020/ field ordno.

You can easily join the table(s) with the quick viewer!

Regards

Martin

Edited by: Martin Renardy on Oct 20, 2011 3:22 PM

Edited by: Martin Renardy on Oct 20, 2011 3:29 PM

[Former Member · Accepted solution]

Hi,

Go to Table /1OM/DELV7MP2<client_name> where Client_name=Your client name.

for example if ur client name=800 then table name is /1OM/DELV7MP2800

Enter ASN number in field ORDNO(order Number) copy the field ORDID and go to table name:/1OM/DELVDLI3<client_name> where Client_name=Your client name.

Past ORDID in ORID field and check REFORDID which will give you purchase order number.

Regards,

Nikhil

[martin_renardy · Accepted solution]

Thanks Nikhil, the table name is client dependend! I didn't thought about that!

Regards

Martin

[former_member225623 · Accepted solution]

HI folks,

Nikhil answer is working fine

[Former Member]

Hi ,

  I tried what you said but in my system it is saying " Table doesnot Exists", So any table where i can give ASN Number and Get Inbound Delivery Number.

Regards

Shek