News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) credit notes

Microsoft Dynamics GP (Archived)

credit notes

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

where can I find the data of credit notes?

thanks

Sergio

*This post is locked for comments

All responses Img

All responses (4)

Answers Img

Answers (3)

Verified answer

soma 24,406 on at

Like (0)

Report

RE: credit notes

Hi Sergio,

This topic is still in open. Please mark it as verified, if your question solved. Because this will helps to some others who experience the same.
Verified answer

soma 24,406 on at

Like (0)

Report

RE: credit notes

Payables Transactions

1. PM10000 (Work - Saved Transactions)

2. PM20000 (Open - Open Transactions)

3. PM30200 (History - Completed/closed transactions)

Note: Filter the table with using DOCTYPE= 5 (Credit Memo)

Receivables Transactions

1. RM10301 (Work - Saved Transactions)

2. RM20101 (Open - Open Transactions)

3. RM30101 (History - Completed/closed transactions)

Note: Filter the table with using RMDTYPAL = 7 (Credit Memo)

Hope this helps!!!
Community Member Microsoft Employee on at

Like (0)

Report

RE: credit notes

thanks, but I would need to know the name of sql table
Verified answer

soma 24,406 on at

Like (0)

Report

RE: credit notes

Are you looking for Payable Credit notes? Receivable Credit Notes?

You can find the both in smartlist (Sales-->Receivable Transactions & Purchasing-->Payable Transactions) by filtering the document type = credit memo.

Note: You can also find the data in inquiry window and standard GP reports.

Hope this helps!!!

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,149 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans