Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Find corresponding Table/Page for Budgeting

Posted on by 10

Hey, I hope some of you can help me.

We're planing to build a customized mask to provide an easier way for budget data input for our colleagues. 

As a first step I want to find out in which table this data is being stored. More precisely I am talking about the budgets that are visible inside the job cart:

pastedimage1611150422376v1.png

For the moment we are only focusing on the Billable Price data. I made some research and also looked into the Object Designer of VS. To me it appeared as if "G/L Budget Entry" might be the right table. So I tried to build a little extension (which we already did for Projects), based on the G/L Budget Entry table. I basically copied the code from this table (via Object Designer) into a new .al data. That's roughly how I did it with projects and it worked that time.

My VS code looks like this and I even got the message that it got successfully published but I can't find the extensions:

pastedimage1611150870363v2.png

I'd like to know if I am even on the right path (source table) or if I just did something wrong on the VS end.

Best regards and thanks in advance!!

  • JAngle Profile Picture
    JAngle 33,159 on at
    RE: Find corresponding Table/Page for Budgeting

    Link for jobs functionality: docs.microsoft.com/.../walkthrough-managing-projects-with-jobs

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: Find corresponding Table/Page for Budgeting

    Budgets for jobs are dealt with in the same table as billable lines. You have a line type in the job planning lines. G/l budgets is something entirely different.

    I’d do some research on jobs in general before you go and develop something which might be pointless. If you want an easier method for adding data to jobs then an api might be worthwhile as you can pass the data from elsewhere. However, you can use edit in excel with job planning lines so again a api might not be necessary.

  • nortonrome Profile Picture
    nortonrome 10 on at
    RE: Find corresponding Table/Page for Budgeting

    I thought so yes. I wanted to do it the same way I did it with our projects API before. In that case we built a little API to Create/Access Projects with names, id's bill-to-customerno etc. Basically this whole thought of building an API for the budgets was to make sure in what table my data is stored because I am still a bit confused about these different tables when it comes to budgets.

    Can you tell me if I am in the right table? And do you know why I can't see my published app in extension?

    Best regards

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Find corresponding Table/Page for Budgeting

    You built an API page, are you planning to publish the page as an API? what is your requirement to expose the data through the API ?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans