Solved

Lotus notes "Estimate" form to Quickbooks invoice

Posted on 2014-09-25
2
365 Views
Last Modified: 2014-10-12
I have an application for creating estimates. I want to somehow click a button on the form and transfer everything from the document to a new quickbooks invoice. Is this even possible. If so , I need direction and details.
0
Comment
Question by:schmad01
2 Comments
 
LVL 1

Accepted Solution

by:
Nick Halliwell earned 500 total points
ID: 40345536
Hi Schmad01,

The beauty of Notes is that you can write a program do do anything you want in Notes, you just have to have the development ability.

However Notes allows you many other ways of doing things.

For you problem, I think there is an easy way, assuming that you are on a recent release of Notes.

So long as you have a view that holds all the information that you want you can simply select the documents that you want to copy, then go to Edit, Copy As, Table.

This copy's all the fields that are in the view and allows them to be pasted into a spreadsheet, from here you can edit them and then have you QB program read the saved spreadsheet into the invoice form.

See attachments.  The 1st show the data in the Notes database and 2 documents selected, the 2nd shows the data appearing in a spreadsheet.  Simple and no coding required.  Any user can us it.

Hope this helps feel free to ask me some specific questions on this.

regards
Nick
Fig-1-CSSalesPower--Actual----Sales-by-A
Fig-2-LibreOffice-Calc.jpg
0
 

Author Closing Comment

by:schmad01
ID: 40376241
Yes, good solution. I think I can get by with that.  Thanks!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question