News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... table to store credit ...

Finance | Project Operations, Human Resources, ...

Suggested answer

table to store credit memo information

(0) Share

Report

Report

Posted on by Community Member

Hi,

I am looking for table information that stores information about Credit Memo Headers/Lines. Support customer (Not Vendor) returns somethings, there will be records created under credit note with all details like credit memo number, cust name, invoice number, salesID, qty returned, amount etc.

I searched and found that RM20101 - RM Open File is most appropriate but it does not have qty/item/unit price and amount related information. I also feel we may get these information from SOP10200 - Sales Transaction Amounts Work (where SOPTYPE = 4 - Return) but I am not sure.

Please guide us.

Thanks in advance.

Categories:

Microsoft Dynamics GP

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Nicole Hellerud 1,712 on at

Like (0)

Report

RE: table to store credit memo information

Hi Pawanbag-

Thank you for your post.

I'd consider looking into the following tables for this information:

SOP30200 - Sales Transaction History

SOP30300 - Sales Transaction Amount History

RM20101 - RM Open File

RM20201 - RM Apply Open File

RM30101 - RM History File

RM30201 - RM Apply History File

Please look at the above tables and let us know if there is other information you'd like that you do not see listed.

Best Regards,

Nicole Fiskum

Support Engineer

Microsoft Dynamics

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,245 Super User 2025 Season 1

#2

Martin Dráb 231,923 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans