Solved

Great Plains Document extensions

Posted on 2013-01-09
10
472 Views
Last Modified: 2013-01-24
Thank you for your time in advance.  I have a simple question about Great Plains document naming.    Our invoice number for a customer is 156497 but the history shows 156497P.  What does the P after a transaction mean?
0
Comment
Question by:baytowel
  • 5
  • 5
10 Comments
 
LVL 18

Expert Comment

by:Victoria Yudin
ID: 38759167
I can't think of anything in GP out-of-the-box that would automatically add letters at the end of invoice numbers.  Have you confirmed this is actually how the data is stored in the database?  I have seen strange display issues cause characters that are not actually there to be displayed.

If the P is really there, I would check to see if there is also an invoice with the number 156497.  Sometimes users will add something to the end of a doc number if they are re-entering it or want to show that transactions were linked.  Also, where did this invoice originate?  Was it manually entered (and if so, on what screen) or was it imported or created by another process?
0
 

Author Comment

by:baytowel
ID: 38759737
Dennis,
 
This is from our AR manager:

"Attached is a screen shot of a history table for one of our COD accounts.  
 
Here are the circumstances surrounding this account:
 
*They receive a weekly delivery, every Thursday;
*Our Route Rep/Driver picks up payment, on delivery, every Thursday
*We record the cash in Great Plains every week, the day after delivery.
 
The cash received for the last two weeks for this account is still unapplied, and we do not have an open invoice to apply it to.  It appears the weekly invoices have gone to, or appear in the History table.  "

Trying to research the issue we noticed the P on the end of the invoices and are wondering what it means and if it is related to our issue.
0
 
LVL 18

Expert Comment

by:Victoria Yudin
ID: 38759773
I am not sure if this is something anyone can answer without looking at your data and checking all the related tables.  Are you able to post screenshots of what you're looking at?  What history table are you checking where you are seeing these invoices?
0
 

Author Comment

by:baytowel
ID: 38759803
I did attach a screen shot showing the Receivables Transaction Inquiry - Customer screen.  Did it not come through?

We are running GP 8.5 if that helps.
0
 
LVL 18

Expert Comment

by:Victoria Yudin
ID: 38759829
I do not see any attachments, sorry.  Can you please try again?  You should be able to see it as well, when you are looking at this question online.

Also, there is no Dynamics GP 8.5 version.  There is 7.5, 8.0 and a 9.0...?  Not sure if that would make a difference for what you're talking about anyway, but just want to make sure we're not talking about apples and oranges here. :-)
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:baytowel
ID: 38774649
I have tried to attach the screen image several time but it never shows.  A request for help has been sent to support.  Please don't abandon the question, we still need an answer.

thanks.
0
 

Author Comment

by:baytowel
ID: 38774659
Screen Image
GPimage.jpg
0
 
LVL 18

Accepted Solution

by:
Victoria Yudin earned 100 total points
ID: 38774682
Thanks for enclosing the screenshot - that really helps. What it shows is that the entry with the 'P' at the end of the Document Number is actually a payment. The original invoice is on the line right above it. (In the Type column, SLS = Sales Invoice, PMT = Payment)

So, whether correctly or not, someone has already entered a payment for the invoice you're looking at. Also, to get the Payment number to be 1571468P I believe someone would have had to manually type that in, otherwise it would have defaulted to something like PYMNT...XXXXX, as you can see from your other payments.

Hope this helps. Please let me know if you need additional help based on this.
0
 
LVL 18

Expert Comment

by:Victoria Yudin
ID: 38798236
Hi, just checking in to see if you need additional help on this?
0
 

Author Comment

by:baytowel
ID: 38816161
Thanks for the follow up.  With your information we have now identified our issue.  COD invoices were being marked paid ( the "P" on the document name) before they were transferred into Great Plains.  This prevented our AR people from applying payments to the invoice.  We can now modify our procedures so this cannot happen.

thanks for you help.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now