Open Forum

Expand all | Collapse all

User Deleting No. Series from Purchase Header

  • 1.  User Deleting No. Series from Purchase Header

    Posted Jul 30, 2019 08:53 AM
    Hello,

    On occasion,  I am coming across  issues receiving a purchase order due to " receiving number series must have a value in Purchase Header...It cannot be zero or empty."

    The setup is there and initially the PO had a rec no. series, somehow users are deleting this.
    Security around No. Series has been locked down.
    Unfortunately, our version of NAV has been highly customized, but we are running NAV2018.

    I have not been able to replicate this issue, has anyone experienced this before?
    Can anyone help me solve this mystery?

    Table Caption Field Caption Type of Change Old Value Old Value (Local) New Value New Value (Local) Entry No.
    Purchase Header Buy-from Vendor No. Insertion X X 75003519
    Purchase Header Name Insertion X X 75003520
    Purchase Header Order Date Insertion X X 75003521
    Purchase Header Posting Description Insertion X X 75003522
    Purchase Header Receiving No. Series Insertion     PUR-RCP PUR-RCP 75003523
    Purchase Header Status Insertion 0 Open 75003524
    Purchase Header Receiving No. Series Modification PUR-RCP PUR-RCP     75003557
    Purchase Header Expected Receipt Date Modification X X 75004250
    Purchase Header Expected Delivery Appointment Date Modification X X 75004251
    Purchase Header Expected Receipt Date Modification X X X X 75004596
    Purchase Header Shipment Method Code Modification X X 75007147


    ------------------------------
    Ian Andrews

    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: User Deleting No. Series from Purchase Header

    TOP CONTRIBUTOR
    Posted Jul 30, 2019 11:47 AM
    The quick fix would be to remove the Receiving No. Series field from the Purchase Header page.  It sounds like its visible on the page which is allowing users to modify or delete the value.  Unless you have a unique process surrounding the field, there really isn't a need for this field to be visible on the document.  Your screengrab doesn't show the user ID, but you might also contact the user to find out why they are removing the value.  One possible reason is that they are trying to enter manual numbers and the number series is preventing manual numbers.  If this is the case, it would be better to go to the No. Series page and click the "Manual Nos." box on the series being used for purchase receipts.  But it would good to find out why the value if being removed.

    ------------------------------
    David Wiser
    Project Manager
    Tigunia
    Seattle WA
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: User Deleting No. Series from Purchase Header

    Posted Jul 30, 2019 12:00 PM

    Thanks for the feedback, the interesting part if that field is not visible to the end user on the purchase order screen.
    Also, i noted that all transactions from creation of the order to deletion of the no. series happened at the same time.  We must be using some sort of automated process that i need to dig further into.



    ------------------------------
    Ian Andrews
    Mastronardi Produce
    Kingsville ON
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: User Deleting No. Series from Purchase Header

    TOP CONTRIBUTOR
    Posted Jul 30, 2019 01:46 PM
    As Dave mentioned, check the UserID from that change log to determine if it's an actual user or an automated process that's causing it. This could help you narrow it down.

    ------------------------------
    Kristoffer Ruyeras
    Solutions Architect
    Tigunia
    Seattle, WA
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: User Deleting No. Series from Purchase Header

    TOP CONTRIBUTOR
    Posted Jul 31, 2019 08:19 AM
    ​I have seen this happen about 2-3 times in 2 years with NAV 2013.
    Haven't found where it was coming from and since it rarely happens, didn't put much time into it.
    We do not have any add-ons except Zetadocs.

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------

    Conference-BCNAVUG_200x200


  • 6.  RE: User Deleting No. Series from Purchase Header

    SILVER CONTRIBUTOR
    Posted Aug 01, 2019 12:05 PM
    We are using NAV 2018.  This week, for the first time, 2 of our number series disappeared, apparently overnight.  We tried to create a PO, got an error message, and discovered the Purchase Order no. series was gone.  After determining the last PO number used, we re-entered the no. series.  The same thing happened with our Assembly Order no. series.  Curious.

    ------------------------------
    Alan Hyde
    Controller
    National Azon
    Troy MI
    ------------------------------

    Conference-BCNAVUG_200x200


  • 7.  RE: User Deleting No. Series from Purchase Header

    TOP CONTRIBUTOR
    Posted Aug 01, 2019 12:13 PM
    I would always recommend to turn on Change logs for any setups in NAV. And whenever possible, lock down by permissions.

    ------------------------------
    Kristoffer Ruyeras
    Solutions Architect
    Tigunia
    Seattle, WA
    ------------------------------

    Conference-BCNAVUG_200x200


  • 8.  RE: User Deleting No. Series from Purchase Header

    TOP CONTRIBUTOR
    Posted Aug 01, 2019 06:50 PM
    Ian, after you check the userid for an automated process or a particular user. Let's check the TMC interface.

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

    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role