on 09-17-2008 6:36 AM
I want to display invoice and delivery document posting time
Help me out
Regards,
Vijay
Delivery
SELECT T0.DocNum,T0.DocTime FROM [dbo].[ODLN] T0 WHERE T0.DocDate >=[%0] AND T0.DocDate <=[%1] ORDER BY T0.DocNum
AR Invoice
SELECT T0.DocNum,T0.DocTime FROM [dbo].[OINV] T0 WHERE T0.DocDate >=[%0] AND T0.DocDate <=[%1] ORDER BY T0.DocNum
Jeyakanthan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
using query, you could do:
SELECT T0.[DocTime] FROM OINV T0
union all
select T1.[DocTime] from ODLN T1
Rgds,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Do you mean on PLD?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
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.