Skip to main content

O365: Using Word to Make a SharePoint Invoicing System

O365: Using Word to Make a SharePoint Invoicing System


Note: Requires MS Word Client based application.

See also - Blogs on Library, Lists, Linking and Integration

Practical Business Uses for Office 365


One way of looking at Office 365 is to imagine it as a massive toolbox. The businessman, like any good craftsman, identifying a need for the business turns to the tool box for a means to effect a solution.

The problem is that it is not always apparent which O365 tool to use to get the most effective result.

Word is Integrated in O365

All Office 365 plans have the Office suite of Word, Excel, PowerPoint and Outlook. In some plans these are restricted to the browser versions of the applications, but others have additional downloadable client versions. You can also use stand alone compatible client versions of Office to link Office 365 and SharePoint.

The following requires a client version of Word.


A New Library with SharePoint Fields

Any new library created in SharePoint has a ready made Word template created. This automatically captures the library meta columns as document fields. You can also import additional templates to any library either through the Upload link or the New link on the library toolbar.

The templates can be edited to include the positioning of the SharePoint meta fields (columns) into the body of the documents.

  1. First create the library and name it Invoicing - 


  2.  Then edit the library template to place the SharePoint Fields

    From the Library Home Page click the gear wheel > Select Library Settings > Click Advanced Settings and in the Document Template area click edit template


  3. This should open in the client version of Word.


 Add Logos and text as required. In this example I've used a table to control the columns and the fields are the items in square brackets.
To insert a field. Place the cursor where the field should be > click Insert in the Word tool bar > select Quick Parts and Document Property, then select the field from the list.

Using the new Library


  1.  Once the template has been prepared return to the Invoices library and click New and select Document. This will open the new Invoice in the Browser version of Word. 

  2.  Change the name from Document1 to a name of your choice (I use the invoice number) and allow it to save. Close the Word document.

  3. Return to the Invoices library, select the new Invoice and click the i symbol to open the Meta data editor > select Edit All and populated the fields. Once done click save.

  4.  The invoice is now complete. When opened in the client version of Word it will appear - 


All of the detail of each invoice is retained in the SharePoint library and can be used for future reporting and analysis.

Being a Word template, you can add a watermark background image, apply any header, footer, logo or branding required and print either to paper or to PDF for electronic invoicing.

We can show you how, or we can do it for you.










Labels:

Comments

Post a Comment

Popular posts from this blog

Microsoft Teams

Microsoft Teams – Not only but also... What is Teams? Chat, Meetings, Calling, Collaboration | Microsoft Teams That’s the legend that Microsoft uses to head their Google listing. And it does those things really well. But -  There’s more . Teams also delivers a gateway to the fabulous world of SharePoint file storage, SharePoint and Office 365 index and search and Office 365 file security. All without the need for technical knowledge or extensive configuration. All well and good... What exactly does that mean? When you create a new team, simply click the ‘Join or Create a Team’ box at the lower left of the teams window, you launch a new team that has all the necessary attributes. This includes a mailbox, chat, call and video meeting area and a SharePoint file space with a basic library. Move shared documents, of any type, into the library and they are shared with other team members (the share facility is configurable to exclude individuals in the team who do not have sufficient righ...
Post a Comment
Read more

O365: SharePoint Searching in Office 365 and Teams

 O365: SharePoint Searching in Office 365 and Teams See also -  Other Office 365 Posts Earlier posts have discussed the huge advantages of centralising documents, files and communications in SharePoint and Office 365. One of the strongest functions in Office 365 is the ability to search all content so that locating data is easy. However, the search tools in Office 365 are not always obvious. Teams Search Teams is becoming really popular, not least due to the fact that it makes SharePoint very easy to deploy, use and control. At the top of each Teams General Tab is a search box This is multi function. Type / into the box and you will see a list of commands that will perform all sorts of Teams functions    The /Files option will return files you have recently accessed. Great, if the file or document you are looking for is actually in the recent file list. What if the information you require is in an older file, or in a different location? Location Search Also in Teams ...
Post a Comment
Read more

Knowledge - The Ultimate Resource

Knowledge – the ultimate resource? I can’t argue with that. As a writer I’m in the business of providing knowledgebase elements. I take my own experience and that of others, I then turn it into some form of written document that may be understood and acted upon by the intended audience. Quote from Wikipedia - Human-readable knowledge bases are designed to allow people to retrieve and use the knowledge they contain, primarily for training purposes. They are commonly used to capture explicit knowledge of an organization, including troubleshooting, articles, white papers, user manuals and others. The primary benefit of such a knowledge base is to provide a means to discover solutions to problems that have known solutions which can be re-applied by others, less experienced in the problem area. · The most important aspect of a knowledge base is the quality of information it contains. The best knowledge bases have carefully written articles that are kept up to date, an excellent information ...
Post a Comment
Read more