on 04-25-2007 6:07 AM
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 ,
Hi,
Here's the query with the BP account balance added. I'm not sure what you mean by the 'checks on account amount'. Please clarify.
select
T0.DocNum, T0.CardCode, T0.CardName,
T0.DocDate, T0.DocDueDate, T1.Balance
from
OINV T0
inner join OCRD T1 on T0.CardCode = T1.CardCode
where
datediff(dd, T0.DocDueDate, getdate()) >= 0
and T0.CANCELED = 'N'
and T0.PaidToDate < T0.DocTotal
Kind Regards,
Owen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.