From: Andy on
Hello everyone,

we are evaluating the possibility to interface Navision with external
packages.
We have already done some developments already in production phase for some
customer using text file and reading of them via NAV Report scheduled by NAS.

We are studying if it is possible to interface it with a PLM system but we
want to have an online/immediate/direct update without text file.
I know that it is not a good idea to write directly in Navision table
without validations, Navision object but I ask you suggestion and the best
way to have this behavior.

Thank you

Andy
From: manick on
Andy,

We have done some external integration for an excel based data output from
other systems. Our solution will automatically read the excel data from the
external system & create sales orders / GL entry in Navision.

Please drop an email to discuss.

MV
nj.tech(a)hotmail.com

"Andy" wrote:

> Hello everyone,
>
> we are evaluating the possibility to interface Navision with external
> packages.
> We have already done some developments already in production phase for some
> customer using text file and reading of them via NAV Report scheduled by NAS.
>
> We are studying if it is possible to interface it with a PLM system but we
> want to have an online/immediate/direct update without text file.
> I know that it is not a good idea to write directly in Navision table
> without validations, Navision object but I ask you suggestion and the best
> way to have this behavior.
>
> Thank you
>
> Andy
From: itpro.va on
Hello Andy,

if you don't want to use files, you can use ComCom.

If you have the possibitity of writing to database tables from your external
systen, I suggest you set up one ore more tables as an import buffer, which
gets filled from the external system. Then set up NAS to read data from
those buffer tables, copy it to the proper NAV tables, validating the data
in the process.
You may either poll the input tables (e.g. using Jo Queue) or set up some
event system to trigger NAS to do its work.

HTH

Stefan

"Andy" <Andy(a)discussions.microsoft.com> schrieb im Newsbeitrag
news:A507090C-8FFD-458F-8AE9-E4FCDE0FFE57(a)microsoft.com...
> Hello everyone,
>
> we are evaluating the possibility to interface Navision with external
> packages.
> We have already done some developments already in production phase for
> some
> customer using text file and reading of them via NAV Report scheduled by
> NAS.
>
> We are studying if it is possible to interface it with a PLM system but we
> want to have an online/immediate/direct update without text file.
> I know that it is not a good idea to write directly in Navision table
> without validations, Navision object but I ask you suggestion and the best
> way to have this behavior.
>
> Thank you
>
> Andy