Finance | Project Operations, Human Resources, ...

Customer settlement automatic vouchers

(0) Share

Report

Posted on by Faraz Hasan

212

Case: Customer has 2 posting profiles and I need to move the balance from one account to another via General Journal. (same customer)

Customer DR and Clearing account CR. (posting profile 1)

11003 DR

99999 CR

new line new voucher Customer CR and Clearing account DR. (Posting profile 2)

99999 DR

18307 CR

at the time of settlement (Manual), system posting settlement entry that reverse the movement entry.

18307 DR

11003 CR

Can you please explain why system is posting settlement entry.

Note: Automatic settlement option is off from Parameters and Posting Profile also.

I have the same question (0)

All responses (10)

Answers (0)

André Arnaud de Cal... 297,423 Super User 2025 Season 2 on at

Like (0)

Report

RE: Customer settlement automatic vouchers

If you have only the two transactions as you described, then the settlement is also clearing the balances on the customer main accounts. But you mentioned that you needed to move balance from one account to another, so I did assume there are more transactions for this customer.

Was this reply helpful? Yes No
Faraz Hasan 212 on at

Like (0)

Report

RE: Customer settlement automatic vouchers

Hi @Ludwig.

There is no posting profile assigned on closing.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Customer settlement automatic vouchers

Hello Faraz,

Have you been able to get this issue resolved?

If not, can you check whether a 'closing' posting profile has been specified in the posting profile form?

If this is the case, can you please remove the closing posting profile selected and test again?

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Annaick on at

Like (0)

Report

RE: Customer settlement automatic vouchers

Settlement transaction is posted to close transaction on each account used as posting profile. your accounting on posting profile should be 0 if you closed transactions. This help for reconciliation.

Was this reply helpful? Yes No
Faraz Hasan 212 on at

Like (0)

Report

RE: Customer settlement automatic vouchers

@MATTGUO: Customer is same and I settle 1 and 2 transaction via customer form (Collect>settle transaction)

Was this reply helpful? Yes No
Faraz Hasan 212 on at

Like (0)

Report

RE: Customer settlement automatic vouchers

@rahul: we have multiple posting profile like as you said. Default and PREPAY and etc.

Default is set on parameters.

My scenario is to move the balance from one posting profile to another (Customer is same). As you can see my entries.

Was this reply helpful? Yes No
Faraz Hasan 212 on at

Like (0)

Report

RE: Customer settlement automatic vouchers

1 and 2 transaction I posted via General Journal. and when I settle these transaction on customer form, system posted the 3rd transaction.

Was this reply helpful? Yes No
MATTGUO 22,336 Moderator on at

Like (0)

Report

RE: Customer settlement automatic vouchers

Hi Faraz,

Could you please elaborate on how to manually settle two transactions?

Two transactions are in different customer accounts.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,028 on at

Like (0)

Report

RE: Customer settlement automatic vouchers

there can only one default posting profile define in AR parameters

which one is being used?

the other posting profile is typically for prepayment,

what is your scenario

Was this reply helpful? Yes No
André Arnaud de Cal... 297,423 Super User 2025 Season 2 on at

Like (0)

Report

RE: Customer settlement automatic vouchers

Hi Faraz,

Which exact transactions were settled? I do assume you had an open customer transaction (1). Then you created a new transaction 'Customer DR' (2). And also the 'Customer CR' (3).

If you settle 2 and 3, then indeed it will try to clear the balance on both accounts. Probably, you wanted to settle 1 and 2?

Was this reply helpful? Yes No