Sales and Purchase Ledger (Bevica Power BI)

Analyse customer and vendor ledger entries for ageing, debtors, and payables.

Sales and Purchase Ledger (Bevica Power BI)

This exports:

• Customer Ledger Entries
• Vendor Ledger Entries

It is linked to the core Bevica Dataset model.

Its purpose is to allow analysis of aged debt and receivables.

Hover over a measure in Power BI to see its description.

Measures

Customer Ledger Entries

NB - LCY values, posted currency values (FX), and Additional Reporting Currency (ACY) values are in these reports.

• Original Amount - original posted amount (as per CLE)
• Overdue Amount - remaining amount which is overdue based on 'TODAY' at run time
• Remaining Amount - remaining amount (as per CLE)
• Avg. Debtor Days - average debtor days based on the Due Date less Closed At Date from the CLE
• Count of Invoices
• Last Invoice Date - max date of last invoice in CLE
• Last Payment Date - max date of last payment in CLE

CLE Only Measures

• Ageing brackets (all based on 'today')
• Days Overdue (avg.) - calculates overdue days (open invoices only which are overdue) and can be used at an aggregate level (e.g., customer or salesperson) or down to individual documents

Vendor Ledger Entries

As per Customer Ledger but for the vendor ledger.

Currencies

LCY vs. FX

• LCY is in system local currency. This is from the value in the ledgers in Business Central and is not calculated in the model.
• FX is in the posted transaction currency from Business Central. Bear in mind that this could be in multiple currencies so it is recommended to use the Currency Filter.

Currency Filter

This can be used to filter ledger entries by a specific currency. For example, to see only values in EUR where there could be entries in a range of currencies.

Dates

You can use the Date Type Filter (Cust/Vendor Ledger) feature to change the date relationship. The options are:

• Posting Date - this is the default behaviour and uses the ledger posting date
• Due Date - this uses the Due Date for the relationship
• Closed At Date - uses the Closed At Date for the relationship

If you want to therefore do an aged debt type report you should use the Due Date filter to change the calculations to be based on the due date.

For example, the image below shows the date type filter in action. Note the 81'505 value is:

• Posted in 2023-03
• Due in 2023-05
• Closed in blank (as it has not yet been closed)