Skip to main content

SharePoint 4 Biz - Setting up Expense/Purchase Register

Very often we need somewhere to register purchases or expenses. There can be various reasons for that, but the main are:
- store all expenses in one register to categorize, approve, review, report etc.
- ability to upload scanned receipts for future claims, reimbursements, warranties etc.

So here's how it can be done in SharePoint 2013 or SharePoint Online / Office 365.

Start with creating a content type - in our case it is Receipt:

1. Go to Site settings:


2. Select Site content types:

3. Click "Create":

4. Provide content type details. We suggest to create a new Group for it and inherit from Document content type:

5. Add site columns to the content type. We think the most important would be Purchase Category (Travel, Food, Activities etc.), Vendor, Amount, Purchase Date and Warranty Date:


Then we create a document library:

6. Go to Add an app:
 7. Select Document Library:

8. Provide a name (Receipts in our case):
 9. Go to Library Settings:


10. Go to Advanced settings, set Allow management of content types to Yes and click OK button:

11. Add the Receipt content type and delete the Document content type:


That's it - our new Receipts register is ready to use.

Now you could either scan your receipts or take a photo with your mobile phone and upload to this document library.

Comments

Popular posts from this blog

Setting up External Content Type for SQL Server database using SQL Server authentication - SharePoint 2010 Foundation

This post is a follow up on the issues that I have got setting up External Content Type (ECT) on SharePoint 2010 Foundation that was going to connect to remote SQL Server database for information. I cannot use my SharePoint user accounts to access SQL Server. According to the information I have discovered ECT and Business Connectivity Services are available in the SharePoint 2010 Foundation, but there are some issues if you want to use authentication methods in your external connections that are different from Windows Identity or Current User Identity. This is because there is no Secure Store Service in SharePoint 2010 Foundation which serves as an impersonation hub and is only available in SharePoint 2010 Server edition. The issues are coming from the fact that you can actually create ECT in SharePoint Designer 2010 providing just Secure Store ID and system would ask you for credentials and here you go, but when you try to use your ECT in External Lists or as a lookup columns you w...

Document Sets - SharePoint 2010 - Part 1

Hi again, in this post I am going to demonstrate how set up and start using Document Sets in SharePoint 2010. In Beta version there was a little problem when working with Document Sets. You could see the discussion around it here: Document Set content type issue . Now it is fixed and I will show you how to set up Document Sets properly to also use Keywords. 1. Activate two site collection features - Document Sets and Document ID Service: 2. Select a document library settings where you want to implement Document Sets. In my case it is Shared Documents. When you have selected the settings go to Advanced settings and then allow content types management: 3. Add an existing content type called Document Set: 4. Now I want to create a new Document Set. I have a sales opportunity and I have two documents related to this sales opportunity. So first I select New Document -> Document Set command, then provide name and description and there it is: 5. To check if our Document ID...

Version control in Office 365

When working with documents in SharePoint or Office 365, quite often files are named like "Project-Budget-Report-v1.55", "Project-Budget-Report-v1.56", "Project-Budget-Report-v2.0" etc. and stored in the same folder or library. This is to achieve version control from the user perspective. This is not a good idea for the following reasons: Storing redundant information Confusion which version to use when Browsing though many documents to see what information/metadata changed if required Version numbering should be automated, no time spent by the document author There is a better way to manage versions of documents and to use tools already available to us in Office 365. File name should not contain the version number in it. Every time you upload a document with the same name the SharePoint will increment the version number for you automatically in the current set up of our Office 365 site we use for customer documentation. Then to manage the...