Payment Methd Bal. Account not considered in journal posting

soldin07

Hello,

It's my first posting so sorry for begginers mistakes.

I am working with NAV5.0 and trying to post a sales line in a journal:
from G/L account to Customer.

All movements are ok: Gen Led, VAT, Cust Led,... except that, as the Customer has a Payment Method with balance account type and No filled in, I expected a new customer movement to close this entry (for example, a receivable in the bank).

When I do this situation through a sales invoice it does work as I expected.

Am I doing something wrong in the journal (any missing field to fill) or this functionality does not work in journal or .... ??

Thanks in advance,

ara3n

Payment method is a field in journal. So you have to select the balancing account type and balancing account No.

soldin07

Hello,

Thanks for such a fast answer.

I don't know whether I am not doing things right because I supossed to be doing what you say in your post.

I will try to explain my transaction: for any posting date and doc number, I fill "account Type" and "account No." with a sales G/L account, credit amount for example 100 and "balance account type and No." with a customer. Payment method code is also filled with a method with "balance account type and No." with a bank.

When I post the line I don't get the result. I have also tried inserting the Customer "balance account type and No." in a new line filling the Payment Method, but no result were found.

Thanks again

ara3n

When you populate the general journal.

Posting Date := workdate
Document Date := workdate
External Doc No := CustomerPO
DocumentNo := INV000001
Doc type := Invoice;
Acc type := Customer;
Acc No. := CustomerNo;
Amount := 100
Bal Acc type := G/l Account
Bal accNo := GL Sales Acc No.


This should give you the entries you need For sales entry.
Now if they paid already. You need a second general journal.

Posting Date := workdate
Document Date := workdate
External Doc No := CustomerPO
DocumentNo := CheckNo
Doc type := Payment;
Acc type := Customer;
Acc No. := CustomerNo;
Amount := 100
Bal Acc type := Bank
Bal accNo := Bank Acc No.

The balancing account could be GL Like Cash.

soldin07

Hello again,

I understand what you mean with your example: I can create those lines separaterly and it would work as I explained.

The objective I am following is, if possible within standard, getting the right fields filled so that the second line is inserted automatically as it does when you post an invoice with a Payment Method with balance account types and No filled with a value.

Thanks for your effort.

ara3n

No it's not possible. Also Payment method is not a standard field in Gen Journal.
Unless it's a localization in your country.

soldin07

You are right, Payment Method is a localization for Spain so I am afraid you will not be able to help me.

Thanks for all your effort.

Any help coming from the Spanish localization will be celebrated.

ara3n

I've seen the localization for Spain and the payment method is not used the way you want it to.

I had to merge it with US version for a client.

soldin07

Hello ara3n,

Sorry for the delay.

I have send a request to Microsoft and by now they have assummed it is an error for the spanish localization and has been scalated.

If you want I' ll keep you informed.

Thanks as always.

Tazzy1972

Or alternatively you can create a sales invoice instead of a sales journal. The system will automatically post the bank entries if the payment method is setup accordingly.