Error on VF01 posting asking for foreign trade data incomplete

[Former Member]

Hi Experts,

Would appreciate anyone can help me on the abovementioned matter.

The transaction SO created is a local trade.

1) SO created under one time customer for sold to party. Documentflow status = complete

2) DO completed normally. Document flow status = complete.

sold to party address maintained is local country address NOT foreign address.

3) Billing processing VF01 user encountered an error message : Foreign trade data incomplete. Documentflow status = missiong export data.

Kindly advise.

Regards,

Yong Kok Wah

[Former Member]

Closed

[former_member70391]

Hi Yong,

Does this report helped you. I had similar situation earlier so whenver I get a error like this I will run this report to clear the Foriegn Trade data and then release the invoice to accouting via VF02.

Thanks & Regards,

Nagaraj Kalbavi

[Former Member]

Hi Nagaraj,

The program i asked the ABAPer copy into the development server and execute it, the program not working.

Anyway thank you for your kind assistance.

Regards,

Yong Kok Wah

[former_member70391]

Hi Yong,

I think you used the invoice which is already released to accotuing in development system. To check this report correctly.

Do the following things,

1. Execute the transaction Code SE16

2. Enter the Table VBRK, press enter.

3. The field EXNUM of the table VBRK should not be empty. I think in your invoice this field does contain a value since accouting document is not created. Select the Invoice which does contain this value in Development system.

4. Go to SE38 execute the report and enter the billing document number which you have selected from VBRK table and deselect the Checkbox test Mode.

5. Execute the report. Now the VBRK-EXNUM value for the invoice is cleared.

6. Now go to VF02 and release the billing document to accounting by clicking the Green Flag at the top.

Let me know if you need any further informations.

Thanks & Regards,

Nagaraj Kalbavi

[former_member70391]

Hi Yong,

Check this report, It will clear the Foriegn trade data for the invoice once it is done you can release the invoice to accouting via VF02. But I am not sure whether this fullfills your requirement.

Note: Test it in test system

REPORT ZTEST01.

tables: vbrk.

data: i_vbrk like vbrk occurs 0,

wa_vbrk like vbrk.

select-options: so_vbeln for vbrk-vbeln.

parameters: testmode as checkbox default 'X'.

select * from vbrk into table i_vbrk where vbeln in so_vbeln.

check not i_vbrk[] is initial.

loop at i_vbrk into wa_vbrk.

CALL FUNCTION 'ENQUEUE_EVVBRKE'

EXPORTING

• MODE_VBRK = 'E'

• MANDT = SY-MANDT

VBELN = wa_vbrk-vbeln

• X_VBELN = ' '

• _SCOPE = '2'

• _WAIT = ' '

• _COLLECT = ' '

• EXCEPTIONS

• FOREIGN_LOCK = 1

• SYSTEM_FAILURE = 2

• OTHERS = 3

.

IF SY-SUBRC <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

if not wa_vbrk-exnum is initial.

clear wa_vbrk-exnum.

if testmode = ' '.

update vbrk from wa_vbrk.

if sy-subrc = 0.

write:/ 'Foreign Trade Data cleared for invoice', wa_vbrk-vbeln,

'.'.

else.

write:/ 'Errors at database update of invoice', wa_vbrk-vbeln,'.'.

endif.

else.

write:/ 'Foreign Trade Data cleared for invoice', wa_vbrk-vbeln,

'.'.

endif.

endif.

CALL FUNCTION 'DEQUEUE_EVVBRKE'

EXPORTING

• MODE_VBRK = 'E'

• MANDT = SY-MANDT

VBELN = wa_vbrk-vbeln

• X_VBELN = ' '

• _SCOPE = '3'

• _SYNCHRON = ' '

• _COLLECT = ' '

.

endloop.

if testmode = 'X'.

format color col_positive on.

write:/ 'Testmode, no changes made.'.

format color col_positive off.

endif.

[Former Member]

Hi,

Please check the copy contols between delviery and billing in VTFL t.code at header level keep export data as blank ...

and then retry..

Regards

[Former Member]

Hi Sankar,

I have checked the configuration by using VTFL, the header for invoice correspondent to delivery is the export data is blank.

Regards,

Yong Kok Wah

[former_member206976]

hi

Check the customer country i think it is not your company code country

cheers

[Former Member]

Hi,

While creating SO system popup the name and address to maintain was local not foreign.

I have the the account group the field status in account group for ONE TIME CUSTOMER set was "optional" entry.

XD02, i have checked no address infor has been maintained.

Thanks.

Regards,

Yong Kok Wah