Tag: accounts-receivable

SQL view for unpaid SOP Transaction with no. overdue days

| 05/08/2012 | 0 Comments
SQL view for unpaid SOP Transaction with no. overdue days

Recently one of my customer asked me to create a script to shows all open (unpaid) sales transaction with the total number of days overdue based on the current system date and customer’s payment terms.

Continue Reading

Customer Credit Summary: Average Days To Pay

Customer Credit Summary: Average Days To Pay

I received an email today with a query on GP’s “Average Days To Pay” on a Customer’s Credit Summary. Query is : How GP calculates Average Days To Pay for a customer?

Continue Reading

Refund Cash to customer

| 10/17/2010 | 0 Comments
Refund Cash to customer

Refund Cash to customer In Dynamics GP have option for “Refund to Customer” (Transactions–> Sales–> Refund Checks) but

Continue Reading