this is a collection of popular queries but for MS dynamics GP ( not nav ) so my question is do you know if there is an equivalent for ms dynamic nav ???
well, I m not looking for problems, don’t want to ofence you,
my problem is that I have no budget to pay a “nav consultor”, I already was able to do some other queries, but my main problem is that I don’t have lots of time to investigate and to do my “missing queries” as my deadline is ending on next Monday…
On my side if I can help someone freely by just posting some sql queries that I already have I will do it free of charge, I m not interested on getting money, as I already have a Job…
For me it makes me happy if I can share some knowlegde to others, the problem is that as I m new in navision I don’t have the knownledge.
I don’t know how the object designer and the code view work… as you can imagine i m pretty new with navision…
Let me explain my job:
I have to do a lot of reports to automate data visualisation in excel, my manager wants a lot of reports working with some ERP’s:
-sage
-A3 ERP
-Navision
I already have done lots with A3 ERP and some others with SAGE, now I m working to adapt theses reports to Navision…
So I have a big MS SQL Server 2008r2 loaded with lots of databases (from A3 ERP, SAGE, Navision…) and I need to build the queries needed by the excel reports for each of theses ERP’s
That’s why I m on this forum asking help.
As I said I not looking for trouble and please excuse me if some of the readers are offensed… I know most people only wants to help with money, so just need to found an Angel
Correct and you need to step up to the challenge. Don’t expect someone to do it for you. You need to “get your hands dirty”. If you have specific questions about specific parts, then ask them. I’m sure you will find lots of people willing to offer assistance and advice. But do not expect anyone to do your job for you.
all of you are right, it s true that I have to put my hands dirty and learn more deeper the navision data structure to be able to do my queries… but as I said I have a very short time… but I will do it and also ask a delay to my boss.
babrown, it s true that I m not an end user…
The goal is:
my company sels a product who acts like an interface between excel and databases, it’s business intelligence tool but 100% based on excel reports…
The product is able to connect to all databases using obdc and workds like this:
the product has the databases connections defined in it ( xx erp’s)
the user who has the product is able to connect to a web site and download BI reports (sales activity, inventory, company balance, etc…). Each excel report has a meta tag that indicates what kind of query he needs and for which ERP’s, each report has also some macros to do manipulations (build pivot table, apply layout, etc)
from the product, the user import the downloaded excel template, the product goes then to our “universal query repository” and downloads the needed queries, then the product retrieves the data, copy the data to the excel template, executes the macros, and save the template as a final excel report.
the product can also send the reports by email, post them to a ftp, and can also schedule the production of reports…