Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

National Accounts - what are they for

Posted on by 22,647

Ok, so I have a client that has a series of customers that all act like a buying club in one sense that this client of mine looks at the sales to all the group members and adjusts the 'discount' offered to all of them based on the group sales volume.

While that is something we can manage by looking at Sales Transactions by Customer we were looking at the opportunity of speeding up the Cash Reciepting process.  Reason is that they also all pay from one primary Customer ID. 

Now before someone yells out - ADDRESS ID for each of the different customer groups - the problem is that for legal reasons they have to manage each as a separate record.   Therefore a unique customer id.

We group them best we could in the ID Area by making the ID standard so they all start with AA(then unique) and there are no other customers in that range that are not part of the group.

We were discussing how to make this faster and what one of the staff asked was 'What are National Accounts'

Now after setting up the PARENT ID - blank new customer ID - and attaching the CHILD accounts I proceeded to post a number of invoices for the CHILD accounts.  We excitment in the air, I then went to CASH RECIEPTS entered the PARENT ID and the amount of the payment recieved - 10,000 - and then clicked on APPLY.

The spoiler to the story is that the expectation was to see a list of the invoices I had just posted for all the CHILD accounts here - but, alas and I should have known better - the screen was BLANK.

The only place that I could see any consolidation was back up under the CARDS >> NATIONAL Accounts >> enter the Parent and the list of CHILD records shows up and the amounts of the invoice are there.

I could (1) find no reports that allowed me to select the PARENT ID (2) found no screen where I could enter data by PARENT and distribute to CHILD.

So I ask the community - have I missed the boat here - what the heck is NATIONAL ACCOUNTS for?

Confused, dazed and concerned.

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: National Accounts - what are they for

    Hi Bill,

    I agree that National Accounts is deceptive in how far you can get with the module before you realize you do not own it. There are a couple of modules like this - and lots of third party products. When you say 'like the roll up', what are you referring to?

    Kind regards,

    Leslie

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    Re: National Accounts - what are they for

    Wow my bad on this - I did some testing in my standalone install of GP 10 and the Fabrikam company - worked as discussed.  Client and I discussed the National Accounts sometime ago - the menu option is there - the question was asked - they set up a number of National Account parents and then tried to use it.

    Looked at registration keys - it is not there - and confirmed not registered to them.

    How is it possible then that all the functions work in the system like the roll up - but the cash receipt split does not work - found that interesting.

    thanks to everyone that jumped in on this - so, until they decide they want to purchase the module, then we will put this on hold for now.

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: National Accounts - what are they for

    Thanks Victoria,

    The best first question - is it turned on!

    I'm assuming the checkbox I referred to is checked (that's the default anyway). Bill is right in thinking National Accounts should work the way he expects. I tested the posting theory and you are correct, any invoices I posted before the National Account relationship was set up were available during cash receipts.

    Bill - how did it work in Fabrikam?

    Kind regards,

    Leslie

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: National Accounts - what are they for

    Richard,

    I am sorry, I don't think that's the case.  Just tested in GP 2010 - created a brand new customer called PARENT, assigned a bunch of existing customers as children of PARENT, some with existing balances.  Created a Cash Receipt for PARENT, a slew of invoices show up on the Apply window.  I am pretty certain I have done this in the past with older versions of GP as well, but I would have to test to say definitively.

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: National Accounts - what are they for

    Well, your problem is you are associating the accounts AFTER the invoices are posted.  National accounts will post invoices generated by child customers to the national account AT THE TIME THE INVOICE IS POSTED.  Then, you will be able to apply a payment through the parent customer id.

    As for the transition, you can either let the current invoices work their way out, applying payments to the individual customer accounts until they are paid off, or void them and re-invoice, forcing a simular invoice number such as INV1234-a when the original was INV1234.

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: National Accounts - what are they for

    Bill, both your expectation and Leslie's answer are correct.  Something is not working quite right for whatever reason to cause what you are describing.  Are you testing this in a GP company with National Accounts enabled and registered?  If the answer to this is no, then you should be able to test this in Fabrikam, but not in a live company.  

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    Re: National Accounts - what are they for

    Leslie, the challenge with your reply is that (1) this is not happening for us (2) if this is how it is designed - not to display the result then so be it - but, I think that your answer is incomplete.

    Please note that when we enter the Parent ID we get nothing showing in the apply window.  Our expectation and the expectation you set is that the CHILD invoice amount should be appearing.

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: National Accounts - what are they for

    Bill,

    I think what you described is exactly why people use National Accounts. On the National Accounts Maintenance window under Options, is the first checkbox 'Allow Receipts Entry for Children of the National Account' marked? As far as I know, this is the ticket to accomplish what you have described.

    Kind regards,

    Leslie

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans