9

In the Swiss version of Business Central, there is a module for LSV collections, that generates a file containing all direct debit transactions, which can then be uploaded onto the online banking portal.


This module doesn't cater for service invoices, and only works for sales invoices, although the suggestion base is the "Cust. Ledger Entry" table, which includes service invoices. Whilst service invoices aren't suggested for collection, it is possible to add them manually in the LSV Journal prior to close the LSV collection; then the "Write LSV File" routine fails if there's a service invoice included in the journal.


Two things need to be adjusted in order to include service invoices to LSV collections:

  1. in the suggestion routine ("LSV Suggest Collection" report 3010831), when looping over customer ledger entries all invoices (including service invoices) need to be picked up, in order to populate the "LSV Journal Lines"
  2. When creating the LSV file ("Write LSV File" report 3010834), amend the WriteCollectionRecord procedure so it doesn't only Get the "Sales Invoice Header", but also the "Service Invoice Header". Then the logic needs to be changed in the PrepareEsr function in the CHMgt codeunit (11503) so it can work with both sales invoices and service invoices.
STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team