RMS to Great Plains Import Error

Our integration import gives us errors on a few transactions. 1 Multiple Tenders 2 Positve and Negative 3 Account Number does not exist What is needed to manually put in these transactions(If needed at all????)
Is anyone else out there using Great Plains with RMS
My versions are RMS 1.3.1011 Great Plains 9.00.0281
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
: 7bit
Good afternoon Barry, Thank you for posting your GP import error question. 1. Multiple Tenders I am assuming this is the below error that you also posted about in the microsoft.public.greatplains newsgroup; and as such someone from the GP should be responding in that newsgroup as they know more about manually entering data into GP then I do. "Payments with multiple tenders can't be imported and must be manually entered"
2. Positive and Negative I am not sure which of the below you are seeing; and in testing the first has been resolved: a. "Transactions with both positive and negative quantities must be imported manually " These are transactions with multiple items; and all items have positive or negative quantities. The prices are always positive. b. "Debit (DEBITAMT) and credit amounts (CRDTAMNT) must be > 0" These are transactions with multiple items; and all items have positive quantities. However, some of the items have positive prices; and some of the items have negative prices. Can you please decribe the transaction that is being done that causes this error? 3. Account Number does not exist Can you please post the exact error message you are seeing? I cannot find any previous reports of an "Account Number does not exist" error. Thank you in advance. Todd Berger Microsoft Online Support Engineer
Get Secure! - www.microsoft.com/security ====================================================When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ====================================================This posting is provided "AS IS" with no warranties, and confers no rights. --------------------
Subject: RMS to Great Plains Import Error Date: Thu, 4 Oct 2007 13:53:01 -0500
Our integration import gives us errors on a few transactions. 1 Multiple Tenders 2 Positve and Negative 3 Account Number does not exist What is needed to manually put in these transactions(If needed at all????) Is anyone else out there using Great Plains with RMS
My versions are RMS 1.3.1011 Great Plains 9.00.0281
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
1. Yes the Multiple Tenders is posted on the great plains newsgroup
2. The import error states Transactions with both positve and negative quantities must be imported manually
Question is how to manually enter as we often have items being traded in (the negative part of the transaction) for new merchandise (the positive part of the transaction)
3. The import error states Account does not exist for Account Index(DSTINDX)
Not sure but may have to do with discounts (MAYBE)

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
: 7bit
Good afternoon Barry, Thank you for the updates. 1. Yes the Multiple Tenders is posted on the great plains newsgroup If the posted method does not work please update that thread.
2. Transactions with both positive and negative quantities must be imported manually Question is how to manually enter as we often have items being traded in (the negative part of the transaction) for new merchandise (the positive part of the transaction) There should not be a need for manually importing these transactions as this is one of the fixes in the latest release of the integration. If the transaction has one item with a positive quantity (and a positive price) and another item with a negative quantity (and a positive price) it should import without error. In testing, using the following steps, I was unable to replicate this error if this is similar to the transaction causing the error on your install: a. In the POS, enter a new item with a positive quantity. b. Add a second item, and set the quantity to -1 c. Tender & complete the transaction d. Upload the transaction to HQ via a 401 worksheet e. Import RM Transactions in GP for the current date f. The transaction is imported successfully Can you check both of the following locations to ensure you are on the latest build of the integration: a. Version 9.00.131 (this can be found at the lower left portion of the RMS Integration Setup window) b. Install version 9.00.298 (this can be found by going to Control Panel | Add or Remove Programs | Microsoft Dynamics GP Retail Management System Integration 9.0 | Click here for support information) The latest version of the integration can be found here: https://mbs.microsoft.com/customersource/support/downloads/servicepacks/rmsi ntegration9.htm?printpagelse 3. The import error states: Account does not exist for Account Index (DSTINDX) I would recommend that you take a look at Knowledge Base article 918266: Error message when you use RM Import in Microsoft Dynamics GP or in Microsoft Great Plains to import sales transactions from Microsoft Retail Management System Headquarters: "Account does not exist for account index" https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;918266 Also, can you describe how the discounts are being done on a transaction that is showing this error? Thank you in advance. Todd Berger Microsoft Online Support Engineer
Get Secure! - www.microsoft.com/security ====================================================When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ====================================================This posting is provided "AS IS" with no warranties, and confers no rights. --------------------
Subject: Re: RMS to Great Plains Import Error Date: Wed, 10 Oct 2007 09:05:02 -0500
1. Yes the Multiple Tenders is posted on the great plains newsgroup
2. The import error states Transactions with both positve and negative quantities must be imported manually
Question is how to manually enter as we often have items being traded in (the negative part of the transaction) for new merchandise (the positive part of the transaction)
3. The import error states Account does not exist for Account Index(DSTINDX)
Not sure but may have to do with discounts (MAYBE)
\par > Subject: RMS to Great Plains Import Error \par > Date: Thu, 4 Oct 2007 13:53:01 -0500 \par > \par > Our integration import gives us errors on a few transactions. \par > 1 Multiple Tenders \par > 2 Positve and Negative \par > 3 Account Number does not exist \par > What is needed to manually put in these transactions(If needed at all????) \par > Is anyone else out there using Great Plains with RMS \par > \par > My versions are RMS 1.3.1011 \par > Great Plains 9.00.0281 \par > \par > \par > \par \par \par \pard \par \par } ------=
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
2. RMS Integration Setup Screen Version 9.00.131 Microsoft Dynamics GP Retail Management System Integration 9.0 Version 9.00.0298.0
It appears that we have the current integration builds
3. We went through all of the possible causes in the KB918266 and could not find a problem Were do I see if both the positive qty and the negative qty have positive prices. In RMS the neg qty has neg price on the journal. Discounts happen by ringing the item up at a lower price than price.
Thanks for at least looking into these issues. Barry

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
: 7bit
Good morning Barry, Thank you for the update. If you are seeing a negative qty with a negative price in RMS then this is what is causing the issue you are experiencing. A negative price would show up in parenthesis as in ($10.00).
You would need to have a negative qty with a positive price for the integration to work properly. For example a return may look like the following: Quantity: -1 Price: $10.00 Extended: ($10.00) If you have a negative quantity and a negative price the actual extended price is a positive dollar amount. Quantity: -1 Price: ($10.00) Extended: $10.00 Please let me know if this helps. Todd Berger Microsoft Online Support Engineer
Get Secure! - www.microsoft.com/security ====================================================When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ====================================================This posting is provided "AS IS" with no warranties, and confers no rights. --------------------
Subject: Re: RMS to Great Plains Import Error Date: Thu, 11 Oct 2007 13:49:46 -0500
2. RMS Integration Setup Screen Version 9.00.131 Microsoft Dynamics GP Retail Management System Integration 9.0 Version 9.00.0298.0
It appears that we have the current integration builds
3. We went through all of the possible causes in the KB918266 and could not find a problem Were do I see if both the positive qty and the negative qty have positive prices. In RMS the neg qty has neg price on the journal. Discounts happen by ringing the item up at a lower price than price.
Thanks for at least looking into these issues. Barry
\par >> Subject: RMS to Great Plains Import Error \par >> Date: Thu, 4 Oct 2007 13:53:01 -0500 \par >> \par >> Our integration import gives us errors on a few transactions. \par >> 1 Multiple Tenders \par >> 2 Positve and Negative \par >> 3 Account Number does not exist \par >> What is needed to manually put in these transactions(If needed at \par >> all????) \par >> Is anyone else out there using Great Plains with RMS \par >> \par >> My versions are RMS 1.3.1011 \par >> Great Plains 9.00.0281 \par >> \par >> \par >> \par > \par > \par > \par \par \par \pard \par \par } ------=
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
My Mistake the transaction shows on the receipt under the Description column -1@599.97 and (599.97) in the amount so the price is positive
Barry

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
: 7bit
Good afternoon Barry, Thank you for the clarification. If you are seeing this issue, on a transaction with positive and negative quantities (not amounts), please report it as a bug by contacting Technical Support to open a non-chargeable support request: https://mbs.microsoft.com/support/newstart.aspx or by calling MBS support at: 1-888-477-7877. They may need to get backups of your company, dynamics, and HQ databases; and also a copy of your GP folder. This can be arranged after you open the incident. Thank you in advance. Todd Berger Microsoft Online Support Engineer
Get Secure! - www.microsoft.com/security ====================================================When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
Subject: Re: RMS to Great Plains Import Error Date: Tue, 16 Oct 2007 08:22:02 -0500
My Mistake the transaction shows on the receipt under the Description column -1@599.97 and (599.97) in the amount so the price is positive
Barry
\par >>> Subject: RMS to Great Plains Import Error \par >>> Date: Thu, 4 Oct 2007 13:53:01 -0500 \par >>> \par >>> Our integration import gives us errors on a few transactions. \par >>> 1 Multiple Tenders \par >>> 2 Positve and Negative \par >>> 3 Account Number does not exist \par >>> What is needed to manually put in these transactions(If needed at \par >>> all????) \par >>> Is anyone else out there using Great Plains with RMS \par >>> \par >>> My versions are RMS 1.3.1011 \par >>> Great Plains 9.00.0281 \par >>> \par >>> \par >>> \par >> \par >> \par >> \par > \par > \par > \par \par \par \pard \par \par } ------=
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
We have also had this problem. Our software vendor has been unable to resolve it and Microsoft has also responded that it is a bug. It does not appear to have been resolved in v2.0.
We will have to spend an additional $10k on a third party integration product to get this (and 6 other integration issues) to work correctly.
"Todd Berger [MSFT]" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
You would think that since both are now under the Microsoft banner they would be able to get the integration to work properly. Perhaps they keep secrets even between themselves. You know kind of like the right pocket has no idea what the left pocket is doing. I don't think that we are interested in spending more money to get the integration to work at this time. (I sure would like to have 10k to play with) I will probably either learn the integration process myself or use other financial software.
Barry
Barry
in message

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Barry, et. al.,
Are you guys also getting the following:
"Invalid cash receipt type (CSHRCTYP) - (0=Check,1sh,2=Credit Card)"    
I reported this error to support over a year ago and they verified a bug in the integration. I'm wondering if it is fixed int he version you have?
Don
"Barry L" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.