A custom program/transaction (Z_RFWT0020) needs to be developed using program RFWT0020 provided by SAP.

This transaction code can be used two ways:

1) To update transactions already posted without withholding tax information after the withholding tax fields have been updated for the vendor so that the company can issue the vendor a 1099-MISC.

2) To update transactions already posted with withholding tax information after the withholding tax fields have been updated with tax type NA and tax code 99 for the vendor so that the vendor will NOT receive a 1099-MISC.


Steps:  Z_RFWT0020 – TO UPDATE W/T TRANSACTIONAL DATA 0NCE A VENDOR HAS BEEN CHANGED TO TURN ON FOR 1099-MISC REPORTING 


Summary:

Step

Activity

Dependency

  1. A.

Change Vendor Master

  1. B.

Populate WHT data for Invoice docs

A

  1. C.

Populate WHT data for payment docs

B

  1. D.

Check Z_1099 Report

B) Updating Invoice Docs with Withholding Tax information:

This procedure is followed when a vendor, which previously had not been set up for 1099-MISC reporting, is updated because the company must issue a 1099-MISC.

Selection Criteria:

CC: 100

Date range:  1/1/06 to 12/31/06

Upload the selected list of ZPIs

Radial button: Creation of data

Check the box: only create documents, no withholding tax data

1)  Radial button:  Invoice docs / test run

 
/wp-content/uploads/2014/01/doc1_371898.jpg

2)  Uncheck the test run button, leaving the “invoice docs” radial button checked 


/wp-content/uploads/2014/01/doc2_371899.jpg


C) Updating Payment Docs with Withholding Tax information:

1)  Radial button:  Payment docs / test run

/wp-content/uploads/2014/01/doc3_371912.jpg

2)  Uncheck the test run button, leaving the payment docs radial button checked  (this updates the payment docs)


/wp-content/uploads/2014/01/doc4_371913.jpg

D) Run Z_1099 for the same list of vendors -those with payments in 2006 will show 

Steps:  Z_RFWT0020 – TO CHANGE THE WITHHOLDING TAX CODES IN THE W/T TABLE TO NA TO TURN OFF 1099-MISC REPORTING for vendors who were mistakenly set up by CBG  for receiving a 1099-MISC. 

Summary:

Step

Activity

Dependency

  1. A.

Change Vendor Master and replace WHT type FE with NA and W/tax code with 99. The liable box remains checked.

  1. B.

Change WHT data for Invoice docs

A

  1. C.

Change WHT data for payment docs

B

  1. D.

Check Z_1099 Report



B)
Change Invoice Docs with Withholding Tax Type/code NA/99:

Selection Criteria:

CC: 100

Date range:  1/1/06 to 12/31/06

Upload the selected list of ZPIs 

Radial button: Change of withholding tax codes

Check the box: only create documents, no withholding tax data

 

1)  Radial button:  Invoice docs / test run

/wp-content/uploads/2014/01/doc5_371914.jpg

2)  Uncheck the test run button, leaving the invoice docs radial button checked 

/wp-content/uploads/2014/01/doc6_371915.jpg


C) Updating Payment Docs with Withholding Tax Type/Code NA/99:

1)  Radial button:  Payment docs / test run

/wp-content/uploads/2014/01/doc7_371916.jpg

2)  Uncheck the test run button, leaving the payment docs radial button checked  (this updates the payment docs)

/wp-content/uploads/2014/01/doc8_371917.jpg


D)  Run Z_1099 for the same list of vendors – no 1099-MISC DATA should appear.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply