What is owed to me, in Microsoft Dynamics GP?

This video shows how to create Microsoft Dynamics Customer Billing Statements, including the steps necessary to run prior to creating statements.

Originally Posted on 2/7/2011 – This is a reposting as my blog URL has changed since it was originally posted.

This video shows how to create Microsoft Dynamics Customer Billing Statements, including the steps necessary to run prior to creating statements.

Dynamics GP Customer payment applied to the wrong invoice?

OK, a customer called me on Friday when they realized that a payment from a customer was entered, applied to an invoice and posted in Microsoft Dynamics GP. Later they realized that it was applied to the wrong invoice. Could they correct it?

Originally Posted on 2011- This is a reposting as my blog URL has changed since it was originally posted.

OK, a customer called me on Friday when they realized that a payment from a customer was entered, applied to an invoice and posted in Microsoft Dynamics GP. Later they realized that it was applied to the wrong invoice. Could they correct it?

If the payment AND invoice has the status of OPEN (opposed to HIST or WORK), the payment can be reapplied to another OPEN invoice. If either the payment or the invoice is anything other than OPEN, you cannot change how the items are applied.

If both are OPEN, Open the Apply Sales Documents Window, open the customer and look up the Document that reduces the customer balance. From here you can click Unapply at the top or manually unapply one item at a time and apply the payment/return to a new invoice.

Summarize what is owed to me from Microsoft Dynamics GP, in Excel Please

This video shows how to create a Microsoft Dynamics GP Summary Aged Trial Balance using Excel Refreshable Reports.

Originally Posted on 2/8/2011 – This is a reposting as my blog URL has changed since it was originally posted.

This video shows how to create a Microsoft Dynamics GP Summary Aged Trial Balance using Excel Refreshable Reports.

You’re past due, now pay.. Sincerely yours, Microsoft Dynamics GP

This video how to use the Microsoft Dynamics GP Letter Writing Wizard for Microsoft Office Word to create Collection Letters for past Due invoices from the Receivables Management Module.

Originally Posted on 2/15/2011 – This is a reposting as my blog URL has changed since it was originally posted.

This video how to use the Microsoft Dynamics GP Letter Writing Wizard for Microsoft Office Word to create Collection Letters for past Due invoices from the Receivables Management Module.

Using Excel, give me the detail from Microsoft Dynamics GP

This video shows how to create a Detailed Aged Trial Balance for Microsoft Dynamics GP Receivables Management using Excel Refreshable Reports with Pivot Tables. Watch this when you have time, it’s about 15 minutes long!

Originally Posted on 2/10/2011 – This is a reposting as my blog URL has changed since it was originally posted.

This video shows how to create a Detailed Aged Trial Balance for Microsoft Dynamics GP Receivables Management using Excel Refreshable Reports with Pivot Tables. Watch this when you have time, it’s about 15 minutes long!

Prove the Cash Balance in Microsoft Dynamics GP

Need to balance the cash as of the last day of last month? Use the Microsoft Dynamics GP  Checkbook Balance Inquiry window.

Originally Posted in 2011 – This is a reposting as my blog URL has changed since it was originally posted.

Need to balance the cash as of the last day of last month? Use the Microsoft Dynamics GP  Checkbook Balance Inquiry window.

Enter the date range BEFORE entering the Checkbook ID. Data begins populating as soon as the Checkbook is entered, and if there is a lot of transactions, you might end up waiting before having the opportunity to enter the date range.

In the top right hand corner is the Current Checkbook Balance, which is what Bank Reconciliation has as of now, and below that is the Current Cash Account Balance, which is what the General Ledger has in it now. At the bottom the Bank Balance for the ending date range you enter will be displayed. Use the print icon in the top right corner to print the detail to support your Balance Sheet.

Using Microsoft Dynamics GP, how are we doing against Budget?

Use the Inquiry window “Budget vs. Actual” in the Microsoft Dynamics GP Financial Series to look at the actual expenses for 1 General Ledger Account compared to 1 budget.

Originally Posted in 2011  – This is a reposting as my blog URL has changed since it was originally posted.

Use the Inquiry window “Budget vs. Actual” in the Microsoft Dynamics GP Financial Series to look at the actual expenses for 1 General Ledger Account compared to 1 budget.
You’ll see the variance in dollars and as a Percent!

It’s not “Letter” perfect, change it. Microsoft Dynamics GP Letter Writer

This video how to use the Letter Writing Wizard edit an existing letter for Customers in Microsoft Dynamics GP from the Receivables Management Module.

Originally Posted on 2/16/2011 – This is a reposting as my blog URL has changed since it was originally posted.

This video how to use the Letter Writing Wizard edit an existing letter for Customers in Microsoft Dynamics GP from the Receivables Management Module.

Can I change the Vendor ID in Microsoft Dynamics GP?

This video how to use the Professional Services Tool Library to change a Vendor ID or any master ID record in Microsoft Dynamics GP.

Originally Posted 2/17/11 – This is a reposting as my blog URL has changed since it was originally posted.

This video how to use the Professional Services Tool Library to change a Vendor ID or any master ID record in Microsoft Dynamics GP.

 

 

Microsoft Dynamics GP Payables Holds

This video discusses Vendor Holds and Microsoft Dynamics GP Payables Invoice Holds. It also uses SmartList to help manage holds.

Originally posted 3/2/11

This video discusses Vendor Holds and Microsoft Dynamics GP Payables Invoice Holds. It also uses SmartList to help manage holds.

This is a reposting as my blog URL has changed since it was originally posted.

Continue reading “Microsoft Dynamics GP Payables Holds”