Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Issue with VAT Details Report – Cancelled and Reversed Postings Not Included

Received Response
21
Views
2
Comments
Jose Angel RuizMen
Jose Angel RuizMen Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Is it possible to obtain the VAT amounts of a cancelled posting and its reversal, as apparently the system does not support it

Any insight, workaround, or confirmation on this limitation would be greatly appreciated.

Product: Oracle Fusion Payables

Report Type: BI Publisher – Custom SQL Report (accessed via OTBI)

Version: Oracle Fusion Cloud Applications25B (11.13.25.04.0)

Tagged:

Answers

  • Riyaz Ali-Oracle
    Riyaz Ali-Oracle Rank 6 - Analytics Lead

    Hi @Jose Angel RuizMen

    You could also try posting it in the product specific analytics forum and there are better chances of getting the right guidance.

    https://community.oracle.com/products/oracleanalytics/categories/fusion-erp-analytics

    Thanks,
    Riyaz Ali

  • Syamantak Saha
    Syamantak Saha Rank 5 - Community Champion

    Dear Jose,

    VAT/GST functionally treated separately to the actual journal entry for the purchasing transaction. For example, if you bought a $100 product and paid 10% GST of $10, the $100 and $10 should be recorded separately.

    The Tax Office usually allows for running calculation of GST/VAT paid and collected, so a reversing of this is not really a feature as the book of accounts for GST/VAT should pick this up when the actual transaction is reversed. Hence, end of financial year at the book of VAT/GST, the $10 would automatically not appear, meaning you have paid $10 less due to the reversal.