Skip to Content
0
Former Member
Apr 25, 2007 at 05:07 AM

adding bp balance in following query

15 Views

hello sir,

u given me good solution but we want to add two rows in following query

1. business parner closing balance

2. checks on account amount.

select

DocNum, CardCode, CardName, DocDate, DocDueDate

from

OINV

where

datediff(dd, DocDueDate, getdate()) >= 0

and CANCELED = 'N'

and PaidToDate < DocTotal

regards ,