Example: I have tracking # that shows up in Invoice Inquiry but I can not tell what table/field is storing it.
I just found out that this number is not being stored in SO19 or SO38 when the shipping/invoice info is entered through Invoice Data Entry. If it is entered through Shipping Data entry it is in the SO39 table.
Weird thing, I can see the tracking info on the invoice no matter how it was entered, BUT if I go through, Crystal, Excel or SQL to view the table... no dice. Since I can always see the tracking# in summary package tracking inquiry, it must be stored somewhere. I can not find it.
Anyone know how to extract this data?
Thanks
I just found out that this number is not being stored in SO19 or SO38 when the shipping/invoice info is entered through Invoice Data Entry. If it is entered through Shipping Data entry it is in the SO39 table.
Weird thing, I can see the tracking info on the invoice no matter how it was entered, BUT if I go through, Crystal, Excel or SQL to view the table... no dice. Since I can always see the tracking# in summary package tracking inquiry, it must be stored somewhere. I can not find it.
Anyone know how to extract this data?
Thanks