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

Question

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)

Syamantak Saha · Answer

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.

Riyaz Ali-Oracle · Answer

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