Can you setup batch job for automatic customer account ledger payment allocations

(1) Share

Report

Posted on by Umar Ali

Hi,

Is there a way that in F&O you can have a periodic job setup for payments to be allocated against customer invoices automatically - ideally oldest invoices are settled first.

Thanks

All responses (3)

Answers (1)

Sort by

Verified answer

André Arnaud de Cal... 307,711 Super User 2026 Season 2 on at

Like (3)

Report
Copy link

Link copied!

Hi Umar,

There is no batch job for settling customer transactions. You can enable an automatic settlement in the parameters which can find the oldest invoices first to be settled upon posting the payment journal. If you currently have unsettled customer transactions, you can settle this customer by customer or consider creating a customization for a batch job or write a runnable script.
Umar Ali 92 on at

Like (0)

Report
Copy link

Link copied!

Hi André,

Thanks for coming back to me. Ideally we are looking for some sort of script of customization of batch job to deal with proforma scenarios where the customer pays before we have even raised the invoice for the goods.

I did come across the automatic settlement option in the parameters, i have a question on this option. When i enabled the automatic settlement option, i noticed that i still had to select the 'Mark by priority' button (see below in the settlement forum) for the automatic settlement rules to be applied. Is there no option for the settlement to be purely automatic without the user having to select this button each?

Thanks
Umar Ali 92 on at

Like (0)

Report
Copy link

Link copied!

hi Andrew,

Thanks for getting back to me on this. I had a look at the parameters you mentioned below, the issue with this is, ideally i would like to only apply the automated settlements to specific customer groups as opposed all cutomer groups included within the posting profile. It appears that the automated settlement option is against the full posting profile, not the specific layers/groups within it.

I could create a seperate customer posting profile and move the 2 customer groups out of the main posting profile into this, however the issue i have then is that you can only have one default posting profile enabled within the sales ledger parameters, so that does not really work either.

Thanks