Question Status

Unanswered
Louis C Woolums asked a question on 5 May 2010 11:12 AM

 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.

 

 

Reply
Sagi88 responded on 5 May 2010 6:01 PM

Hi Louis.

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

Reply
Victoria Yudin responded on 6 May 2010 4:50 AM

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/.

Reply
Ron Wilson responded on 6 May 2010 5:45 AM

 This is a pretty awesome query Victoria!  I just found it last week.  (sorry to hijack the thread...I give it back now)

Ron Wilson Real Life Dynamics User http://rldu.wordpress.com
Reply
Louis C Woolums responded on 11 May 2010 11:03 AM

 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.

Thanks again,

Louis Woolums

Reply
Ron Wilson responded on 11 May 2010 12:23 PM

 Louis,

 The work shouldn't be too serious.  I converted Victoria's query into a Smartlist in about 10 minutes using Smartlist Builder.

 Ron

Ron Wilson Real Life Dynamics User http://rldu.wordpress.com
Reply
Victoria Yudin responded on 12 May 2010 3:36 AM

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/

Reply