Victoria Yudin

September 2009 - Posts

• 0 Comments 654 Views

  History of Dynamics GP Do you still call it Great Plains because you’re so used to it? Or is Dynamics GP the only name you’ve ever used? In either case, you may find looking over the timeline of Dynamics GP that DynamicsWorld UK put together very educational and... Read More... Published: Wednesday, September 30, 2009, 04:25 AM Tags: Dynamics GP, Microsoft MVP

• 0 Comments 712 Views

  SQL view for all posted Payables payments in Dynamics GP This view is in response to more than a few inquiries I have had for a vendor check report. This view brings in all payments, not just checks, so if only checks are needed, add the following to the end of the WHERE clause: AND P.PYENTTYP = 0 For other... Read More... Published: Friday, September 11, 2009, 02:21 AM Tags: Payables, SQL code, Dynamics GP, GP Reports, GP SQL scripts, GP SQL view, Crystal Reports, SmartList Builder

• 0 Comments 738 Views

  What’s with all these dates? There are many different dates stored in Dynamics GP. This is typically a good thing, my philosophy is that it is always better to have more data than you need and not the other way around. However, it can get confusing rather quickly since a lot of the... Read More... Published: Tuesday, September 08, 2009, 05:59 AM Tags: Purchase Order Processing, Bank Reconciliation, Receivables, Payables, General Ledger, Dynamics GP, Sales Order Processing

• 0 Comments 923 Views

  SQL view for all unapplied Receivables transactions in Dynamics GP Here is a SQL view that will return all unapplied Receivables transactions in Dynamics GP. This will calculate how many days overdue unapplied transaction are. If something is not overdue, or if it is a credit transaction (payment, credit or return) the... Read More... Published: Saturday, September 05, 2009, 08:38 AM Tags: Receivables, SQL code, Dynamics GP, GP Reports, GP SQL scripts, GP SQL view, Crystal Reports, SmartList Builder