1C with Navision 2009 R2

Web services, COM, .Net framework, External components etc. Integration with SAP, MS Dynamics etc.
kvasilev
Posts: 5
Joined: Tue Nov 29, 2011 7:43 am
Location: Bulgaria,Varna
Contact:

1C with Navision 2009 R2

Postby kvasilev » Tue Nov 29, 2011 7:57 am

Hi all,
We have a task to integerate Microsoft Navision 2009 R2 with 1C. We use XML files to exchange data from/to 1C. From Navision export Sale Invoices (credit memo), Purch Invoices (credit memo), Customers and Vendors and from 1C export paymets. We create procedure from navision to export data, but we haven't all data in Navision ERP. In Invoices must enter customer or vendor contract. If I create new customer maybe create contract too. But I transfer customer from Navision without contract. How we can start 1C create contract automaticlly. Can we start execute any procedure or trigers during import data in 1C

Krasimir Vasilev
FTS Bulgaria Ltd
kvasilev@fts-eu.com

Elisy
Posts: 74
Joined: Fri Jan 23, 2009 3:15 am
Contact:

Re: 1C with Navision 2009 R2

Postby Elisy » Tue Nov 29, 2011 8:15 am

Dear Krasimir,

what 1C version do you use? What is the approach to import data into 1C (COM/OLE, external processing etc.)?

kvasilev
Posts: 5
Joined: Tue Nov 29, 2011 7:43 am
Location: Bulgaria,Varna
Contact:

Re: 1C with Navision 2009 R2

Postby kvasilev » Tue Nov 29, 2011 8:33 am

Version of 1C is 8.1. I generate XML data from Navision manually and I manually import in 1C. I can use procedure for automaticlly import but it is not necessary now

Elisy
Posts: 74
Joined: Fri Jan 23, 2009 3:15 am
Contact:

Re: 1C with Navision 2009 R2

Postby Elisy » Tue Nov 29, 2011 9:55 am

kvasilev wrote:Version of 1C is 8.1. I generate XML data from Navision manually and I manually import in 1C. I can use procedure for automaticlly import but it is not necessary now

If you try to import into 1C:Trade Management you can
1. Use Контрагенты (Counterparts) catalog property named ОсновнойДоговорКонтрагента (MainCounterpartContract).
2. You can create new Contract using 1C script
3. You can find the appropriate existing Contract belonging to the Counterpart using the search in CounterpartContracts catalog.

All this approaches you can make from 1C script. And the first from COM/OLE access to 1C:Enterprise.

kvasilev
Posts: 5
Joined: Tue Nov 29, 2011 7:43 am
Location: Bulgaria,Varna
Contact:

Re: 1C with Navision 2009 R2

Postby kvasilev » Tue Nov 29, 2011 11:43 am

I attach two files with pictures which show how I import data from XML file. Where I write script or execute it. If I must do any correction in import parameters.
Attachments
1CImport1.JPG
(53.51 KiB) Downloaded 1321 times
1Center1.JPG
(61.53 KiB) Downloaded 1321 times

kvasilev
Posts: 5
Joined: Tue Nov 29, 2011 7:43 am
Location: Bulgaria,Varna
Contact:

Re: 1C with Navision 2009 R2

Postby kvasilev » Tue Nov 29, 2011 11:54 am

I import data from XML file. How I start or execute 1C script

Elisy
Posts: 74
Joined: Fri Jan 23, 2009 3:15 am
Contact:

Re: 1C with Navision 2009 R2

Postby Elisy » Tue Nov 29, 2011 12:26 pm

You try to use a "Data conversion" way. It's commonly used to migrate data from one 1C-system to another 1C-system. And it's not the best choice to migrate data from non-1C systems.
Data conversion XML rules are configured from special 1C-configuration "1C:Data conversion". Using this configuration programmer can implement logic and call 1C scripts when importing data.

Elisy
Posts: 74
Joined: Fri Jan 23, 2009 3:15 am
Contact:

Re: 1C with Navision 2009 R2

Postby Elisy » Tue Nov 29, 2011 12:37 pm

The 1C:Data conversion is looking like this:
p4.PNG
1C:Data conversion
(155.98 KiB) Not downloaded yet

kvasilev
Posts: 5
Joined: Tue Nov 29, 2011 7:43 am
Location: Bulgaria,Varna
Contact:

Re: 1C with Navision 2009 R2

Postby kvasilev » Tue Nov 29, 2011 1:49 pm

from where I can start this window "настройка правил обмена"

vidyakin
Posts: 1
Joined: Wed Nov 30, 2011 1:49 am

Re: 1C with Navision 2009 R2

Postby vidyakin » Wed Nov 30, 2011 2:39 am

kvasilev wrote:from where I can start this window "настройка правил обмена"
This window is related to individual configuration "1С:Data conversion". You can try to find any examples of "ExternalDataProcessors" with triggers for pre-processing documents on XML-import in 1C. "1С:Data conversion" just automatically create such processor scripted by your rules.


Return to “Plug-ins and integration with other solutions”

Who is online

Users browsing this forum: No registered users and 5 guests