Great Plain (GP 2013)

I have removed all of the default accounts at the vendor level for "discounts available"  The default is set at the system level and the changes were rolled down. I have 5 vendors out of 1000 that is not pulling the default account information from the system level. It should be pulling '0000-2099' and it is pulling '0000-9010' when AP is inputting an invoice for one of the vendors. Where is GP pulling this account from.  '0000-9010' does exist but is not set as the default for the vendor class in Setup!
pstreAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Steve EndowMicrosoft MVP - Dynamics GPCommented:
Hi,

I saw that Victoria helped you clear out the default accounts via SQL.

If you open the Vendor Maintenance window for one of the vendors that is still defaulting to the 0000-9010 account, then click on the Accounts button, do you see an account in the Terms Discount Available field?  Or is it blank?

Vendor Accounts
Thanks,

Steve Endow
Microsoft MVP - Dynamics GP
Dynamics GP Certified IT Professional
0
pstreAuthor Commented:
It is not blank on the vendor card -- it has '0000-9010' and I have no idea where it is pulling that from.  On the vendor class in setup, the default account is '0000-2099'
0
Steve EndowMicrosoft MVP - Dynamics GPCommented:
Hi,

The Terms Discount Available account on the vendor record is stored in the Vendor Master table PM00200.

I have done some tests where certain changes to a Customer Class ID did not properly roll down to all customers, so if you tried to roll down the account values from the vendor class, I'm guessing that might be the cause.

Here is a query to lookup the Terms Discount Available account index for those vendors with account 9010:

SELECT v.VENDORID, v.PMDAVIDX, gla.ACTNUMST 
FROM PM00200 v
JOIN GL00105 gla ON gla.ACTINDX = v.PMDAVIDX
WHERE gla.ACTNUMST LIKE '%9010%'

Open in new window


Note the PMDAVIDX account index value.

Next, get the account index value for your 2099 account, if you don't know it already:

SELECT ACTINDX FROM GL00105 WHERE ACTNUMST = '0000-2099'

Open in new window


Make sure you have a good backup.  You can then update the Discount Available index to the correct value for vendors in that particular class.

UPDATE PM00200 SET PMDAVIDX = <correctindex> WHERE PMDAVIDX = <incorrectindex> AND VNDCLSID = 'vendorclassid'

Open in new window


After making that change, open the vendor record in GP and click on the Accounts button to confirm all looks well, and perform any additional checks to confirm the accounts are correct.

Let me know if that works or if I missed any steps.

Thanks,

Steve Endow
Microsoft MVP - Dynamics GP
Dynamics GP Certified IT Professional
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Steve EndowMicrosoft MVP - Dynamics GPCommented:
I just re-read your original post and see that you only have 5 vendors with the issue.

If that is the case, it's just as easy to just fix the vendors through the GP vendor maintenance window.

Thanks,

Steve Endow
Microsoft MVP - Dynamics GP
Dynamics GP Certified IT Professional
0
pstreAuthor Commented:
We don't want defaults on the vendor maintenance window -- they are set at the system level AND I tested last night and there are many others not working.  If I look at the vendor card, the discount account is blank (which it should be) but when I input an invoice and go to distributions, this is where I see the incorrect account.
0
Steve EndowMicrosoft MVP - Dynamics GPCommented:
Thanks for the information.  So the vendors do NOT have a default account, but invoices are defaulting to an account other than the system / company default?  And this is only occurring for 5 out of 1,000 vendors?  

That is definitely odd, as the default account logic should be pretty simple.

Let me do a SQL trace to see if I can capture the queries that retrieve the default vendor accounts.

Are there any GP customizations or SQL customizations (triggers, etc.) in the GP environment that could possibly be modifying the distribution accounts?
0
pstreAuthor Commented:
Our GP partner helped us. The posting accounts setup had to be updated.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pstreAuthor Commented:
I was not getting close to the answer with EE so I contacted our GP partner for the answer. I gave the answer in my list so that Steve E would know for the future.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.