Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

-You can Select a diferent Docs order by date, date is a variable. The first date is for the start date search, the second date is for end date that you want to search.

SELECT T0.[DocNum], T0.[CardCode], T0.[CardName], T0.[DocTotal], T0.[DocDate] FROM OINV T0 WHERE T0.[DocStatus] Like 'O' AND

T0.[DocDate] BETWEEN [%0] AND [%1]

-This one help you to find Offer open sales quotation

SELECT T0.[SlpCode], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[LineTotal], T2.[SlpName] FROM OQUT T0  INNER JOIN QUT1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OSLP T2 ON T0.SlpCode = T2.SlpCode WHERE T0.[DocStatus] Like 'O' ORDER BY T2.[SlpCode]

-With this query you can find a purchase order when Doctype is 'S' and the mount is more a 2500

SELECT T0.[DocType], T0.[DocTotal] FROM OPOR T0 WHERE T0.[DocType] = 'S' AND

T0.[DocTotal]  > 2500

- You can add this query to alert, if you wanna know if your offer is more that 15000

SELECT T0.[DocNum], T0.[CardName], T0.[DocTotal], T1.[SlpName] FROM OQUT T0  INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode WHERE T0.[DocTotal] > 15000

You can add the functionality, you can adapt to your liking

REGARDS

Enrique Bravo

AGASYS S.A. de C.V.

1 Comment