I have a quick technical question about Sales Orders and address,
I need to retrieve the billing or the Invoice address of all my sales orders.
I found the delivery address on SO form in AX 2012, but i can't find the invoice address related to each sales order.
If anyone explain to me the logic behind in AX please, i will be gratful.
Now im using a SQL Query which make 2 major test to each sales Order
Could anyone please explain to me if this logic is correct or not.
and if it's possible to help by providing a SQL Query which can help to retrieve the Invoice address of Sales Orders.
Thanks in advance :)
Any advices please :)
Here is the sequence:
1. If invoice type address then it's Invoice address
2. if no invoice type address present then delivery address
If no invoice and no delivery type exists and primary address exists, then primary address is used. If order is already invoiced then pull address based on custInvoiceJour.InvoicePostalAddress and not from sales order.
Business Applications communities