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 NAV (Archived) / tables in Navision for...
Microsoft Dynamics NAV (Archived)

tables in Navision for a PR form

(0) ShareShare
ReportReport
Posted on by Community Member

dear colleagues,

I would like to ask about create a Purchase Request form (that is not available in the Nav) with limited user access.

The functions I would like to have in the PR form:

1. create a PR form with a general description of item and spec, not choosing from the master item list, reserve some limit in the budget base on the budget department code (this code can be different from the requestor department code), project code inserted. The budget limit will return back when some requested items or the whole PR got rejected. The reserved amount in the budget will remain until the approver reject or approve a PR form.

2. once the user click submit to post and send an approval, the data (department code, project code, item requested, quantity, the last purchased price (base on the purchased history), total (requested quantity * the last purchased price),
My question is what table name do I need write the data and how many tables do I need to write?
Because base on my assumptions, the tables I need will be:
1. purchase header form table -> write
    this table will record requestor department code, requestor ID, budget departent code
2. purchase line form table -> write
    this table will record requested quantity, price, project code
3. audit trail table -> write
    this table will requestor department code, activity action timestamp, form name
4. for budget
    for this one, I do no know which tables I need to write and read.
    For sure, what I want to reserve some amount in the budget base on budget department code, project code, total amount requested, 
    budget version (because I have multiple budget revision).

I am looking forward to a favorable reply from you. Thank you.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi,

    A good way to identify which tables are involved in a process is by using permission recording (www.olofsimren.com/record-permissions-in-nav-2016).

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 NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans