Finance | Project Operations, Human Resources, ...

SOP Return Missing Under Transaction By Customer

(0) Share

Report

Posted on by CU07102115-0

We have a GL entry that drills down to a source document (SOP Return), which I can see exists in the SOP history table, however the transaction does not appear in the transactions list when looking up that customer's transaction in 'Transaction By Customer'. I took a look at the Return record in SQL, and nothing appears to be unusual about it. Anyone ever see this or have any suggestions? Thanks in advance for any assistance!

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

agaber on at

Like (0)

Report

Hello Justin-

Thank you for posting your question on the Forums. When doing the lookup, do you have all 3 options marked to include? (Work/Open/History) Have you tried to look this up by Document Number under the Receivables Transaction Inquiry window? If not, does it show there? If you still don't see it in these inquiries, try and run reconcile for this customer and see if that makes any difference or not.

Sales >> Utilities >> Reconcile

Let us know if you have any further questions. Have a great day!

Adam G.

Microsoft Dynamics GP

Was this reply helpful? Yes No
CU07102115-0 on at

Like (0)

Report

Hi Adam,

Thanks for the reply. To answer your questions, yes I had all three check boxes marked. I attempted to look the document number up by Transactions by Document inquiry, and it returned only one record - an invoice that happens to share the same document number as the return I'm looking for, but no return. I did run the reconcile tool against this customer - I'm not exactly sure which 'Reconcile' option should be chosen, but I ran every one that allowed me to specify a customer number. The result of every report was '0 customers'.

Was this reply helpful? Yes No
Joseph Markovich 3,976 on at

Like (0)

Report

Hi Justin-

Does the transaction show up in the RM20101 or RM30101 table? It sounds like it isn't there.

Joe

Was this reply helpful? Yes No
CU07102115-0 on at

Like (0)

Report

Hi Joe,

The transaction is in RM20101, but not RM30101. Thanks.

Was this reply helpful? Yes No
Suggested answer

agaber on at

Like (0)

Report

Hi Justin-

Thank you for the response. At this point you will want to open a support case so an engineer can review script results in SQL for all of the associated tables that this transaction should have data in. Have a great day!

Adam G.

Microsoft Dynamics GP

Was this reply helpful? Yes No