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
MemberNovember 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
—————————— -
?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 PANAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————- -
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.comPast NAVUG Board Chairman
NAVUG Programming Committee
——————————
——————————————- -
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
——————————
——————————————- -
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
MemberNovember 13, 2017 at 5:10 AM
Thanks everyone for your help, exposed the posting no on the PO and removed and posted fineChris
——————————
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.