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!
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
Hi Joe,
The transaction is in RM20101, but not RM30101. Thanks.
Hi Justin-
Does the transaction show up in the RM20101 or RM30101 table? It sounds like it isn't there.
Joe
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'.
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.
Let us know if you have any further questions. Have a great day!
Adam G.
Microsoft Dynamics GP
Share
Report
All responses (
Answers (
3,947