Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Linking a Credit to a Check
I would expect the link to be made in PM30300 using the following criteria: doctype = '5' and aptodcty = '6' But this returns no records. The only records I seem to be able to find are linking a Credit to an Invoice and an Invoice to a Check. I don't believe this is a reliable way to link a...- adhlssu07
- Thread
- Replies: 2
- Forum: Microsoft: Dynamics GP (Great Plains)
-
Linking a Check from PM30300 to PM30200
Victoria, Thanks so much! Your blog has been hugely useful, and I looked at this post and didn't think it did what I wanted... I'm taking a closer look.- adhlssu07
- Post #3
- Forum: Microsoft: Dynamics GP (Great Plains)
-
Linking a Check from PM30300 to PM30200
Hello, I am working on using SQL in GP10 to pull the following information for all of the invoices on a particular check: Invoice Number (docnumbr?) Outstanding Amount (?) Net Paid Amount (APFRMAPLYAMT?) Discount Taken (APFRMDISCTAKEN) Net Check Amount (?) I also need information off of the...- adhlssu07
- Thread
- Replies: 3
- Forum: Microsoft: Dynamics GP (Great Plains)
