Question Status

Suggested Answer
Arunkumar Shanthi asked a question on 25 Feb 2015 1:28 AM

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

Reply
BABU BASKARAN responded on 25 Feb 2015 4:01 AM

Arun,

What table you are using for payment billing in PA.

Best Regards,

Babu Baskaran

Financial Systems Manager

Please mark this as verified if it answers your question. Verifying the answer will help others who experience this same issue.

 

Reply
Suggested Answer
Arunprasath responded on 25 Feb 2015 4:08 AM

Arun, you may need to do sql join couple of PA Tables.  The table details can be found in GP SDK.  Hope this help.

Reply
Arunkumar Shanthi responded on 25 Feb 2015 4:30 AM

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..

Reply
Arunkumar Shanthi responded on 25 Feb 2015 4:33 AM

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..

Reply
Suggested Answer
BABU BASKARAN responded on 25 Feb 2015 5:53 AM

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.

Best Regards,

Babu Baskaran

Financial Systems Manager

Please mark this as verified if it answers your question. Verifying the answer will help others who experience this same issue.

 

Reply
Suggested Answer
Bill Campbell responded on 26 Feb 2015 11:39 AM

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 Campbell
Director, Operations
M.I.S. Management Information Solutions Ltd.
Skype: billc.edmonton
Cell: +1 780 994 2455
Off : +1 780 481 5564

Reply
Suggested Answer
Arunprasath responded on 25 Feb 2015 4:08 AM

Arun, you may need to do sql join couple of PA Tables.  The table details can be found in GP SDK.  Hope this help.

Reply
Suggested Answer
BABU BASKARAN responded on 25 Feb 2015 5:53 AM

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.

Best Regards,

Babu Baskaran

Financial Systems Manager

Please mark this as verified if it answers your question. Verifying the answer will help others who experience this same issue.

 

Reply
Suggested Answer
Bill Campbell responded on 26 Feb 2015 11:39 AM

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 Campbell
Director, Operations
M.I.S. Management Information Solutions Ltd.
Skype: billc.edmonton
Cell: +1 780 994 2455
Off : +1 780 481 5564

Reply