RMS to Great Plains Import Error

Oct 04, 2007 10 Replies

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


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

  1. Yes the Multiple Tenders is posted on the great plains newsgroup

  1. 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)

  1. The import error states Account does not exist for Account Index(DSTINDX)
  1. 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

  1. 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

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

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:

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 "Lindsay (Australia)" wrote in message news: snipped-for-privacy@microsoft.com...

Barry, et. al.,

Are you guys also getting the following:

"Invalid cash receipt type (CSHRCTYP) - (0=Check,1Êsh,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?

D> You would think that since both are now under the Microsoft banner they

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required