Report: Retentions Grouped by Type (Value Added Tax: IVA or Income Tax: ISR)

[Tropicalrambler]

• [x] Title: "VAT and Income Tax Retention Report"
• [x] Filters: Supplier, Customer (If customer, pull only Sales Invoices) (If Supplier pull only Purchase Invoices)
• [ ] Grouping: "VAT Retentions" & "Income Tax Retentions"

Columns

• [x] "Retention Date" Field: date

• [x] "Invoice Number" Field: Requires logic! If Supplier, we pull Supplier invoice Number. If absent show the internal ERPNext invoice ID.

• [x] "Tax ID": Field: **Requires Logic! **Pull any Tax ID or NIT field from Invoice.

• [x] "Supplier" or "Customer". Requires Logic! If Sales Invoice = Customer, if Purchase Invoice = Supplier

• [x] "Invoice Date" Field: Requires logic! If Customer, Posting Date, If supplier : Supplier Invoice Date

• [x] "Invoice Total" Field: Grand Total

• [ ] "Retention Amount" Field: Monto de la Retención

• [ ] "Purchase Ledger Number" - Field: "Purchase Ledger Page Number" - "Sales Ledger page number"

• [ ] "Journal Entry" - Field: Title of first Journal Entry linked to invoice. (Journal Entry)

• [ ] "Retention Confirmation Number" : Field: retention_confirmation

• [x] Translation: "VAT and Income Tax Retention Report": "Reporte de Retenciones IVA e ISR"

• [x] Translation: "VAT Retentions": "Retenciones de IVA"

• [x] Translation: "Income Tax Retentions": "Retenciones de ISR"

• [x] Translation: "Date of Retention": "Fecha de Retención"

• [x] Translation: "Invoice Number": "Numero de Factura"

• [x] Translation: "Tax ID": "NIT"

• [x] Translation: "Invoice Date": "Fecha de la Factura"

• [x] Translation: "Invoice Total": "Total de la Factura"

• [x] Translation: "Purchase Ledger Page Number": "Numero de Folio Libro de Compras"

• [x] Translation: "Sales Ledger Page Number": "Numero de Folio Libro de Ventas"

• [x] Translation: "Retention Confirmation Number": "Constancia de Retencion"

Extras:

• [x] Custom Field: "Purchase Ledger Page Number" - Doctype: Purchase Invoice. Insert After: ??
• [x] Custom Field: "Sales Ledger Page Number" - Doctype: Sales Invoice. Insert After: ??