I tried the query you sent(below) and got this error message.
Msg 170, Level 15, State 1
Line 15: Incorrect syntax near 'Invoice'.
*********** REPLY SEPARATOR ***********
On 2/26/00, at 3:39 PM, Dale E. Reed Jr. wrote:
>> I just spoke with my billing person in detail.
>> She is very confused. The reason she is confused is because we actually=
are using a manual list we check every day against the Emerald batch to=
make sure they match. It is correct with the 300 invoiced services.
>> We don't know where to start.
>> We just last week inventoried every customer file.
>> I have an idea to avoid creating all the invoices that may not be=
>> Is there an SQL query I can run to get me the detail of what the 327=
(196 invoices) batch was doing so I can print it out and look at it before=
we create all these invoices?
>Since a couple of people have had this question, I snagged to
>query from profiler. Its dynamically generated based on a
>what kind of batch you are trying to do (ie, renewals, cc,
>BT, invoices, etc).
>This is for Renewals. For CC, you need to change the PayMethod IN
>like to "Credit Card"
> SELECT ma.CustomerID
> FROM MasterAccounts ma, SubAccounts sa, BillingCycles bc
> WHERE ma.CustomerID =3D sa.CustomerID
> AND ma.BillingCycleID =3D bc.BillingCycleID
> AND ma.Active=3D1 AND sa.Active=3D1
> AND ma.PayMethod IN ('Invoice', 'Purchase Order', 'Renewal')
> AND (IBillDays >=3D DateDiff(Day, GetDate(), ma.BilledThru) OR BilledThru
> AND (maExpireDate>=3Dma.BilledThru OR AutoBill=3D1 OR maExpireDate IS=
> AND NOT EXISTS (SELECT InvoiceID FROM Invoices
> WHERE Invoices.CustomerID=3Dma.CustomerID
> AND Invoices.EndDate > ma.BilledThru
> AND Invoices.EndDate <> Invoices.StartDate
> AND Invoices.Type <> 'VOID'
> AND Invoices.Type <> 'Invoice' )
>Dale E. Reed Jr. Emerald and RadiusNT
>IEA Software, Inc. www.iea-software.com
>For more information about this list (including removal) go to:
For more information about this list (including removal) go to: