Skip to Content
Symptom

Taxes were forced to the audit file of the external tax system

Reason and Prerequisites
You may want to re-send the SAP invoice document to Sabrix audit data base because of the following reasons.

  • SAP TRFC queue and QRFC queue got stuck and no document been posted to Sabrix.
  • One of the invoice documents stuck in the TRFC or QRFC queue, because of this other documents waiting on the queue.
  • Different tax amount in the SAP vs Sabrix audit because of the RFC_FORCE_TAXES_DOC been called to force the tax amount to Sabrix audit because of consistency check fail (OSS note 674649).
  • Other reasons which result in document exist in SAP but not in Sabrix audit data base.
Solution
Please follow the following 5 steps.

1) Identify the tax docs that need to be re-sent to Sabrix: Run the standard SAP report “RFYTXDISPLAY.”

3-20-2013 8-01-51 PM.png

Enter the date range or any other criteria to identify the documents which are not in Sabrix audit.

3-20-2013 8-05-48 PM.png

List all the documents that are failed to update to the Sabrix audit data base.

3-20-2013 8-08-11 PM.png

2) Identify the external tax document for above selected  documents from ETXDCH table.

  • Go to SE16N and type ETXDCH table name
  •   Enter the invoice document number on reference doc field and execute.

3-20-2013 8-11-11 PM.png

  • For an example we have shown only one document, you may have multiple documents, if so you can use the More option to load the text file which has all the missing documents.

3-20-2013 8-13-33 PM.png

3-20-2013 8-16-41 PM.png

3) Run  Sabrix custom program, Y_SABRIX_UPDATE_ETXDCH2 (enclosed within OSS note 216364_ModifiedCode.txt) to update tax docs flags in table ETXDCH.

3-20-2013 8-19-28 PM.png

Enter the list of tax docs in the selection which are identified in step #1 above. and Execute.

3-20-2013 8-46-08 PM.png

Result will show you the successful message.

3-20-2013 8-47-44 PM.png

4) Run the SAP program RFYTXUPDATE with a list of tax docs selected in step #2.

3-20-2013 8-01-51 PM.png

Enter the external document number or other input fields.

3-20-2013 8-52-25 PM.png

If you select “Display list of all results”, then program will shows the request has been scheduled.

3-20-2013 8-54-31 PM.png

Then it shows that the documents are successfully sent to Sabrix.

3-20-2013 8-54-54 PM.png

5) Run SAP report RFTYTXDISPLAY to look at the status of re-sent docs: If there is a green light, then they have been sent to Sabrix.

3-20-2013 8-55-22 PM.png

Enter the list of documents that you updated on step#3.

3-20-2013 8-56-19 PM.png

Check the status and look for the green button. if the status shows green then this is successfully updated to Sabrix.

3-20-2013 8-56-41 PM.png

6) Go to Sabrix Reports and look for the SAP documents.

3-20-2013 8-57-01 PM.png

Related Notes
Note 674649 – What are the reasons for ‘Forced’ Update?
Note 216364 – Blocked queue / No update to external tax system

Regards

Amit Gupta


To report this post you need to login first.

3 Comments

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

  1. Senthil Murugan

    Good Document. Thanks.

    I have a question, We are using Sabrix 5.5, we plan to upgrade our ECC to EHP7, does Sabrix 5.5 version supports EHP7? is there a note on this?

    (0) 

Leave a Reply