While waiting on that clarification from Subra, here are the practical options depending on which scenario you're in:
If you need addresses from existing transactional records (Sales/Purchase orders):
D365 F&O does store delivery/invoice addresses at the order header level even if the master Customer/Vendor record itself lacks address data. You can pull this via:
Sales order/Purchase order header inquiry forms Navigate to Accounts receivable → Orders → All sales orders (or Accounts payable → All purchase orders), add the Delivery address and Invoice address columns to the grid view, and export to Excel. This gives you the address as it existed at time of order, not the current master data.
Data Management → Export For a bulk pull, go to System administration → Data management → Export, and export the Sales order header (SalesTable) or Purchase order header (PurchTable) entities. These entities include address fields (DeliveryAddress, InvoiceAddress related fields) that you can map into an Excel/CSV output covering all historical orders at once, rather than manually paging through the UI.
Standard reports Check Accounts receivable → Reports → Sales orders → Sales order confirmation or similar SSRS reports, since these typically include the delivery/invoice address block and can be run in batch across a date range/customer group if you need something already formatted as a report rather than raw data export.
If you need the actual master data (Customer/Vendor primary address) reconstructed:
If the address genuinely never migrated from Oracle to the Customer/Vendor master (CustTable/VendTable → DirPartyTable/LogisticsPostalAddress), pulling it from order history is really a workaround, not a permanent fix. You'd want to:
- Re-export the address data from Oracle (if still accessible) and reload via Data Management import templates for Customer/Vendor address entities
- Or, if Oracle access is gone, use the order-header addresses (from options above) as your best available source to rebuild the master data, since that's likely the most complete address information you have left in the system
Quick clarifying question back to you: are you trying to fix the master data going forward, or do you just need a one-time list/report for reference? That determines whether the Data Management export (quick, one-time) or a proper data reload into Customer/Vendor master (more effort, permanent fix) is the right path.
