Using a Macro with NAVISION ?!?

tizianocolucci

Hi everybody, I’m here to ask you if there’s a way to use a Macro excel (or a text source) to fill a Navision’s form (for example, to fill all the fields of the Sales Order Window).
In case of a massive input of data, it should be easier and faster to use a source file to do that. But HOW ?!?!?
We have tried with AUTOIt or Macro-Scheduler, but they’re not so useful for a massive input (where all the records are not similar).
Thank you all for the support, and have a good day!
Bye
Tiziano

janpieter

As for as i know a sort of screen scraping sollution is not available for navision and not possible either.

The only thing you can do is to fill the sales header and sales line records with C/Front (wich i think you can use in a VBA macro) and navigate manually to that record with the salesorder. Maybe ODBC is a good sollution as well.

The big disadvantage however is that your Navision C/AL validation triggers will not be executed. The first thing that goes wrong then is the autonumbering

tizianocolucci

Thanks Jan,
I'll try however!

Savatage

why not create 1 order & then use Copy Document
once you select the order# once it will remain on that number and all you have to do is hit F3->copy document over & over