Reverse disbursement FNM3 reconciliation not accepted

[wouter_vanhoutte4]

Dear Guru's,

When we disburse a contract (type general loan) and we reverse it there is no issue. However we disbursement a contract with condition type 212. This condition is linked to flow type 3145 and is posting on the customer account against a balance sheet.

We had to define offsetting which we no impact on accounting since we linked the offsetting flow types (3345 and 3375) to the balance sheet account of the granted loan.

However if we reverse the loan, this is not possible. Due to the fact we can't post directly to the reconciliation account. The error message as such is logic, since the 446-account is indeed a customer, but why is the system not cancelling the original posting which is in fact posted on the customer

See a few screenshots below in order to clarify the setup that we we have done:

And the account determination

We are using this account determination in order to elminate the impact on account of these flow types

We get the following error message:

TR-LO-460

[former_member357303 · Accepted solution]

Hi,

the setting with 11 (to balancer sheet) is really unusual.

What does "eliminate the impact on account" mean ?

Payments / Withholdings like 3375 should be posted to customer account.

Offsetting account would be a technical clearing account.

Kind regards,

Michael

[wouter_vanhoutte4]

Hi,

Well in fact, we only want to have the impact of the 3145 flow. With this flow we generated a reduction on the customer account, since it is a certain commission that the customer has to pay and we but in on balance sheet.

To my feeling the flow type 3345 and 3375 (I have defined them as offsetting flow types of flow type 3145 and 0001) are flow types which are at least generate additional postings.

These posting are according to me not necessary from accounting point hat is why I linked these flow types to the balance sheet account itself.

Like that these flow don't trigger any posting (debit = credit on the same account, so 0-posting an no accounting. I tried also to link the debit and the credits twice (for both flow types) to the customer reconciliation , but the system was no able to determine the open items.

Best regards,

Wouter Vanhoutte

[former_member357303]

Hi,

but why do you then do it with a withholding in disbursement ?

Could you please provide an example how disbursment posts and how 3145 should (customer account, balance shee account)

Regards,

Michael

[wouter_vanhoutte4]

Hi,

Find below the postings which are generated by the disbursement and secondly the calculated cash flow:

The 2 following screenshots shows the postings which are generated via the disbursement: So the amount granted should be repaid

Best regards,

Wouter Vanhoutte

posting generated by flow 3145

posting generated by flow 0001

The next 2 screenshots shows how the cash flow looks like:

and only the flow types for the repayment of the capital

[former_member357303]

Hi,

ok, I guess the repaymemnts are calculated based on disbursement (5.000).

3145 and 0001 are both posted to customer account.

So withholding should close orginal 0001 and reopen a new item with 5.000 - 225 = 4.775.

Would you need other postings ? Or other calculation  of repayment ?

Sorry, I still did not understand the full picture.

Kind regards,

Michael

[wouter_vanhoutte4]

can be closed, I linked another set of accounts, which are offsetting each other. More complex posting, but accounting the same net result.