Skip to Content
author's profile photo Former Member
Former Member

How to do Over/Under Payment in SAP B1 9.0 version ?

Hi

I have tried to do overpayment of Rs. 1000 of document having document total 500. I did outgoing payment but the overpayment amount i.e 500/- goes to bank charges instead of Overpayment A/P account... so is it correct method to do overpayment ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Best Answer
    Posted on Jan 02, 2014 at 09:45 AM

    Hi,

    Please make sure you have defined above account under Administration-->Setup-->Financials--->G/L Account Determination---> Purchasing-->General tab.

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 11:13 AM

    Hi,

    I have tried to do overpayment of Rs. 960 of document having document total 1040. I did outgoing payment but the overpayment amount i.e 960/- goes to bank charges instead of Overpayment A/P…

    and in Currency setup i defined incoming amount diff.allowed=100,outgoing amount diff.allowed=100


    pastedImage_0.jpg (49.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 03, 2014 at 12:47 AM

    Hi,

    Please refer thread

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      Follow Joseph instruction. After entering excess amount, the system will update bank charge field automatically. Just remove this values ( over payment) and then add. Then there is no posting to bank charge account.

      As per your attached screen shot, just remove 960 from bank charge and system will through message, just give yes and then add the payment.

      Thanks & Regards,

      Nagarajan

  • Posted on Jan 02, 2014 at 09:35 AM

    Hi,

    The setting is available under the currencies setup.

    Check the Note No. : 1449444 as well.

    Kind Regards,

    Jitin

    SAP Business One Forum Team

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 09:12 PM

    Hi,

    This is system default setting for outgoing payment.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 04, 2014 at 07:53 AM

    Hi,

    Kindly explain how did you solved this problem?

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 04, 2014 at 10:30 AM

    hi

    i follow this it works but overpayment amount not goes to overpayment account.

    what to do so that amount goes to overpayment account

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Navanath

      Sorry for late reply.

      set Incoming and Outgoing Payment Difference allowed in Currencies setup

      set default sales and purchase overpayment underpayment accounts as miscellaneous accounts code in G/L Account Determination

      select total payment amount in full, go to payment means to enter an overpaid bank amount

      go to journal entry preview to read accounting entries

      Cr Bank Dr miscellaneous Dr AP Vendor

      Kedalene Chong

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.