Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / PM40103 table is empty...
Microsoft Dynamics GP (Archived)

PM40103 table is empty in Dynamics GP 2015 R2

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I was wondering if anyone else has seen this before.  While writing a SmartList Builder report to return AP distribution information, I added in table PM40103 and quickly found that for a client this table was empty.  We are not sure how or why this table is empty, and in searching for possible articles on this topic I wasn't able to find anything.  For now, I have updated the SmartList for the Distribution type (DISTTYPE) under Set Field Options with the values and long description but wanted to check with any other Dynamics GP experts to see if continuing to keep this table empty will or would be affecting GP functionally in any way? 

Thank you for any feedback you may have.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: PM40103 table is empty in Dynamics GP 2015 R2

    Jen, thank you for your feedback and looking as well.  My guess also was that if this client has been running along without issues that it must be ok and as you mentioned it is all embedded in code.  Appreciate your time.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: PM40103 table is empty in Dynamics GP 2015 R2

    Mariano, thank you for the feedback.  I did check SQL and it was empty, sorry if I didn't state that in my original post.  Also, thank you for the script to repopulate the table.  Much appreciated!

  • Jen Kuntz Profile Picture
    Jen Kuntz 3,220 on at
    RE: PM40103 table is empty in Dynamics GP 2015 R2

    For what it's worth: that table is also empty on my installation. My guess is the actual list is embedded in code and thus the table itself isn't necessary for GP to function.

  • Suggested answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: PM40103 table is empty in Dynamics GP 2015 R2

    I would suggest you check the table directly in SQL Server Management Studio. However, if this was an accidental deletion, you could run the following to repopulate the table:

    TRUNCATE TABLE PM40103;
INSERT PM40103(DISTTYPE, DSNMSHRT, DSNMLONG) VALUES (1, 'CASH','CASH');
INSERT PM40103(DISTTYPE, DSNMSHRT, DSNMLONG) VALUES (2, 'PAY','Accounts Payable');
INSERT PM40103(DISTTYPE, DSNMSHRT, DSNMLONG) VALUES (3, 'AVAIL','Discounts Available');
INSERT PM40103(DISTTYPE, DSNMSHRT, DSNMLONG) VALUES (4, 'TAKEN','Discounts Taken');
INSERT PM40103(DISTTYPE, DSNMSHRT, DSNMLONG) VALUES (5, 'FNCHG','Finance Charge');
INSERT PM40103(DISTTYPE, DSNMSHRT, DSNMLONG) VALUES (6, 'PURCH','Purchases');
INSERT PM40103(DISTTYPE, DSNMSHRT, DSNMLONG) VALUES (7, 'TRADE','Trade Discounts');
INSERT PM40103(DISTTYPE, DSNMSHRT, DSNMLONG) VALUES (8, 'MISC','Miscellaneous');
INSERT PM40103(DISTTYPE, DSNMSHRT, DSNMLONG) VALUES (9, 'FREIGHT','FREIGHT');
INSERT PM40103(DISTTYPE, DSNMSHRT, DSNMLONG) VALUES (10, 'TAXES','TAXES');
INSERT PM40103(DISTTYPE, DSNMSHRT, DSNMLONG) VALUES (11, 'WRITE','Write Offs');
INSERT PM40103(DISTTYPE, DSNMSHRT, DSNMLONG) VALUES (12, 'OTHER','OTHER');
INSERT PM40103(DISTTYPE, DSNMSHRT, DSNMLONG) VALUES (13, 'GST','GST');
INSERT PM40103(DISTTYPE, DSNMSHRT, DSNMLONG) VALUES (14, 'PPS','PPS');
INSERT PM40103(DISTTYPE, DSNMSHRT, DSNMLONG) VALUES (15, 'UNIT','UNIT');


    Be sure to test this out first, then backup your production environment and run against it.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans