Bank Reconciliation multiply customers

(0) Share

Report

Posted on by Community Member

Hi experts,

Is it possible when doing a bank reconciliation import from bank to split the payment up to multiply customers. I will give you an example below.

The client receives 1 payment containing payment for 3 companies/stores. The main company owns alot stores, the collect the payment and pay it together, but when in navision its needed to split it out the right stores and not the main company.

The screenshot is needed to be divided unto 2 or more customers in the system. Is it possible?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Community Member on at

Like (0)

Report

Extra question, what no. series does it use when posting, so I can change it?

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Hello,

I am sorry but i don't have knowledge on the reconcilation process but for your other question the No. Series please check the General Ledger Setup for Bank Rec. Adj. Doc. Nos..

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

How the Stores are configured in system ???

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The different stores are just 3 different customers.

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

In your bank account ledger it will be 3 different entries but in the bank statement it will be a one sngle entry which matches the total of those 3 entries. When you do the bank rec you cannot map the lines.

What you can do is you can edit the bank statement and upload it to NAV (spilling the lines).

Or you can select the 3 lines and then match manually to the single line in the uploaded bank statement line.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Thanks for your input all of you.

@Suresh Kulla - there is a Bank Account Nos. in the general ledger setup. Do you mean i should use this, I couldn't find Bank Rec. Adj. Doc. Nos.

Another question: When I have a imported line that have a match confidence = None i want to give it a special customer no.

I have written some code to do this, but I get an error when running it.

OnAfterGetRecord()
IF("Match Confidence" = "Match Confidence"::None) THEN BEGIN VALIDATE("Account Type","Account Type"::Customer); VALIDATE("Account No.",'99999999'); END;

It insert it fine, but when i click the accept applications in the payment reconiliation journal its like the line havent been modified. It types in the customer no. but wont accept it when accepting the application.

I have tried adding INSERT(TRUE); or MODIFY(TRUE); , but then i get this error "A transaction must be started before changes are made on the Database"

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Hi

You canot modify or insert record on onafterGetrrecord Trigger . You need to write this OnModify Trigger

Or May be use Codeunit or Report to modify/Insert the records.

Was this reply helpful? Yes No