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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
nedd name of payment history file
Hi, Sorry about that, RM30201 is a "history" table and RM20201 is an "open" table. RM30201 should get populated when you run "Paid Transaction Removal" (Sales Routines). Could you use the "SLPRSNID" from the header tables? RM20101 for "open" documents, and RM30101 for "history" documents... :-)- minerva9
- Post #6
- Forum: Microsoft: Dynamics GP (Great Plains)
-
Line Item Status
FYI... You sometimes can get the meaning of a field's value by going to Tools>Resource Descriptions>Tables, search on your product and series (and I usually view by Table Physical Name for ease of reference). Double-click on the table you want to get to Table Descriptions and there you'll find...- minerva9
- Post #4
- Forum: Microsoft: Dynamics GP (Great Plains)
-
nedd name of payment history file
If you are on v5.5, you won't have Smartlist. The table that has the invoice and payment info is RM30201. The APTODCNM is your invoice#, APFRDCNM is the payment#, and the APPTOAMT is the part of the payment applied (paid) to your invoice. You can check out your data either via sql/access...- minerva9
- Post #4
- Forum: Microsoft: Dynamics GP (Great Plains)
