Skip to main content
Microsoft Dynamics GP forum
Suggested answer

Vacation Balance

editSubscribe (0) ShareShare
Posted on by 5

I have built a Time Off form for our employees. This app pulls all their user info from Dynamics GP. I would like to put the users vacation balance on the app when they login to request time off. I am having trouble finding what table and column I would use from our SQL Dynamics DB to pull this information. Any help would be appreciated. Thank you.

  • Suggested answer
    RE: Vacation Balance

    Hi WynneIT,

    If you are accruing in Payroll, the vacation balance is stored in the Employee Master table UPR00100 in the VACAVLBL column.

    If you are accruing in HR, the vacation balance is stored on the vacation timecode in the TATM1030 table in the HOURSAVAILABLE_I column.

    Hope that helps.


    Cheryl W.

    Microsoft Support

  • Suggested answer
    Joseph Markovich Profile Picture
    Joseph Markovich 3,753 on at
    RE: Vacation Balance

    In Payroll, the field should be in UPR00100 table -- Payroll Master. The Vacation Available field is VACAVLBL.

    I hope this helps.



Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…


Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,068 Super User

Martin Dráb Profile Picture

Martin Dráb 222,591 Super User

nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans