I've no experience with NAV but I have interfaced VFP to a couple of
proprietary systems, the secret imho is to bypass as much of the
Application as possible: - Is the NAV SQL Server db locked down tight?
If not (and particularly if your VFP system uses an RDB) you could look
at triggers to call remote updates on the NAV db (there may very well be
SP's built into the NAV db that could be called without the risks
associated with raw update calls).
Otherwise there is apparently the quaintly named (and quaintly 1970's)
C/AL - which allows db access in a way vaguely reminiscent of Ababas
Natural. Why is it that Enterprise applications all have this retro
feel? - Ah! because they all started life well before the millennium
crisis was thought of!
On 07/05/2015 16:30, Dave Crozier wrote:
Guys 'n Girls,
Just installed NAV Dynamics 2015 and have managed to transfer all our
customers, vendors and opening balances from our VFP system into NAV with all
accounts balanced. So far so good!!
Now I want to set up a daily automated posting routine which takes all the
invoices we produce (in our case one item per invoice, and posts this data into
NAV so that the one posting goes into the Sales Account, Tax (VAT) account and
Debtors control account in one hit.
Anyone out there got any experience with NAV? The so called experts we had in
to oversee the data xfer quoted 32 man days at £850 pounts sterling per day for
the transfer and W managed to do it ourselves with a little assistance in 2
days so I think this is a little like the old SAP situation where you call
yourself a SAP or NAV consultant, add zero's onto the end of your daily rate
and then multiply the time it will take by 10 - making a good lucrative living
out of it in the meantime at the customer's expense.
I have looked at importing data via an XML web service as well as using the standard NAV
"Rapidstart" configuration packages but these seem to only do static 1:1 table
transfers - in fact this is the way we did the Vendors and customers and opening
balances. The added complication of posting one transaction that then has to go to 3 G/L
accounts has stumped me at the moment.
Any ideas?
Dave
P.S
Once I get proficient in NAV I'm off to the Bahamas as a NAV consultant using
telecommuting!!!
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
