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

All responses (7)

Answers (0)

Suggested answer

Amol Salvi 18,696 on at

Like (0)

Report

RE: Bank Reconciliation multiply customers

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.
Community Member on at

Like (0)

Report
RE: Bank Reconciliation multiply customers

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"
Suggested answer

Tharanga Chandrasekara 23,116 on at

Like (0)

Report

RE: Bank Reconciliation multiply customers

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.
Community Member on at

Like (0)

Report

RE: Bank Reconciliation multiply customers

The different stores are just 3 different customers.
Suggested answer

Amol Salvi 18,696 on at

Like (0)

Report

RE: Bank Reconciliation multiply customers

How the Stores are configured in system ???
Suggested answer

Suresh Kulla 47,785 on at

Like (0)

Report

RE: Bank Reconciliation multiply customers

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..
Community Member on at

Like (0)

Report

RE: Bank Reconciliation multiply customers

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