Cách truy vấn các A...
 
Notifications
Clear all

Cách truy vấn các AP Invoice được nhập mà không tham chiếu chứng từ nào

1 Posts
1 Users
0 Likes
275 Views
admin
Posts: 336
Admin
Topic starter
(@admin)
Prominent Member
Joined: 3 years ago

Câu truy vấn: 

SELECT T0."DocNum", T1."ItemCode", T1."Dscription", T1."LineStatus", T1."BaseLine", T1."BaseEntry", 
T1."BaseType", T1."BaseRef" 
FROM OPCH T0 INNER JOIN PCH1 T1 ON T0."DocEntry" = T1."DocEntry" 
WHERE T1."BaseType" = '-1' and T0."DocDate" >= '[%0]' and T0."DocDate" <= '[%1]'
Reply
Share:
x  Powerful Protection for WordPress, from Shield Security
This Site Is Protected By
Shield Security