Welcome to MSDN Blogs Sign in | Join | Help
Creating add-ins in C#? Simply use the templates!

I'll just start out with an easy tip here that I think could be helpfull to many who want to create add-ins for Office Accounting (and yet so easily missed)

If you install the Office Accounting 2007 SDK it will include a couple of templates that you can use directly in visual studio.

If you pick the OfficeAccountingAddIn template you will be able to chose between some of the types of add-ins that you can create in Office Accounting.

And the basic Solution with driver registration, driver info, and other basice will be generated for you...

I like, I like!! By nature most developers are fairly lazy, I know I am! ;o) so if I can get free code like this I take it.

Posted: Thursday, November 09, 2006 10:25 PM by Jorn

Comments

Christopher Clark's AvaBlog said:

I'll just start out with an easy tip here that I think could be helpfull to many who want to create add-ins...

# November 10, 2006 11:46 AM

Coding for Office Small Business Accounting said:

Wow, the number of bloggers on the team is growing exponentially!!! I was alone for quite some time and

# November 10, 2006 10:16 PM

Jorn Lindhard Mortensen's blog said:

I have been asked how to do these things if you are a VB programmer. Well my very first comment you may

# January 16, 2007 4:13 PM

Papoo said:

I also want to integrate my website database with office accounting. I want to show customer and sale report, but do not know how to start, and how to connect with sql server.

There are samples which connect with .sbc file, but i want to connect with mdf file.could you tell me how?

Looking forward for your response.

Thanks in advance!

# September 25, 2007 11:15 PM

Jorn said:

Hi Papoo

Connecting to the database itself is not hard, see my post on "Creating reports that can access data in SQL" if you want an example. this means you can select data from the database directly from SQL (the problem is to find out what to select).

Reading your question I'm not sure if you want to select data or actually try to run a report directly in the database? The latter is much harder (and not recommended) In theory you can run the stored procedure for that report to get to the data, but really - this would be hard to do!

# September 26, 2007 9:53 AM

Papoo said:

Thanx for ur quick response. Actually we develop a site in 'ASPDNSF' and client also want to integrate customers and sales orders/invoices from AspDotNetStoreFront into Microsoft Office Accounting.

As I told you, I m new in MS Accounting, so do not know how to integrate it. Either for this I need to coding or a simple steps to perform this without coding?

# September 26, 2007 9:25 PM

Jorn said:

Hm this is a little hard, I'm not sure what you are trying to do exactly.

If the integration is to show stuff from Office Accounting on the Website you can go against the DB directly.

If you need to be able to add things to Office Accounting (Like create a new sales order) you will need to use the Office Accounting SDK (there is a link on this site). The SDK comes with documentation and sample code to help you get going...

If that doesn't help you please ask again, and I'll try to help

# September 26, 2007 10:15 PM

Papoo said:

Hi Jorn

we create a seprate desktop application for doing these things. I mean just pick the data from my sql server db and show them on MS Office Accounting

# September 26, 2007 11:39 PM

Jorn said:

I'm really sorry, it is still not clear to me exactly what you are trying to do. Let me ask a few questions to help me understand…

- As I understand it you are trying to show data from one system in the other system.

- You are not trying to move the data from one to the other.

- Where are you trying to show the data?

- Where should the data come from?

# September 26, 2007 11:51 PM

Papoo said:

soory for not convaying u properly

the answer of ur question is

- As I understand it you are trying to show data from one system in the other system.

Ans. what do u mean by system.

- You are not trying to move the data from one to the other.

Ans. yes

- Where are you trying to show the data?

Ans. MS Office Accounting

- Where should the data come from?

Ans. From My SQL Server Database

I just only show the report of customers and sales orders/invoices from my sql server db using MS Office Accounting 2007

# September 27, 2007 7:13 AM

Jorn said:

OK, part of my confusion is that Office Accounting is also running on a SQL server database :o)

System, I just meant from one application to another.

How do you want to show the data?

- just like data entered directly in Office Accounting? If so you will need to create your sales orders and invoices in the OA application by using the OA SDK (basically you will have to copy the data into OA).

- In special reports just to be able to see everything inside Office Accounting? You can do this by creating a new INativeReport and get tha data directly from your database in the CreateData method, or you may be able to create an IReportExecutor that could open a website or report in your other application...

# September 27, 2007 11:54 AM

Papoo said:

Thanx Jorn

So I need special reports usinf CreateData method.

I think we move this discussion to your other blog 'Creating reports that can access data in SQL'

I have some question so asked you on that blog.

# September 27, 2007 10:32 PM
Anonymous comments are disabled
Page view tracker