Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

GP - Accounts Payable Summary Window

Posted on by 180

Dear All,

First of all... HAPPY NEW YEAR TO ALL!!!

Regarding my question, in Payable Summary Inquiry window, i just wanted to know the difference between Original amount balances and unapplied amount balances? As far as I think, the balances as per these should be same, but they are not. Can anyone tell me the difference between the two and the probable reasons when these balances will be different.

Please help!!!

 

Regards,

Mohid

*This post is locked for comments

  • Mohid Profile Picture
    Mohid 180 on at
    Re: GP - Accounts Payable Summary Window

    My apologies Frank... You are right.

    Thanks for your time and advise.

     

    Regards,

    Mohid

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Re: Re: Re: Re: GP - Accounts Payable Summary Window

    Mohid, respectfully - no, the Original Amount is the original, full amount of the invoice.  The Unapplied Amount is the Original Amount less any payments applied to it.  Test it in your system by posting a partial payment against an open invoice and you'll see this is the case.

  • Mohid Profile Picture
    Mohid 180 on at
    Re: Re: Re: Re: GP - Accounts Payable Summary Window

    Hi Frank,

    In the example which you have given above, the remaining balances (Invoice amount - Payments) should be same for both Original Amount balance and unapplied amount balance (i.e, Original amounts balance = 100 & Unapplied amount balance = 100). In the Payable summary Inquiry window, we have two columns, one for Original amounts and another for Unapplied balances. There are amounts mentioned for each type of entry (Invoices, payments, Debit notes, Credit notes etc.) At the end where balances are mentioned, there the two balances are not matching.

    As MG said, it may be due to problem with interruption in batch posting. I will try to check the links and reconcile vendor accounts and see if this will help.

    Thanks for your help and advise.

    Regards,

    MOhid

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Re: Re: Re: GP - Accounts Payable Summary Window

    Mohid,

    There may be circumstances when the unapplied amount is wrong. If you have suffered a system failure in middle of a posting or a batch was interrupted for some reason the unapplied amount can be incorrect. In these cases you may want to run a Check Links on your Payables history files and a reconcile of your vendor accounts. If you are unfamiliar with these procedures, please contact your Microsoft partner.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Re: Re: GP - Accounts Payable Summary Window

    Mohid, the explanation I gave IS why the amounts would be different.  Do you understand the term 'Unapplied'?  It means the amount of an invoice that has not had a payment assigned to it.

    Say you had a $1,000.00 invoice and $900.00 of it had been paid.  The $900.00 payment was 'Applied' to the $1,000.00 invoice.  The remaining $100.00 is the 'Unapplied' amount.

    In this case, the Original Amount would be $1,000.00 and the 'Unapplied' amount would be $100.00.

  • Mohid Profile Picture
    Mohid 180 on at
    Re: Re: GP - Accounts Payable Summary Window

    Hi Frank,

    Thanks for the help. Can you also advise me why the balances as per these would show different amounts sometimes?

     

    Regards,

    MohidFinancial Analyst  ASGHAR ALI & SONS CO. WLLPost Box No. 104Manama, Kingdom of BahrainE-Mail: mohid@asgharali.com

     

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: GP - Accounts Payable Summary Window

    Mohid, the Original Amount reflects the original invoice amounts.  Unapplied Amount is the net value of invoices remaining that have not yet had payments applied against them.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans