Anyone has experience on pulling out SoldToCustID instead of SoldToCustNum? Thanks.
Can you join to the Customer table and get the CustID?
Jason, thank you. I joined Customer table. I can get CustNum but not CustID.
CustID is one of the fields on the Customer table. You should be able to find it there.