Page 1 of 1

1C with Navision 2009 R2

Posted: Tue Nov 29, 2011 7:57 am
by kvasilev
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

Re: 1C with Navision 2009 R2

Posted: Tue Nov 29, 2011 8:15 am
by Elisy
Dear Krasimir,

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

Re: 1C with Navision 2009 R2

Posted: Tue Nov 29, 2011 8:33 am
by kvasilev
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

Re: 1C with Navision 2009 R2

Posted: Tue Nov 29, 2011 9:55 am
by Elisy
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.

Re: 1C with Navision 2009 R2

Posted: Tue Nov 29, 2011 11:43 am
by kvasilev
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.

Re: 1C with Navision 2009 R2

Posted: Tue Nov 29, 2011 11:54 am
by kvasilev
I import data from XML file. How I start or execute 1C script

Re: 1C with Navision 2009 R2

Posted: Tue Nov 29, 2011 12:26 pm
by Elisy
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.

Re: 1C with Navision 2009 R2

Posted: Tue Nov 29, 2011 12:37 pm
by Elisy
The 1C:Data conversion is looking like this:
p4.PNG
1C:Data conversion
(155.98 KiB) Not downloaded yet

Re: 1C with Navision 2009 R2

Posted: Tue Nov 29, 2011 1:49 pm
by kvasilev
from where I can start this window "настройка правил обмена"

Re: 1C with Navision 2009 R2

Posted: Wed Nov 30, 2011 2:39 am
by vidyakin
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.