web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Billing Invoice value...
Microsoft Dynamics GP (Archived)

Billing Invoice values in project accounting

(0) ShareShare
ReportReport
Posted on by Arunsh 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

I have the same question (0)
  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Arun,

    What table you are using for payment billing in PA.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

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

  • Arunsh Profile Picture
    Arunsh 606 on at

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

  • Arunsh Profile Picture
    Arunsh 606 on at

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

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    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.

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans