606
Hi all,
I have a requirement to get the payment billing and its status from project accounting Module. I have taken the billing document status. But it is showing 1,2,3 like number. I want to show what 1 ,2,3 represents. can anyone share what those invoice document status values represent?
Regards,
Arun
*This post is locked for comments
To finish the answer that Babu started, using the CASE statement in the SQL Query will get the 'words' to show up rather than the numbers.
So you will need to use something along the following lines to replace 1,2,3 in the values.
CASE C.DCSTATUS WHEN 1 THEN 'WORK' WHEN 2 THEN 'OPEN'
WHEN 3 THEN 'HISOTRY' ELSE 'UNKNOWN' END
Hope this helps.
The PA billing status can be 3 of the following.
1) Work
2) Open
3) History
So your DOCSTATUS should be either of this, please check some random transaction within GP so you will know the correct status.
SELECT
A.PAPROJNUMBER,
A.PADOCNUMBER20 AS 'BILLING NUMBER',
B.DOCNUMBR AS 'INVOICE NUMBER',
B.DOCDATE AS 'DOCUMENT DATE',
C.DCSTATUS AS 'INVOICE STATUS'
FROM
PA13200 AS A
INNER JOIN PA23000 AS B
ON A.PAPROJNUMBER = B.PAPROJNUMBER
INNER JOIN PA05100 AS C ON A.PAPROJNUMBER = C.PAPROJNUMBER
WHERE A.PAPROJNUMBER = ' '
This is the actual query im using.. i just need what that invoice status means...could you help me.. im passng the project number and pulling the invoice status of that project.
this is only from open table..
SELECT
A.PAPROJNUMBER,
A.PADOCNUMBER20 AS 'BILLING NUMBER',
B.DOCNUMBR AS 'INVOICE NUMBER',
B.DOCDATE AS 'DOCUMENT DATE',
C.DCSTATUS AS 'INVOICE STATUS'
FROM
PA13200 AS A
INNER JOIN PA23000 AS B
ON A.PAPROJNUMBER = B.PAPROJNUMBER
INNER JOIN PA05100 AS C ON A.PAPROJNUMBER = C.PAPROJNUMBER
WHERE A.PAPROJNUMBER = ' '
This is the actual query im using.. i just need what that invoice status means...could you help me..
Arun, you may need to do sql join couple of PA Tables. The table details can be found in GP SDK. Hope this help.
Arun,
What table you are using for payment billing in PA.
Share
Report
All responses (
Answers (
