Camilla Broe Solution Architect

Often business receives payments from financial service providers and an account statement excel file is received with the background for the payment. The payment file consist of hundreds of lines, where customers invoices are paid and all need to be settled.

We would like to have the option to use the "Open in Excel" functionality within the journal to be able to upload the lines and at the same time the invoice should be settled. Currently, the using the "Open in Excel" journals, we can enter the customers invoice number but it does not settle the invoice, it remains open and unsettled.

We have the data entity "CustomerPaymentJournalLineSettledInvoiceEntity" in Data Management which actually allows for settling the invoice noted on the line. Using imports from data management is not something a finance worker should do, so that is unfortunately option. Therefore we should have this option from within "Open in Excel" journals to enter the invoice number which automatically settles the invoice.

It would good to have the option for both customer payment journals and general journals.

It would be great to have a few more digits in the TaxCodeID so we are not limited to 10 digits. This should be seen in conjunction with the Tax Calculation Service where we now have multiple VAT registration per legal entity and therefor a much more detailed tax code setup.