Payment Methd Bal. Account not considered in journal posting

soldin07
soldin07 Member Posts: 6
edited 2008-02-04 in NAV/Navision Classic Client
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,

Comments

  • ara3n
    ara3n Member Posts: 9,258
    Payment method is a field in journal. So you have to select the balancing account type and balancing account No.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • soldin07
    soldin07 Member Posts: 6
    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
    ara3n Member Posts: 9,258
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • soldin07
    soldin07 Member Posts: 6
    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
    ara3n Member Posts: 9,258
    No it's not possible. Also Payment method is not a standard field in Gen Journal.
    Unless it's a localization in your country.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • soldin07
    soldin07 Member Posts: 6
    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
    ara3n Member Posts: 9,258
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • soldin07
    soldin07 Member Posts: 6
    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
    Tazzy1972 Member Posts: 18
    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.

Categories