web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

AP discounts taken distribution

(0) ShareShare
ReportReport
Posted on by 135

I have a GP client that wants their term discounts taken to post to the distribution PURCH account(s) instead of the one account setup in Posting Accounts.  Does anyone know of an ISV that has a product that would handle this?  

Thanks!

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    65,271 on at

    Hi,

    Just to make sure I understand the question. Your customer gets a vendor invoice with terms available.

    The normal distributions are:

    DR: Purch Account

    CR: Accounts Payable

    CR: Discounts Available

    When the Vendor is paid, the normal distributions are:

    DR Accounts Payable

    DR Discounts Available

    CR Discounts Taken

    CR Cash

    Your client wants the Discounts Taken account to be the same as the Purch account. So, the system needs to look back at the original invoice and pick up the original Purch account to credit. What happens if there is more than one Purch account on the original transaction?

    Am I understanding this correctly?

    Kind regards,

    Leslie

  • soma Profile Picture
    24,410 on at

    Leslie, I think your understanding is correct. But, if we use more than one purchase account for the transactions, then will if affect the AP Trail Balance?

  • L Vail Profile Picture
    65,271 on at

    Soma,

    Not at all. I could buy stuff from a vendor and debit it to a bunch of different accounts.  Just think of how most companies handle their AMX bills. How would it affect the AP Trial balance? I owe them the money no matter where the debit goes.  The AP trial balance is going to show the full amount of the purchase, the discount available/taken are assigned to other accounts for the GL only, it doesn't have anything to do with the AP trial balance. If they don't want to deal with separate discount accounts, they should uncheck that box in the AP setup window.

    I thought they wanted the discount available accounting treatment and only wanted to change the discount taken account. I could certainly be wrong about that; we'll soon find out :)

    Kind regards,

    Leslie

  • soma Profile Picture
    24,410 on at

    Leslie, thanks for your valuable updates.

  • Community Member Profile Picture
    on at

    Question for Leslie on this topic...If I don't want the discounts available accounting treatment and uncheck that option in the setup window, do I still need to set up a discounts taken account?  How is the discount handled in the GL if I don't care to track it?

  • Community Member Profile Picture
    on at

    Hi All I have a question on Payment Term and Term Discount Allowed and Term Discount Taken in GP. I have set up a Payment Term as 1/10N30.

    As per payment term if I import Invoice on or before discount available date GP is calculating Discount and also recording it in Term Discount Taken and added in distribution.

    If I import invoice with same payment term after Discount available date, GP is calculating Discount available and keeping Term Discount Taken as 0 also not carrying the distribution But while posting it is showing Distribution Error.

    Can someone let me know why GP is showing this Distribution Error?

    Is there any internal setting available in GP where GP should show available discount as zero as I am importing Old dated invoice?

    Your advise will be h

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans