The SQL on DynamicAccounting.net is designed to show you if you are
balanced. The idea is that once balanced, if you look at this every
day in a quick snapshot, when you are out of balance, you know what
day it happened and a day is easier to solve than a month. Simply do
this has dramatically reduced the amount of time we spend chasing
Feel free to email me if you try it an get stuck.
On Oct 31, 11:22 am, dexman77 <dexma...@xxxxxxxxx> wrote:
> On Oct 31, 8:59 am, Zarlot <Zarl...@xxxxxxxxx> wrote:
> > My problem is that reconciling between the "account transactions"
> > smartlist (filtered for a given month) for the receivable account is
> > time-consuming. I reconcile to the "receivables transactions...cash
> > received today" filtered for a given month...for the credit side ...
> > then for the debit side, I reconcile to "Sales transactions.... *"
> > This is difficult b/c there is not a common field between these
> > tables. For example, the "account transactions" SmartList has J/E #s,
> > but of course the customer-level tables do not. Am I using the right
> > SmartLists? I'm very new to GP, so any help would be appreciated.
> > Thanks,
> If you are comfortable with using SQL, Dynamic Accounting
> (www.dynamicaccounting.net) has information to balance subledger the
> the GL in the SQL section on the side bar.