Account category number in ACCOUNTS SUMMARY

(0) Share

Report

Posted on by Anantha Rajkumar

When the Accounts Summary smart list is opened in EXCEL through a ODBC link, the ACCOUNT CATEGORY NUMBER shown is different from the ACCOUNT CATEGORY NUMBER shown when you open the Smart list in GP.

Actually, the category numbers shown on the ODBC link is not entered in any master in the GP. System throwing some new names.

Do you have any idea as why this is happening?

*This post is locked for comments

All responses (3)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: Account category number in ACCOUNTS SUMMARY

Did you modify the original account categories? Can you post examples of values in the smartlist and their corresponding value when you get at the data through ODBC?

Best regards,
K Day 7,365 on at

Like (0)

Report

Re: Account category number in ACCOUNTS SUMMARY

Are you getting an actual number? Check out the GL00102 Table, this stores the Account Categories. It has the Number, Description and DEX ROW ID
Jen M. 350 on at

Like (0)

Report

Re: Account category number in ACCOUNTS SUMMARY

Hello,

Please reference the Microsoft Dynamics GP Knowledge Base to potentially resolve this issue you are experiencing. There are a number of documents that could potentially assist in resolving your issues. To view the Knowledge Base on CustomerSource you will need to be enrolled in a Microsoft Dynamics service or support plan. To find out if you are enrolled in a service or support plan or for more information please contact your Microsoft partner.

Thanks

Jen

This posting is provided "AS IS" with no warranties, and confers no rights.