In our ERP system, we do not issue separate invoices for prepayments. Instead, customers make advance payments, and we record the prepayment amount directly during invoice generation in the frontend. The prepayment is subtracted from the total amount to calculate the net payable amount.
For example, consider the calculation shown below:
- Invoice Details:
- Description: “rrr”
- Quantity: 2
- Unit Price: 500
- Amount (Excl. VAT): 1000
- VAT @ 15%: 150
- Amount (Incl. VAT): 1150
- Prepayment Handling:
- Total Amount: 1000.00
- Discount: 50.00
- Total Before VAT: 950.00
- VAT Amount: 142.50
- Amount with VAT: 1092.50
- Advance Amount: 100.00
- Net Amount Payable: 992.50