No. Series Error with Purhase Orders

  • No. Series Error with Purhase Orders

    Posted by DSC Communities on November 10, 2017 at 1:26 am
    • Chris Nichols

      Member

      November 10, 2017 at 1:26 AM

      Hi when trying to post a number of older purchase orders, receiving the following errors

      The number series has been changed and the system seems to be looking at the old number series, even though under the purchase & payables setup this has been changed to a new number series.Ā  The number shown has been used but it relates to the old number series.

      All new PO’s are posting with no issues

      Any ideas how to resolve?

      thanks

      ——————————
      Chris Nichols
      Dynamics Consultant
      Vow Europe Limited
      Cambridge
      ——————————

    • Lewis Rosenberg

      Member

      November 10, 2017 at 9:06 AM

      ?Did you change the actual code used in Purchases and Payable Setup or did you change the numbering series prefix or range for the number series in use?

      It looks like once the document it created, it storesĀ the code for the number series to use when posting the purchase order.Ā  You can see this when youĀ  zoom to the Purchase Order recordĀ 

      How to Zoom
      Ctrl-Alt-F1 (or Ctrl-WindowsKey-Alt-F1)Ā 
      Expand Table Fields tab

      -or–

      ApplicationĀ  Menu button
      Help
      About this page
      Expand Table Fields tab

      ——————————
      Lewis Rosenberg
      IT Manager
      Mars Fishcare
      Chalfont PA

      NAVUG Board of Advisors, Programming
      NAVUG Programming Committee
      NAVUG Membership Committee
      ——————————
      ——————————————-

    • Kim Dallefeld

      Member

      November 10, 2017 at 11:21 AM

      If you haven’t change the No. Series code, you might have to edit the No. Series field for ‘last number used’.

      ——————————
      Kim Dallefeld
      VP Professional Services
      Syte Consulting Group
      kdallefeld@sytecg.com

      Past NAVUG Board Chairman
      NAVUG Programming Committee
      ——————————
      ——————————————-

    • David Wiser

      Member

      November 10, 2017 at 12:28 PM

      One place to look is the Purchase Header table and look at the line for the PO involved.Ā  There is a field called “Posting No.” which may already be populated with an invoice number.Ā  We ran into that at one time where when attempting to post the invoice, it grabs a number and assigns it to the PO.Ā  It can then cause conflicts if the number is already used.Ā  Not sure how it happens.Ā  We found that if you clear that field on the PO and attempt to post again it should work.

      ——————————
      Dave Wiser
      Controller
      Beckwith & Kuffel
      Seattle WA
      ——————————
      ——————————————-

    • Meenakshi Singh

      Member

      November 10, 2017 at 3:20 PM

      Change the PostingĀ No. to the next number in your new No. series in the PurchaseĀ Header table for that PO and the PO will post successfully. It’s still trying to post using the old no. and that series has been deactivated, hence the system is giving you errors.

      Meenakshi

      ——————————
      Meenakshi Singh
      Manager of Business Applications
      Home Market Foods, Inc.
      Norwood MA
      ——————————
      ——————————————-

    • Chris Nichols

      Member

      November 13, 2017 at 5:10 AM

      Thanks everyone for your help, exposed the posting no on the PO and removed and posted fine

      Chris

      ——————————
      Chris Nichols
      Dynamics Consultant
      Vow Europe Limited
      Cambridge
      ——————————
      ——————————————-

    DSC Communities replied 7 years, 10 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘No. Series Error with Purhase Orders’ 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!