We are using GP 9 and have set up a credit card for purchasing. We prepay the balance immediately after receiving the statement. Since getting all the backup paper work is a challenge, the individual purchases are entered as invoices after-the-fact, and then "paid" with the credit card in Manual payments.
So my question is this: how do we get a remittance report to print when the invoices are applied to the prepayment?
In setup, we have checked YES to Print Previously Applied Documents on Remittance. So far this information has been printing on the NEXT prepayment check, which of course, it does not pertain to.
Any help would be most appreciated.
Not sure of the process your are using.
Typically a cheque is isssued from GP to the credit card company with the amount being unapplied. (Much like a deposit)
When the purchase invoices are entered you would go to the Apply Payables Documents window and match the payment to the invoices to reduce the unapplied amount. (This is also useful for knowing what amount of purchases is outstanding for the payement made)
You can then use the Cheque Information Report and select the Cheque Distribution Report.
Select the cheque number in your rang and print your report.
Should you require you can cahnge the report layout to meet your specific needs.
Hope this helps
Louis, I don't think you're going to get exactly what you want without a custom report. However, that may be pretty easy to create using this code from my blog: http://victoriayudin.com/2009/10/22/sql-view-for-payables-payment-apply-detail-in-dynamics-gp/.
Victoria Yudin - Dynamics GP MVP (2005-2015)
Want to use Excel, Crystal and SSRS with Dynamics GP? Check out GP Reports Viewer
This is a pretty awesome query Victoria! I just found it last week. (sorry to hijack the thread...I give it back now)
Thanks to all for your helpful comments and remarks. The Check Distribution report actually is adequate for
our needs at this time. The process suggested by Victoria will require some serious work on my part, but I'll work on it.
The work shouldn't be too serious. I converted Victoria's query into a Smartlist in about 10 minutes using Smartlist Builder.
Louis, if you are interested, below are some resources with instructions for creating a SmartList from a SQL view. Of course, this assumes you have SmartList Builder. If you do not, you could create a SQL view and then use it in any reporting tool of your choice, even Excel.
Steve Chapman's video: http://www.youtube.com/watch?v=sAnz1gzZHnk
My blog: http://victoriayudin.com/2009/04/20/how-to-use-a-sql-view-in-smartlist-builder/
Ron Wilson's blog: http://rldu.wordpress.com/2010/04/28/tips-and-tricks-6-how-to-use-sql-views/