[SalesForce] How to get the Billing or Shipping address in Account objects as a single data

There are two standard composite address fields, either of which should suit your needs.

• BillingAddress
  • BillingCity
  • BillingState
  • BillingPostalCode
• ShippingAddress
  • ShippingCity
  • ShippingState
  • ShippingPostalCode

Once your fields are on the Page Layout and you have data populated, you can get this data via a query as follows. You can apply a similar filter in any Report.

SELECT BillingCity, BillingState, BillingPostalCode FROM Account WHERE BillingState = 'CA'

If you want to relabel these fields:

1. Go to Customize > Tab Names and Labels > Rename Tabs and Labels.
2. Next to Accounts, click the Edit link.
3. Click the Next button.
4. Change the labels as needed.
5. Click the Save button.

Approach 1

Since Address in Compound field, you can simply fetch each Address attributes from Account object from the SOQL query and update invoice records like this:

trigger udtInvAddress on Account (After Update) {
List<Order2__c> invoices;
if(Trigger.isAfter && Trigger.isUpdate){            
     invoices = [SELECT Id, Account__r.BillingStreet, Account__r.BillingCity, 
     Billing_City__c, Billing_State__c, Billing_Street__c, 
     Billing_zip__c, Billing_Country__c FROM Order2__c 
     WHERE Account_Name__c =:Trigger.newMap.keySet()];
    for(Order2__c invoice: invoices)
    {
        System.debug(invoice.ID);
        //update all of the fields with the updated information only if the new information is filled in.
        if(invoice.Account__r.BillingStreet <> null){
            invoice.Billing_Street__c = invoice.Account__r.BillingStreet;
        }
        //update other fields

    }
    update invoices;
}

Moreover, your query needs to be bulkified and would be outside of for loop.

Approach 2

The use case can be simply be implemented by Process Builder. In this below picture I have shown you how Invoice Billing Street can be mapped with Account's Billing Street via Reference.

The Account Address attributes can be picked up in the PB during field mapping like this:

Since, without writing code, this functionality can be achieved, I will go by Process Builder.