Hi Guys,
This client has about 90-100 customer invoices which are paid with a lump sum and they are asking for a native Business Central 27.3 process which would automatically allocate the lump sum to the many outstanding invoices.
I have tried Payment Reconciliation Journal and Register Customer Payments and Payment Reconciliation Journal does not allocate anything automatically but only manually after entry of the lump sum and Register Customer Payment does not have an Allocate Automatically button. In Register Customer Payment I have a list of the customer invoices, I enter the payment amount which matches the invoices listed, but unless I manually check all the 'Payment Made' boxes it does not do anything automatically, (even if Copilot says that I can). Does anyone know whether it is possible to Automatically Allocate, one payment to many invoices, in Register Customer Payment, alternatively does anyone know whether this one-to-many allocation process is at all possible in Business Central?
Any help will be very much appreciated and valued.