SOP Integration-GP 9.0

I have set up SOP integration. The default currency is Euro. The functioning 
CCY is GBP. WHen i ran the integration, I have a subtotal of 32.00 Euro but 
the total on account was 28.62 Euro. The functioning total was caculated 
correctly based on 32 Euro.

When I go to the distribution screen and exit from there, it says that it is 
out of balance and will not post. I understand that.

Why was there a difference in the totals? Did I miss something?
0
KevinT1 (17)
9/29/2009 12:59:01 PM
greatplains 29623 articles. 6 followers. Follow

2 Replies
529 Views

Similar Articles

[PageSpeed] 42

Kevin,

I been in such issue where the distributions were not imported at all during 
the integration and the default distribution were loaded, after further 
investigations I found that the default value for Distribution Options 
Integration was set to "Use Default" instead of "Use Source Recordset".

I posted an article about this subject, refer to the blog post below for 
more information:

http://mohdaoud.blogspot.com/2009/09/import-transactions-distributions-using.html

Regards,
-- 
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Mob: +962 - 79 -999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com
http://mohdaoud.blogspot.com/


"Kevin T" wrote:

> I have set up SOP integration. The default currency is Euro. The functioning 
> CCY is GBP. WHen i ran the integration, I have a subtotal of 32.00 Euro but 
> the total on account was 28.62 Euro. The functioning total was caculated 
> correctly based on 32 Euro.
> 
> When I go to the distribution screen and exit from there, it says that it is 
> out of balance and will not post. I understand that.
> 
> Why was there a difference in the totals? Did I miss something?
0
Utf
9/29/2009 1:18:02 PM
Yes it works. Thanks a lot

"Mohammad R. Daoud" wrote:

> Kevin,
> 
> I been in such issue where the distributions were not imported at all during 
> the integration and the default distribution were loaded, after further 
> investigations I found that the default value for Distribution Options 
> Integration was set to "Use Default" instead of "Use Source Recordset".
> 
> I posted an article about this subject, refer to the blog post below for 
> more information:
> 
> http://mohdaoud.blogspot.com/2009/09/import-transactions-distributions-using.html
> 
> Regards,
> -- 
> Mohammad R. Daoud
> MVP, MCP, MCBMSP, MCTS, MCBMSS
> Mob: +962 - 79 -999 65 85
> Great Package For Business Solutions
> daoudm@greatpbs.com
> http://www.greatpbs.com
> http://mohdaoud.blogspot.com/
> 
> 
> "Kevin T" wrote:
> 
> > I have set up SOP integration. The default currency is Euro. The functioning 
> > CCY is GBP. WHen i ran the integration, I have a subtotal of 32.00 Euro but 
> > the total on account was 28.62 Euro. The functioning total was caculated 
> > correctly based on 32 Euro.
> > 
> > When I go to the distribution screen and exit from there, it says that it is 
> > out of balance and will not post. I understand that.
> > 
> > Why was there a difference in the totals? Did I miss something?
0
KevinT1 (17)
9/29/2009 3:37:02 PM
Reply:

Similar Artilces:

IM SOP (Invoice) Document Number
I am bringing invoice information from another system into GP via integration manager. all works well with the exception of the Document Number/Invoice Number; I am using default; which creates a new number for each invoice item. does anyone have a vbscript that can be used to get the next invoice number for a client and use that number for all items coming in for that client during the integration. there would be multiple invoice items per client and multiple clients per integration. can anyone point me in the right direction or have a script(s) to handle this. thanks Do you have eCo...

Ingenico with RMS 2.0
Everyone, I am having a very hard time finding information on installation & configuration of the i6550. Has anyone out there been able to make this work and be willing to share their documentation and/or procedures? I follwed the KB article 935588 but all I get is a blank screen once the device boots. I would immensely appreciate any detailed documentation/information that I can get my hands on. Thanks very much! -- Elizabeth Hi we had some help installling this and I can remember most of it. Did you install the Ingenico setup program? Please send me a private email and ...

Error when adding an Attribute i CRM 3.0
Hi. I know this is a long shot, and it can be a million things. But suddenly I can't add Custom Attributes to the database. The dialog after "save" is: "An error has occurred. For more information, contact your system administrator". I have set the "<add key="DevErrors" value="On"/>" and hoped that the dialog box would tell me more. But I got the same message. There is no problem in adding existing fields to existing forms, and I can publish then without any problems. Any ideas? Best regards and thanks for your h...

CRM 3.0
Just working with the beta of 3.0. Is there a quick way to send an e-mail template or even just an e-mail to a selected list of contact. What I mean is, in a list of contacts, if I choose say 3 or 4 contacts, is there some way to quickly choose somehow to send them an e-mail. If I choose them and create a new e-mail task their names do not appear in the to list. Also if I want to send a template e-mail to them, can it be done this way or does it have to be done another way? I know you can create an e-mail activity, then add all the names into the to list but this would be the revers...

In CRM 3.0 is there a way to Hide the Sales or Maketing or Service
I want to be able to control users access to different sections of CRM. So I want Jane Smith to see Sales and Marketing, and Scott Riley to only see Sales and Service. Doing by team would also work. I was able to create custom Roles and control entiy access but I don't see a way of controlling section access. Mike Sections only appear if the user has access to one of the items within that section. Unfortunately, there are some shared objects across the sections (like Account/Contact) that prevent them from disappearing totally. -- Matt Parks MVP - Microsoft CRM "Hotwheels...

CRM 3.0 - Web UI
Just wondering if anyone else has had this problem occur with their install of CRM 3.0. When you try to access the WorkPlace >> Calender page within the web application, i always get an error message when it tries to open the aspx page (home_calender.aspx). The error states "Unexpected error - an error has occured contact your system administrator" Any ideas as to why i would not be able to open this page ?? The user trying to open it has all roles assigned to it within CRM, and is a domain admins (Windows 2003 server, running Sql 2005, Exchange 2003) I am experienci...

more than 50'000 files in badmail and 9 smtp queues
hi i've got a problem. i've an exchange2000. relaying is not allowed. in the badmail folder are more then 50'000 files with bad, bdp and bdr extension. on the server i've 9 smtp queues. each one of thes has more then 5'000 mails after 15minuts up time. does anyone know this symtoms? thx The messages in badmail are usually failed NDRs. If someone tries to send a message to a non-existant user on your server and has used a fake sender address, the mail will eventually end up in badmail. For the queues, it's likely that all the messages are from postmaster, which ...

Garnishment in GP 10
Hi All, I was wondering if there is a way to create a invoice in Payables based on when a garnishment is taken out during payroll? I have a client that is tracking the garnishment and who it needs to be paid to on excel. If there is a way for GP to generate an invoice in Payables after each payroll based on each garnishment that would be a huge selling point for them. Any information would be very helpful. -- TC On May 14, 5:26=A0pm, TC <T...@discussions.microsoft.com> wrote: > Hi All, > > I was wondering if there is a way to create a invoice in Payables based on= >...

SQL server process scheduling from GP 9.0
hi friends, I have created a stored procedure in ms sqlserver. i need to run this process after certain interval which i want to handle from G.P. i.e. i want to schedule this back end process to run after every 1 min. this i want to manage from G.P. 9.0 can anyone help me out thanks in anticipation ...

3party Omni prices for version 9.0 dynamics
I want to if the omni prices works in dynamics 9.0 I have it working on a couple of V9.0 Sites with no problems noted. -- Richard L. Whaley Author / Consultant / MVP http://www.AccoladePublications.com Documentation for Software Users "Pedro Ramos" wrote: > I want to if the omni prices works in dynamics 9.0 > > > Have a look at the downloads pages of Winthrop's web site (http://www.winthropdc.com), you can see which versions are supported. David Musgrave [MSFT] Senior Development Consultant Escalation Engineer MBS Support - Asia Pacific Microsoft Busi...

GP 9 web parts
I noticed that Sharepoint has a Great Plains template, but it does not work. I would like to install GP web parts for employee cards, customer cards, etc on SPS sites. My problem I can't find those specific parts. Anyone know where they are located or how to obtain them? Thanks. Tareef I'm looking for the same thing. Anyone answer your question yet? "Tareef A." wrote: > I noticed that Sharepoint has a Great Plains template, but it does not work. > I would like to install GP web parts for employee cards, customer cards, etc > on SPS sites. My problem I can&#...

XML Request & Response & ASP.NET 2.0
Hi, I would like to know like in ASP.NET 2.0 or .net version 2.0, how do I parse the XML and consume it?. right now I am using the old methods like XML DOM. second thing is I need to send a XML Request to some URL, inturn I will be getting the response Back in the form of XML ONLY. HOW TO SEND THE XML request in Version 2.0? I am using old method like HttpWebRequest & HttpWebResponse bye thanks, ss ss wrote: > I would like to know like in ASP.NET 2.0 or .net version 2.0, how do I parse > the XML and consume it?. > > right now I am using the old methods like XML...

Integration with Peachtree?
I know this is a long shot, but was wondering if anyone knows of any third party product that allows data sharing between MS Project and Peachtree Accounting? Trying to avoid having to enter data twice. Thanks for any suggestions. Pat Oops! I some how posted this is in the wrong newsgroup! Please disregard. ...

QuickBooks Integration Over Network
I use QuickBooks and would like to take advantage of the accounting integration. My QuickBooks runs in my back office and not on the POS. When I am on my POS computer and click on the accounting integration wizzard it says that QuickBooks is not installed. Apparently the remote account application on the POS CD is only for Microsoft's accounting software. Is there any way for the POS to connect to my QuickBooks software/data over my network? I cannot install the POS software on my back office machine to use in manager mode... apparently it needs XP Pro and I have Home on my b...

cancel integration if text source file not available
Is there a way programatically to cancel the integration if my text source file does not exist? ...

Dexterity script to integrate with Building Assemblies (BOM)
I am a Dexterity Developer trying to make an add-on that integrates with the Assembly (BOM) functionality. I can't make heads or tails out of the SDK on how to use the "object oriented" style. The project I am trying is to have an assembly transaction that is saved automatically when an SOP Order is created with that assembly (BOM) on it. Does anybody have some sample code or some ideas? Thanks, Japheth Landis Computer -- Japteth: To confirm: is this the Inventory BOM rather than manufacturing? Dwight "Japheth Nolt" <japheth.remove@landiscomputer.com> w...

CRM 3.0 #2
Many times i try built new campaign and i have a problem with template, i want use some "template" to mailing action, because i don't want do 100 e-mails by foot. please help me sroobka@o2.pl ...

0.201483 Got To See This ... 0.4858338
0.8983606 Got To See This ... 0.9263594 0.201483 Now Visit Tobacco Is Drugs 0.4858338 ...

SOP Returns: how to void correct?
I'm looking for step-by-step instructions on how to void a Sales return document in GP correctly please. I'm currently using GPv8 (but this shouldn't matter). I've create and posted a sales return document in SOP. Now, I discover its incorrectly so I want to void the document. I dont want to apply the document against any other SOP documents - I just want to get rid of it. How do I go about this correctly so that the SOP document in Inquiry (Inquiry > Sales > Sales documents) is updated to be a voided document? In which table does this updated informatio...

Access Denied when connecting to CRM 1.0
Hi, When accessing the MS CRM 1.0 Server I am always receiving the 401.3 error, access denied/unauthorised to access this resource etc... I am a domain user on a computer connected to the domain (SBS2003 with CRM running on a Win2K Server). IIS 5 is configured for Windows Authentication only and the web page is prompting for a username and password but failing for my domain user account however it succeeds for the domain administrator account. I have an MSDN edition of CRM and have licensed it successfully using the MSDN Subscriber Organisation etc. I am registered in the CRM as a user with ...

Store Operation 2.0 In Item Property showing On Order 6 or so.Need
I my Store Operation 2.0 database in am showing some #s in on order. I alreddy all PO closed and I don't have any any back order and its still showing On Order Quantity (Different #s for different items) How do I make this On Order Quantity Zero "0" I am looking for SQL query Update Items Set OnOrder = 0 some thing like that but I dont know the Database field name for Onorder Please help me. ...

Integration between MS CRM 3.0 and OA2007
Hi guys, Have you heard of any tool that provides integration between MS CRM 3.0 and OA2007? Recently, it seems that a number of people are looking forward to have this tool. In line with this, we are currently developing a connector between Microsoft Dynamics CRM 3.0 and Microsoft Office Accounting 2007, and we are looking for CRM users, small business specialists and interested professionals who are willing to be advisors for this endeavor. Advisors will have the chance to influence the features of the software we are building and will get to evaluate pre-release versions of our applicatio...

Upgrading to 8.0
We are planning on upgrading from 6.0 to 8.0 We have four issues that we need some help on. (We are not using Manufacturing) 1. How do you deplete inventory from one site? 2. How do you expense the transfer of raw material inventory to the end user departments department? 3. How do other customers handle a raw material and finished good inventory using Great Plains? 4. If we have three inventory classes, can we lock out certain users from accessing items different inventory classes? Thank you. 1. How do you deplete inventory -- Do you mean you want to get all the On Hand qu...

GP 9.0 user logins passwords
Hi We are using GP 9.0. Is it possible to disable the option of allowing users to change their passwords, when they login to GP. I understand that Great Plains user passwords are encrypted and you cant use the same passwords to login to SQL server directly. To overcome this we can override the passwords directly in SQL server. I have to change the passwords directly in SQl to enable users to login to Frx with same user ID and password as in GP. Unfortunately when I change the user password within SQL server, and the user tries to login to Great Plains, he/she is prompted or rather forced to c...

Using Macros to test GP changes
I was discussing ways to test GP with my supervisor recently, and it was suggested that it may be possible to record a macro inside of GP to test common tasks in GP, and then use those macros whenever a server change, customization change or GP version change is made to verify that everything is working. Has anyone done this before? If so, what were the pitfalls you came across? If this is a possibility, we would probably be building a set of testing macros to supliment our current testing model. Thanks! Hi Jason. This is very possible though it may be cumbersome sometimes especial...