“Fatal Error: Allowed memory size of XXXXXX bytes exhausted (tried to allocate YYYY bytes)”

By default WordPress tries to allocate 32MB to PHP. You would need to manually increase the allocated memory to fix the error.

Option1 –

• Go to your WordPress root directory and open wp-settings.php for editing.
• Look for  define(’WP_MEMORY_LIMIT’, ‘32M’);
• Change the line to define(’WP_MEMORY_LIMIT’, ‘128M’);. This really depends on how much memory is needed. 64M should be enough in some cases. Others might need higher memory allocated.

Option2 –

• Go to your WordPress root directory and open wp-config.php for editing.
• Add a line define(’WP_MEMORY_LIMIT’, ‘128M’);. Again, this really depends on how much memory is needed. 64M should be enough in some cases. Others might need higher memory allocated.

These changes will not work if your web hosting provider has restriction on allocated memory. You would need to check with your web host in such cases.

Open Excel and enter data below

Now select data and Go to Insert –> Pivot table. Click OK.

Pivot table has been created.  Now drop fields in the right frame to Report filter, Colum levels, Row levels and Sum of values windows to create the report as desired. Then filter various values and see how report appears.

For example, when you filter on Designation Manger, reports shows you how managers in different departments are paid.

SkyDrive – SkyDrive is free web storage service from Microsoft. SkyDrive provides 25 GB of free storage. You need windows live id to access the service. Just like all other windows live services, you can use standard or enhanced security (http or https) to logon.

ADrive – ADrive provides 50 GB of free storage. You do not get secured access with free account. Secured access and other cool features such as desktop access, multiple sessions etc comes at the monthly price.

Box.net – Box.net provides a free lite account that comes with 1 GB space and host of other paid accounts.

BOXSTR – Boxstr.com provides 5 GB of free storage.

Mozy – Mozy.com provides 2 GB of free storage. You need a paid account, if you ant more. Secured access is provided.

DropBoks – DropBoks provide 1 GB of free storage. You get secure encrypted access. You can upgrade account for a fees for more storage.

orbitfiles – orbitfiles.com provides 6 GB of free space and option of paid account for more space.

humyo.com – humyo provides 10 GB of free space and option of adding more storage.

Storegate – It provides 2 GB free storage and option of paid account for more storage.

Other than these there are many more paid services for online backup. Carefully look at your need and choose a service that fits the need. Price, Secure access, company brand, overall storage and individual file sizes should all pay a key role while deciding the service.

Alternatively, you can double click on the control to select and keep clicking on the form to place the control on the form as many times as you want. Double click on the control again once you are done to deselect it.

For example, an image can be embedded or linked into text document. Something a text editor could not do earlier.

Embedding vs Linking

When you embed the object, any changes in the original object are not reflected in the embedded object. When you link a object, changes in the original object are reflected in the linked object.

Understanding OlE by embedding Excel data into Word

Object Linking and Embedding is Microsoft framework for allowing objects from one program to be available in other programs.

Follow this simple exercise to understand the concept better.

• Open Excel and enter data below

Name	Gender
Maya	Female
John	Male
Dan	Female
Nancy	Female
Dale	Male

• Now select data and click copy.
• Open a word document and click paste special.
• Select paste Link and Microsoft Office Excel Worksheet Object.
• You will realize all the data along with excel formatting has been copied. 
• Any data you change in original excel will be available in word. This is called Linking.
• If you had selected simply Paste in paste special option, any changes in excel will not be reflected in Word. This is called Embedding.

For example, to enter grades for students you may want to enter only A, B, C, D, and F. To see how to accomplish this in excel, enter data below

Now select Grade Column, and Go to Data -> Data Validation

Enter values as below

Settings

Input Message

Error Message

Now try to enter different values in Grades and see how Excel reacts.

You have different options while setting validation

• Restrict only whole number (Such as for Student role number).
• Provide a list (List of grades).
• Restrict number of character to enter (For example SSN will always be 9 digit).
• Or you can provide a custom formula.

You also have the option of setting hard error, soft warning or just information.

Try this example below to better understand the concept. Enter Data below in Excel

Now select Salary column, Go to Home -> Conditional Formatting -> Colour Scales -> More Rules -> Format Only Cell that contain

Set condition as below

Salary more than 100000 will be converted into red.

The concept can be applied more complex scenarios.

It would generally be advisable to keep field status optional in Posting Key and control fields using Field status Group. However, there might be scenarios where you would want to use Posting key (example you may want different field status based on debit and credit, in which case you would need to control field status using Posting key).

It should also be ensured that Field Statuses specified in Posting Key and Fields status group are compatible to each other. For example, assigning suppress and required for the same field will result in error.

Also look at Format ->Make same size option if you want to keep same look for controls.

Document type configuration controls

• Number range assigned.
• Reverse document type – This document type will get posted when you reverse the document.
• You can also control authorization by document type.
• Account types allowed for the document type – Asset, Customer, Vendor, Material, G/L.
• If document can only be used in batch input – Rarely used.
• Net document type – Used for vendor invoices to deduct cash automatically.
• Cust/Vend Check – If checked, only one customer or vendor can be used per document.
• Negative Postings Permitted – This check would allow to enter negative amount. This is particularly useful if you want to correct a document. You can do that by entering negative amount for wrong line item. This saves time by having not to post reversal document and corrected document.
• Inter-company postgs – If cross company postings are allowed.
• Enter Trading Partner – Allows manual entry of trading partner.
• Weather Reference Number and Document header text are required..
• You can also specify exchange rate type to be used with document type.