MS Access Query for Ship-To List

VM 7.1.0

I'm trying to create a list of our Ship-To ID's as they are associated to each Customer ID but am having a little difficulty in this new version.
Can anyone tell me what tables I need to join that will accomplish this? In Customer Maintenance, each customer has multiple alternate ship-to addresses and I need to be able to create a spreadsheet that shows all of these id's for each customer id. Just know which tables to join should be all I need but everything I have tried is not working.

Thank you,
paul

0911060553270289.pdf

Find more posts tagged with

VISUAL - Enterprise General Discussions

Comments

unknown

CUSTOMER SHIPTO_ADDRESS? But that doesn't look quite right because there is no Customer_ID in SHIPTO_ADDRESS, only NAME.

I have found Infor Support to be really good for specific questions like this. "What table holds info for customer alternate ship-to addresses?"

unknown

Those address are in the cust_address table.

SELECT *
FROM CUSTOMER CUSTOMER INNER JOIN CUST_ADDRESS CUST_ADDRESS ON CUSTOMER.ID=CUST_ADDRESS.CUSTOMER_ID

unknown

Thank you.

The ship-to field result is far too incomplete. I get some of the ADDR_NO numbers but not all, and the address information is only the default and not from the alternate. There must be another table somewhere. I'll check the garage.

2011-10-27_CH-Stammtisch_2.pdf

unknown

Didn't find anything in the garage so I just ran the query in "Query Tool" and got the info from there and pasted it into excel. Strange how it wouldn't work in MS Access. Acted all weird and zombie like.

Thanks for the help everyone.

Copyright © 2025 Infor. All rights reserved.