invoice has the wrong region when the customer master is changed

[Former Member]

Let's say we changed the customer master ship-to address from NY to NJ in Oct, 2007 and there was no manual change of ship-to address in a September created sales order or delivery, the address indicator (VBPA-ADRDA) will be equal to 'D' (address from master data).

We have a output tax report by state that is based on the invoice's address using tables VBPA and ADRC. The state of the invoice from the above scenario will have NJ instead of NY. Is there another SAP table we can use to capture the correct state?

Thanks.

[Lakshmipathi]

Dear alice yeung

Have you checked in VBRK and VFDKS ??

thanks

G. Lakshmipathi

[Former Member]

VBRK got the region from customer master which had been changed. I don't think there are any tables with VFDKS

Thanks.

[Lakshmipathi]

Dear ayeung

Sorry, it should have been VKDFS.- +Field LLAND.+ Also in VBRK itself, you can find a field LAND1 which is Destination Country.

thanks

G. Lakshmipathi

[Former Member]

Hi,

You can use KNA1 to get the customer region from master.

Regards,

Murali

[Former Member]

Since the customer master was changed in October and the invoice was created in September, KNA1 will have the wrong state if the report is run in December.