Navigation:  Quick Start Tutorials >

5. Entering "extra" quantity information in QuickBooks

Print this Topic Previous pageReturn to chapter overviewNext page

 

In this topic:

 

ManagePLUS places no special requirements on how you enter transactions, with one exception:  if you use ManagePLUS' advanced quantity handling features you'll be entering quantity information in the Memo or Description field of some transactions, and that information must be entered properly in order for ManagePLUS to recognize and use it. This lesson shows how to enter quantities in the Memo or Description field of your transactions.

This is an optional lesson, because not everyone needs quantity information beyond what's possible with QuickBooks alone. The lesson assumes that you enabled advanced quantity handling in lesson 3.

If you are using one of the sample company files, you may simply open it in QuickBooks and browse the transactions to see examples of quantity entries like the ones in this lesson.
All screen shots in this lesson are from QuickBooks, not ManagePLUS, because the lesson deals with how to make quantity entries in QuickBooks.

Entering quantities in the Memo/Description field

When we say "Memo/Description field"...
 

We mean the memo field (column) in the line items detail area of a QuickBooks form. The reason we don't simply say "memo field" is that different QuickBooks forms label that column as either "Memo" or "Description".
 

Many forms also have a whole-transaction memo field as shown in the upper part of the the Deposits form, below. ManagePLUS ignores the whole-transaction Memo.

 

 

The usual place to enter transaction quantities is in the Quantity column of a QuickBooks form which supports using items (from the Items list)—Invoices, Sales Receipts, Write Checks, Purchase Orders, etc. These forms all have a Quantity column where you can enter a quantity directly.

But some QuickBooks forms, like the Deposits form, do not support using items and therefore do not have a Quantity column. ManagePLUS gives you a way to enter sales or purchase quantities on those forms. This approach is also useful if you simply don't wish to set up an Items list item for something you buy or sell.

The rules for Memo/Description field quantities are:

Type the quantity at the beginning of the field.
Separate it from other text in the field by following it with at least one blank space.
Only use digits (0..9) and mathematical symbols.
You may enter the quantity as a mathematical formula if you wish (described later in this lesson).

Examples

Here's a view of the Deposits form, with grain sales quantities entered in the Memo field.

And here's a view of the Write Checks form, with quantities entered on the Expenses tab. Though this form has an Items tab where it can except quantity entries, this example shows how you may enter quantities when you don't have an Items list item set up for that purpose.

Remember, ManagePLUS will only extract and use Memo/Description field quantities for accounts which have a unit of measure (UOM) entry in the Chart of Accounts window.

Entering two quantities in transactions

As mentioned elsewhere, having two quantities associated with certain types of transactions provides useful management information. Anything you buy or sell where both the count or number of items and their weight or volume are important, probably ought to have both of those quantity measures recorded as part of the transaction.

The rules for entering two quantities in a transaction's Memo/Description field are the same as for entering a single quantity, with this addition:

When two quantities are entered in the Memo or Description field, separate them with an equal sign "=".

On QuickBooks forms which have a Quantity column:

When using QuickBooks forms which support items—Invoices, Bills, Checks, Sales Receipts, etc.—the first quantity goes in the form's Quantity column, as usual, and the second quantity goes in the Memo or Description column.

Here's a Sales Receipt for a rancher's sale of some calves. The calves' total weight is entered in the Quantity field, and the number of head (count) is entered at the beginning of the Description field.

On QuickBooks forms which do not have a Quantity column:

QuickBooks forms which do not support Itemsthe Deposits form, or the Expenses tab of the Write Checks form are examples—have no Quantity column, either. So in those, both quantities go in the Memo or Description field, separated by an equal sign "=".

Always enter the two quantities in the same order as your unit of measure entries in the Chart of Accounts window. Otherwise, your quantity totals will be incorrect:  a mixture of both weight and count, for example.

Entering quantities as mathematical formulas

ManagePLUS supports entering quantities as simple mathematical formulas. Because they are in the Memo/Description field, the formulas remain a permanent part of the transaction, preserving important transaction details.

Here's a Deposit example. Quantities for the Sales:Grain:Soybeans (bu.) account need to be entered in bushels. (The abbreviation "bu." was added to the account's name, as reminder of the appropriate unit of measure for the account.)

The formula in the first detail line is (48000/17000)/60:

48000 The actual gross weight of the truckload of soybeans
17000The tare or "empty" weight of the truck
60The standard weight, in pounds, of a bushel of soybeans.
48000-17000 = 31000 net pounds of soybeans.
/ 60 (divide)= 516.67 bushels, the quantity ManagePLUS will extract from this transaction.
For full details and more examples, see the How To topic Entering quantities as mathematical formulas.

See also:

Using the advanced quantity handling features

 


Page url: http://www.goflagship.com/help/mp/index.html?qs_quantities_entering.htm