table to store credit memo information

(0) Share

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

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Nicole Hellerud 1,712 on at

Like (0)

Report

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

Was this reply helpful? Yes No