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

Acquiring Market Share. MD, MD, how does your business grow?

Gaining an increase in market share may become necessary for a number of reasons. You may need to shift focus from one product line to another in the face of a declining market, you may wish to expand to fend off a market place squeeze or you may just be growing towards your planned capacity. Whatever the reason, you will need to form an acquisition strategy. There are three ways to obtain an increase in market share – Earn it. Use competitive trading to buy it. Acquire a competitor. Each of the three approaches bring along its own strategy requirements and its own issues. Selecting the best approach depends entirely on circumstance. Outperform the competition. Earning market share by supplying a better product, better service, better support, better delivery is an honorable way of expanding a customer base. It is steady, progressive and undemanding in that production/purchasing is not subject to stresses caused by sudden up-shifts in supply/delivery. Even so, there are issues. Attaini...
Post a Comment
Read more

The New Computer Age: Office 365 Vs Google, Dropbox and Others

Differences in Software as a Service ( SaaS ) This is the 21st century, the New Computer Age. Cloud services and SaaS are available for all to use. Word on-line, Excel on-line and Power Point on-line are just such services. They are available to all who want them, they are free, if taken via One Drive Live, and they enable the creation, editing and viewing of Word documents, Excel spreadsheets and PP presentations on ANY device that has a browser installed. This without any need to install software on the device used. The on-line software that is used to create the files is the same on-line software used to view them. There can be no incompatibilities and no missing fonts. Open Document Standards, to which these most office applications conform, requires that any document file should contain the properties of style, layout, font etc. These elements are the property of the document file and will travel with it wherever it is stored or sent. However, issues can still aris...
Post a Comment
Read more

O365: Mobile Apps - the easy way

 O365: Mobile Apps - the easy way See also -  Other Office 365 Posts Anyone following these posts will now know how easy it is to create data stores in SharePoint for documents and files and for listing data, such as customer details. We've also looked at making this data easily findable, how to flag items for the attention of individuals and teams within the Office 365domain and moving work through the system in a controlled manner. We've also seen how we can access this content when away from the office via mobile apps for Teams, SharePoint and OneDrive. Occasionally the standard apps aren't really convenient and fail to lend themselves to mobile use. I'm thinking here of functions like stock lists, customer contact lists and the like, when the standard app delivers too much detail for a small screen, or where links and buttons are small and difficult to use. For these functions it would be better to deploy an app that is designed for fast, effective use on a mobile. ...
Post a Comment
Read more