Report of Sales

[Former Member]

Respected Sir/Madam,

I have a small Issue one of my enduser is working on Sale Quotation.He has done overall 25 Quotatoins per day.By the end of the day he wants to see only those Quotatins that has done by him of that particular date.How it could be done ...Please Help me out.

[Former Member]

Hi,

You may try:

SELECT T0.DocNum, T0.CardCode, T0.CardName, T1.ItemCode, T1.Dscription, T1.Quantity, T1.Price, T1.LineTotal,T0.U_Name

FROM OQUT T0

INNER JOIN QUT1 T1 ON T0.DocEntry = T1.DocEntry

INNER JOIN OUSR T2 ON T0.UserSign = T2.USERID

WHERE T2.U_Name = '[%0\]' AND DateDiff(dd,T0.DocDate, Getdate())=0

If you only need for one user, you can omit OUSR and hardcode Usersign in the query.

Thanks,

Gordon

[Former Member]

Hi Gordon,

I am a new to SAP business one. I have a question and I was wondering if you may help me with it.

Thanks in advance.

so the question is that I have to get all sales orders num which may have sales quotation and show sales quotation number as well otherwise it should return null. and I am also going to hard code names of the employees by which I wanted them.

the tables I am going to use are OQUT(quotation table),QUT1(row table), ORDR(salesorder),RDR1(row table), OSLP(for employee name)

[Former Member]

You need post a new thread. It is improper to post your question on others thread.

[Former Member]

Thank You very much.It help me a lot.

[Former Member]

Please indicate which posting is helpful or solved your problem. That is better than saying thanks on the forum.

[Former Member]

Ok sir for sure.

[Former Member]

Do you know how to do it? You may check here: [Rules of Engagement|http://wiki.sdn.sap.com/wiki/display/HOME/RulesofEngagement].

[Former Member]

HI Maithili,

Are you using the sales employee field in the quotation to capture the details of the user? If yes, then it would be possible to write a query report. Else, the query would be written on the base of user signature, but if more than 1 user are using the same id to log in to the system and work, then it would not be possible.

Thanks,

Joseph

[Former Member]

Respected Joseph,

Yes they are using the sales employee field and every user is having their own login ID.Instead of Query is it not possible to view the details by going throw some Reports which are already there in SAP B1 by default?If that not possible could you please post that Query.Special Request from my side.

[former_member541807]

hi,

try this....

per sales employee

SELECT     T0.DocNum, T0.CardCode, T0.CardName, T0.DocDate, T1.ItemCode, T1.Dscription, T1.Quantity, T1.Price, T2.OwnerCode
FROM         OQUT T0 INNER JOIN
                      QUT1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN
                      OINV T2 ON T0.OwnerCode = T2.OwnerCode
WHERE     (T2.OwnerCode = '[%0]')


per User signature

SELECT     T0.DocNum, T0.CardCode, T0.CardName, T0.DocDate, T1.ItemCode, T1.Dscription, T1.Quantity, T1.Price, T0.UserSign AS UserSignature
FROM         OQUT T0 INNER JOIN
                      QUT1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN
                      OUSR T2 ON T0.UserSign = T2.USERID
WHERE     (T0.UserSign = '[%0]')

regards,

Fidel