We’re excited to announce the latest version of BP Formula, now available for download! With new formulas for retrieving data by Invoices, Bills, Credit notes, and Debit notes, our customers can now enjoy even more powerful features and greater flexibility. We’re committed to continuously improving our product to better meet the needs of our users.
For invoices and bills:
=BPInvoiceRef(inv_number)
=BPInvoiceStatus(inv_number)
=BPInvoiceAmountPaid(inv_number)
=BPInvoiceAmountDue(inv_number)
=BPInvoiceTotalAmount(inv_number)
=BPInvoiceTotalTax(inv_number)
=BPInvoiceTotalDiscount(inv_number)
=BPInvoiceSubtotalAmount(inv_number)
=BPInvoiceExchangeRate(inv_number)
=BPInvoiceCurrencyCode(inv_number)
=BPInvoiceDate(inv_number)
=BPInvoiceDueDate(inv_number)
For credit notes and debit notes:
=BPCreditNoteRef(cn_number)
=BPCreditNoteDate(cn_number)
=BPCreditNoteStatus(cn_number)
=BPCreditNoteSubTotalAmount(cn_number)
=BPCreditNoteTotalAmount(cn_number)
=BPCreditNoteTotalTax(cn_number)
=BPCreditNoteCurrencyCode(cn_number)
=BPCreditNoteExchangeRate(cn_number)