Update MasterAccounts
Set BilledThru = PaidThru
This will copy the paid through date to the billed through date. This would
affect when an invoice was created....correct?
Thanks,
Jason
Jason Powell wrote:
>
> I need to make the paid through date equal to the billed through date
under
> master accounts. Because they are not the same, it is not creating
> invoices.
>
> Here is the question - I wanted to make sure this statement was ok to use
> before I mess it all up.
>
> Update MasterAccounts
> Set PaidThru = BilledThru
>
> Is this right???? I'm far from a SQL newbie :)
That is correct. However, Emerald doesn't use the PaidThru
date for any billing or calculations, so I don't see it
changing anything.
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list, including removal,please see http://www.iea-software.com/maillist.html
For more information about this list, including removal,please see http://www.iea-software.com/maillist.html