Dear all,
I have seen sop c# integration console application and I really appreciates but it puts one sop document/transaction.
Is there one whereby when ran,several documents (read from a file or another database) are uploaded to gp as oppose to initializing on transaction directly on C# or vb codes.
RomRyan
*This post is locked for comments
I am way beyond that now. I have it working but not understand even though I have set it compute the taxes, I still have to send down the tax detail IDs and amounts. This sort of defeats the purpose of using eConnect. I could just go back to writing directly to the tables.
Hello Richard,
Can you check if you have correct value in INTERID field in table DYNAMICS.dbo.SY01500
support.microsoft.com/.../sample-xml-document-that-you-can-use-to-import-tax-information-for-a-s
I followed this example exactly using only T-SQL commands and I got it to work. My only issue was error 3565 on the header insert. This is in regards to updating the next note index. Why that occurs is a mystery but the header record does get inserted. I am now going to build on this to customize it to what I need. The biggest reason I wanted to use eConnect was to have a lot of the work done for me especially when it came to sales tax. If I have to compute the sales tax and supply all the values then eConnect really has no value. I will simply write directly to the tables or worse yet use IM to import the orders.
Tim,
In fact what I am doing is similar to what Richard is doing, I gave customer import as an example. What I need is the concept. i.e. if I can import an SOP invoice (several records from another system's table) then the same concept applies to PO,POP invoice. I am working on SOP one and once I succeed POP one will follow.
Let me see if I can get things right.
RomRyan
Tim, I am just sitting in SQL and issuing direct SQL commands using taSOPLineIvcInsert, taSopLineTaxInsert and taSopHdrIvcInsert commands trying to find the right combination for sales tax. Once I find the right connection the C# part is a snap. I have found article that claims to have the answer. We shall see will see.
I don't have access to a customer import that I can find, but if I did I'd be violating terms to give it to you regardless as that code is not mine to share but rather paid for by others. Maybe I'll write a simple import for you at some point but I'd rather not get into an infinite loop on this request.
Point I was trying to make when responding to your initial question and maybe I wasn't clear enough was: I don't see eConnect as the problem, it's your experience with C# that seems to be more the issue. If you don't have experience with passing parameters to procedures or querying SQL directly from VS or using data sets or arrays then I think it's tough to start where you are starting. Understanding deployment, ini files, includes all part of the process here.
That said, I'll see if I can write something simple but if I'm putting in community time today it will be testing sales tax calculations for Richard.
I just found KB927322 which says it has an example. I am perusing it right now. Let's hope it helps.
I am currently developing my own SOP eConnect application that includes sales tax. I am starting simply with the eConnect nodes and I am also stuck on the sales tax issues. Once I work this through I will update this case with the correct timing of what is needed.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (