Solved

Great Plains Document extensions

Posted on 2013-01-09
10
481 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

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
 

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

773 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