Re: [Emerald] Re: Emerald.exe 2.5.322

PowerNet ( (no email) )
Thu, 02 Mar 2000 14:35:01 -0500

Dale this script returns and invoice error.

*********** REPLY SEPARATOR ***********

On 2/26/00, at 3:39 PM, Dale E. Reed Jr. wrote:

>PowerNet 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=
> 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.
>For more information about this list (including removal) go to:

For more information about this list (including removal) go to: