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?
What table you are using for payment billing in PA.
Financial Systems Manager
Please mark this as verified if it answers your question. Verifying the answer will help others who experience this same issue.
Arun, you may need to do sql join couple of PA Tables. The table details can be found in GP SDK. Hope this help.
A.PADOCNUMBER20 AS 'BILLING NUMBER',
B.DOCNUMBR AS 'INVOICE NUMBER',
B.DOCDATE AS 'DOCUMENT DATE',
C.DCSTATUS AS 'INVOICE STATUS'
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..
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..
The PA billing status can be 3 of the following.
So your DOCSTATUS should be either of this, please check some random transaction within GP so you will know the correct status.
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.
** Please, if this answers your question, mark it as 'Answered' so others experiencing the same will know it resolved your issue. **
Bill CampbellDirector, OperationsM.I.S. Management Information Solutions Ltd.Skype: billc.edmontonCell: +1 780 994 2455Off : +1 780 481 5564