Who Did it — Created a Purchase Order

  • Who Did it — Created a Purchase Order

    Posted by Ronald L McVicar Jr on May 13, 2019 at 11:41 am
    • Ronald McVicar

      Member

      May 13, 2019 at 11:41 AM

      If approvals are not turned on and no enhancement, there is not a way to see who created a purchase order in default NAV (2015), right?
      No value entries?
      No vendor ledger entries?
      on release no entry tied to a end-user, right?

      Or is there?

      I say a post for NAV 2013 and it seemed to indicated that with out an enhancement, no out of the box feature for Purchase Orders or Sales Orders.

      Any input on this?

      ——————————
      Ronald McVicar, IT Software Mgr
      NSP (Quality Meats)
      nspproteins.com
      ——————————

    • Lewis Rosenberg

      Member

      May 13, 2019 at 11:47 AM

      Hello Ronald,

      We’re on NAV2013R2 and I see a field called Created By that contaiins the USER ID for the person who entered the purchase order:
      The fiels is in TableĀ 38 – PurchaseĀ Header, but isĀ not on the page.

      Ā ??PO Header

      ——————————
      Lewis Rosenberg
      IT Manager
      Mars Fishcare
      Chalfont PA
      ————————————————————————
      BCUG/NAVUG All-Star
      BCUG/NAVUG Board of Advisors, Chairperson
      BCUG/NAVUG Programming Committee

      Twitter: @RosenbergL
      LinkedIn: https://www.linkedin.com/in/rosenbergl
      ————————————————————————

      NAVUG/BCUG Summit (navugsummit.com)
      Orlando, FL – October 15-18, 2019
      ——————————
      ——————————————-

    • Ronald McVicar

      Member

      May 13, 2019 at 12:16 PM

      Lewis,
      that field in not on our Purchase Order (Header or Table 38) for NAV 2015.
      I also went in to the Designer and nope no Created By field for the Purchase Table.Ā  Must have been take out for NAV 2015.Ā  Interesting

      ——————————
      Ronald McVicar, IT Software Mgr
      NSP (Quality Meats)
      nspproteins.com
      ——————————
      ——————————————-

    • Lewis Rosenberg

      Member

      May 13, 2019 at 12:27 PM

      I don’t see the field in my NAV 2018 playground either.Ā  In our production system there are a few fields all in the 70000 number range that are related to manufacturing, so I guess they are either only there for manufacturing or they may be part of Lanhams’s DP add-on.?

      ——————————
      Lewis Rosenberg
      IT Manager
      Mars Fishcare
      Chalfont PA
      ————————————————————————
      BCUG/NAVUG All-Star
      BCUG/NAVUG Board of Advisors, Chairperson
      BCUG/NAVUG Programming Committee

      Twitter: @RosenbergL
      LinkedIn: https://www.linkedin.com/in/rosenbergl
      ————————————————————————

      NAVUG/BCUG Summit (navugsummit.com)
      Orlando, FL – October 15-18, 2019
      ——————————
      ——————————————-

    • Matt Traxinger

      Member

      May 13, 2019 at 12:29 PM

      Yep, you’ll see that’s a 70XXX field, and since it is between 50,000 and 99,999 it is a custom field.

      If you want to see who is creating and updating records, just turn on the change log for that table:Ā https://www.archerpoint.com/blog/Posts/change-logs-and-microsoft-dynamics-nav-2016

      It won’t be a field on the header / lines that you can see or filter on, but you can drill into the update history.

      ——————————
      Matt Traxinger
      NAV Developer
      ArcherPoint Inc.
      San Antonio TX
      ——————————
      ——————————————-

    • Kim Dallefeld

      Member

      May 14, 2019 at 8:15 AM

      Ron, theĀ  user id is on value entries and vendor ledger entries (at least in 2018). I know user id on value entries has been around for several versions. I guess? the lack ofĀ a created by user id on purchase orders and sales orders is Microsoft’s way of giving developers work….I’ve seen it added at least 75% of my clients.

      ——————————
      Kim Dallefeld
      Kim@Dallefeld.com
      Dallefeld Consulting, LLC
      Member of Dynamics Consulting Group
      Ft. Worth, TX
      2019 NAVUG Board of Advisors
      Past NAVUG Board Chairman
      NAVUG Programming Committee
      ——————————
      ——————————————-

    • Iaroslav Pankovskyi

      Member

      May 14, 2019 at 11:21 AM

      Ronald,
      Matt’s recommendation about Change Log seems to be your best bet to avoid a modification. I have seen this function work successfully on Vendor-related information and it is quite sophisticated.

      In Business Central, on the PO page, you also have the Field called “Assigned User ID” that can be used for the purpose.

      Another option is Notes, but this is a less likely solution for the purpose.
      Kind regards,

      ——————————
      Iaroslav
      ——————————
      ——————————————-

    • Geovanny Fuentes

      Member

      May 14, 2019 at 2:40 PM

      I agree with Iaroslav , no matter which version you are in, activate the change log with a few fields that are important.
      For now the posting which may hit the G/L Entries you can go there to see who posted the Invoice (Help About This Page) and look for the USER ID (27).

      Good luck.

      ——————————
      Geovanny Fuentes
      San Diego CA
      ——————————
      ——————————————-

    • Ronald McVicar

      Member

      May 14, 2019 at 3:17 PM

      Thank you everyone.Ā  LibertyGrove helped me confirm my choices.
      Change Log and getting an enhancement for the User ID automatically added to a Created by Field for a Purchase Order.Ā  Else we have other options for Purchase Invoice on posting, etc.

      ——————————
      Ronald McVicar, IT Software Mgr
      NSP (Quality Meats)
      nspproteins.com
      ——————————
      ——————————————-

    Ronald L McVicar Jr replied 7 years, 2 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Who Did it — Created a Purchase Order’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!