Payables & Cash Management

Get Involved. Join the Conversation.


    Judy Hamner
    Can the code for B2B XML invoices be modified?
    Topic posted July 24, 2019 by Judy HamnerSilver Trophy: 7,500+ Points, tagged Payables, Setup / Administration 
    25 Views, 2 Comments
    Can the code for B2B XML invoices be modified?
    We would like to have the tax lines not sent to Payables if the tax amount on the invoice is $0.

    We are a tax exempt entity.  The current default XML format requires a tax line be sent on any B2B xml invoices.  This creates lines of invoice data that are not necessary.  Is it possible to edit the XML in order to remove these lines from xml or from the import when the amount = $0?  




    • Becky Alvarez

      There is no requirement or "rule" that B2B requires tax lines to be sent on a B2B transmission.  B2B is just like entering an invoice in the UI and follows the same taxation/business requirements.

      I think this is a situation where you probably have not configured taxes but your Supplier is sending $0.00 as a tax amount as a part of the payload.  You can fix this by doing the following:

      • Modify B2B layer to drop Tax lines ($0.00 amount or all).  You can use CMK or any other solution.
      • There is no tax line in the modified payload so tax line will not be read by the web service and nothing will be inserted into the interface table.
      • I am assuming there is not any tax setups so the tax line will not be added by the tax calculation service that is automatically performed during the import process/subsequent tax calls.

      If you need assistance in modifying the B2B layer you can log an SR with support and they should be able to assist.

      Hope this helps.

    • Judy Hamner

      Thanks, Becky. 

      Originally, we did not configure taxes and the suppliers was sending $0 as a tax amount in the payload as you noted.  We set up Tax in order to have the invoice import successfully (as per Oracle Support).  Our suppliers were not able to remove the tax line from their standard xml so we were not aware of a way to have that dropped during the import.  We are going to start testing the move away from B2B to using the webservice to interface to OSN.  I will review your information as we complete that testing to see if we can drop the tax line in the payload.