Skip to main content
Microsoft Dynamics GP forum
Suggested answer

table to store credit memo information

editSubscribe (0) ShareShare
Posted on by UG Leader


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. 

  • Suggested answer
    Nicole Hellerud Profile Picture
    Nicole Hellerud 1,710 on at
    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

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…


Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,068 Super User

Martin Dráb Profile Picture

Martin Dráb 222,591 Super User

nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans