Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 520
  • Last Modified:

Great Plains Document extensions

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
baytowel
Asked:
baytowel
  • 5
  • 5
1 Solution
 
Victoria YudinCommented:
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
 
baytowelAuthor Commented:
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
 
Victoria YudinCommented:
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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
baytowelAuthor Commented:
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
 
Victoria YudinCommented:
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
 
baytowelAuthor Commented:
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
 
baytowelAuthor Commented:
Screen Image
GPimage.jpg
0
 
Victoria YudinCommented:
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
 
Victoria YudinCommented:
Hi, just checking in to see if you need additional help on this?
0
 
baytowelAuthor Commented:
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now