Morning team!
We are developing a Cyprus localization for NetSuite and would like to understand whether Oracle has already implemented a similar business process in any of its official localization SuiteApps.Under Cyprus VAT legislation, VAT becomes chargeable when an advance payment is received from the customer. The advance payment may then be consumed by multiple future invoices generated from the same Sales Order.
For example:
- Sales Order (Net): €20,000
- VAT: €3,800
- Total: €23,800
The customer pays an advance of €11,900 (Net €10,000 + VAT €1,900).VAT must be declared only when the payment is received.The Sales Order may subsequently generate multiple invoices, for example:
- Invoice 1: €4,000
- Invoice 2: €3,000
- Invoice 3: €5,000
- Invoice 4: €8,000
The first €10,000 of taxable value has already been declared through the advance payment, therefore:
- Invoice 1 should not generate additional VAT.
- Invoice 2 should not generate additional VAT.
- Invoice 3 should generate VAT only on the taxable amount exceeding the remaining advance balance.
- Invoice 4 should generate VAT normally after the advance has been fully consumed.
The VAT must therefore be declared only once, while the taxable value of the advance is progressively consumed by future invoices.
Same logic applies to "Vendor prepayments" as well.
We have not found any standard functionality that maintains a remaining taxable balance across multiple invoices/bills or offsets VAT already declared on an advance payment/vendor prepayments.
Awaiting your thoughts and insights.