Inventory Video

Inventory

This tutorial will demonstrate how to add inventory to a farm, and change the inventory amounts using transactions.

In AgWare MGR, inventory is a farm product available for sale.  It could also be used for inventories of materials used in production, such as seed, fertilizer, etc.  Inventory items are identified by unique combinations of four data fields: Farm Code, Inventory Code, Location Code, and Production Year.  Initial inventory setup is done in the Farm section under the Inventory Tab and then changes to inventory amounts are done in the Transaction section.

We’re going to start by adding a new inventory item to a farm.  We’ll go to the Farms section, choose farm S7 Boulder Valley Ranch from the drop down at the top, and select the Inventory tab.  The inventory tab contains all the inventory items for the farm filtered by the production year.  You can change the production year either by typing the year into the year spinner or use the up and down arrows.

To add a new inventory item to the current farm, simply click the add button on the toolbar.  You’ll see that this created a brand new blank row.  We’ll go ahead and start filling out our first inventory record.  We’ll start with the inventory code.  This is a unique user defined code.  We’ll choose to call our inventory code Corn.  Next, we need to pick an inventory location from the drop down.  These inventory locations are configured in the Setup, Master Data Codes, Location tab section of the program, so if the location you need is not available in the drop down you’ll need to go create it in the setup section.  For our example, we’ll choose COOP.  Next, we’ll need to choose a production year; I’ll go ahead and choose 2016.  Then, we need to choose an enterprise.  The enterprise drop down contains a list of all enterprises currently attached to this farm.  You’ll want to make sure that your inventory enterprise matches the GL account enterprise.  So, in this case, my inventory record is for corn inventory and in my database corn has a GL enterprise of 121 so I’ll choose 121 from my enterprise drop down.  The combination of the inventory code, inventory location, production year, and enterprise code must be unique for each inventory record.  Next, we’ll enter a description.  This can be any description relevant to the inventory record.  I’ll go ahead and enter Corn 2016 for my description.  Next, we need to input the owner’s percentage of the inventory record, or how much of this inventory record they own.  We’ll enter 100.  Then, we need to enter the acres harvested, so we’ll enter 875.  The next two fields yield and % sold are read-only, calculated fields that will populate as your inventory levels change.  The last step to creating our new inventory record is to enter the beginning number of units and the unit value.  We’ll enter 10,000 for our beginning units and $2.50 for our beginning unit value.  Once we tab or move out of the beginning unit value field you’ll notice that our beginning market value is automatically calculated for us.  It simply takes the beginning number of marketing units multiplied by the beginning unit value to give us the total beginning market value of our new corn inventory record.  You’ll see that our calculated units and calculated amount also automatically populated.  The calculated units number is the beginning units plus the adjusted units minus the sold units.  Then, the calculated number of units is multiplied by the beginning unit value to give us the calculated amount.

Now, we’ll move to the transactions section of the program to enter a corn sale transaction with inventory amounts.  We’ll go ahead and start a new batch for this transaction by clicking the add new batch button.  This opens directly to the transaction editor where we can begin entering our transaction details.  Since we’re entering a corn sale, we’ll choose a transaction type of receipt.  We’ll leave the transaction date and production year as-is.  Then, we’ll go ahead and choose our S7 farm from the farm selector.  Next, we’ll enter the cash sales corn GL account number which is 121-3111-0 in my database, and enter our credit amount of $13,000.  Next, we’ll choose a vendor and enter the transaction description.

Now that we have our transaction information entered, we need to enter the inventory details for the transaction.  To do this, we’ll expand the Inventory/Production section, and choose a type.  Since we are selling corn inventory, we need to choose an inventory type that affects the sold units.  We have two options: either type six which is produced and sold or type ten which is sale.  For this transaction, we’ll go ahead and choose type six, produced and sold since the corn was produced on our farm.  You can find a detailed listing of the inventory types and how they affect the inventory amounts in the Inventory Transactions knowledge base article on our website.  Next, we need to choose an inventory code.  Only those inventories tied to the transaction’s farm will be available in the inventory code drop down.  We’ll go ahead and choose our Corn inventory code.  Next, is the location code.  This list is automatically filtered to only show available locations for the selected inventory code on the selected farm.  Since we only have the one inventory record tied to farm S7 for the 2016 production year, we’ll go ahead and choose the COOP location from the drop down.  Then, we need to enter the number of marketing units.  For our sale, we’ll enter 5,000.  You’ll notice that once we enter the marketing units, the marketing price automatically calculates for us.  This is simply the transaction amount divided by the number of marketing units.  If you need to override the marketing price for any reason, click the pencil button to the right of the marketing price field to enable it for editing.

Now that we have our inventory transaction complete, we’ll go ahead and click the save and close button.  This takes us back to the manage transactions section.  Our inventory amounts in the farm section are not updated until we post our inventory transaction, so we’ll go ahead and go to the manage batches section.  Then we’ll select our batch that contains the inventory transaction, and click post.  Once the batch is posted, we’ll go ahead and go to the Farms section to look at our new inventory amounts.  So, we’ll go to farms, edit farm, make sure our S7 farm is selected, and go to the inventory tab.  Here you’ll notice that our beginning units stayed the same.  We have the same 10,000 units at a unit value of $2.50 for a total beginning market value of $25,000.  But now when we look at the sold column, we see our 5,000 units that we entered on our transaction, and our amount is $13,000 which was our transaction amount.  The inventory transaction then updated our calculated column as well.  Our calculated market units are now 5,000.  They are then multiplied by the beginning unit value of $2.50 to get a total calculated amount of $12,500.  You’ll also notice that our yield and sold percentage fields updated as well.  Our yield is now 11.43.  This number is calculated by taking the beginning marketing units and dividing it by the acres harvested.  In our case, it takes the 10,000 divided by 875 to get 11.43.  Our sold percentage is now fifty percent meaning that half of our beginning inventory is now sold.  For the sold percentage, we add the adjusted marketing units and sold marketing units; then we take the beginning marketing units divided by that sum, and multiply it by one hundred to get the total sold percentage.

You can also use inventory transactions to adjust inventory levels by using a general journal transaction.  You may need to adjust inventory levels if you feed some on hand inventory to cattle, or if the crop dries and there is less inventory than was brought in, etc.  To enter a general journal inventory adjustment, we’ll go to the transactions section, and start a new batch.  We’ll select the general journal transaction type, and leave the transaction date and production year as-is.  Next, we’ll enter our farm S7, and choose the inventory adjustment GL account which is 00-1330-0 in my database.  We’ll say that our inventory adjustment is because we fed some of our inventory on hand to our cattle.  We won’t enter a dollar amount on our transaction, because we only want to affect the number of inventory units on hand; we don’t want to change dollar amounts in any GL accounts.  Then, we’ll enter our vendor and a description.  Then we need to expand the inventory/production section and choose an inventory type; we’ll choose type 13 which is an inventory adjustment decrease.  Next, we’ll choose our inventory code of Corn, and location of COOP.  Next, we’ll enter our units; we’ll input 500.  Now, we’ll click the save and close button.  Then, we need to post the batch containing the inventory adjustment transaction since the inventory doesn’t adjust until the transaction is posted.  So, we’ll go to the manage batches section, select our inventory adjustment batch, and click the post button.  If your general journal inventory adjustment transaction contained a dollar amount, you would need to enter an additional general journal transaction before posting to account for the offset.  Since our transaction didn’t have any dollars, and we only wanted to adjust the inventory amounts we can enter just the one transaction.

Now that our inventory adjustment transaction is posted, we’ll go to the Farms, edit farm section, make sure our S7 farm is selected, and go to the inventory tab.  Here you’ll notice that our beginning units are still the same, but we now have values in the adjusted column.  You’ll see a negative 500 for the marketing units because we entered an inventory adjustment decrease type.  You’ll also notice that our dollar amount is zero.  Our sold units stayed the same since we didn’t enter any additional sold inventory transactions.  However, our calculated column now updated.  You’ll notice our calculated marketing units are now 500 less than before the adjustment which is exactly what we would expect.  The program then automatically calculated the total calculated amount by taking the 4,500 calculated units remaining multiplied by the beginning unit value of $2.50 to give us a total calculated amount of $11,250.  Our sold percentage also updated since our total calculated units on hand changed.  This shows us that 52.63% of our beginning marketing units are now sold or used leaving 47.37% of our beginning marketing units in inventory.

If you have any questions about how to add inventory to a farm or change the inventory amounts using transactions, please don’t hesitate to give us a call at 605-791-4872 or send an email to support@agmgr.com.

 

 

Customizing Statement Reports Video

 

Customizing Statement Reports

This tutorial will demonstrate how to customize the statement reports in the Statements section of the program.  This video applies to all statement report sections.

AgWare created a new field for the Statement Reports called an MgrIndentMemo.  This field allows the user to control the indent width of the field, the style of the statement headers, and the style of the statement footers.  The first step to customizing your statement report, is to run the report that you want to customize.  I’ll go ahead and run the statements by farm income summary report.  Next, we need to make a copy of the system report, as you can’t make changes directly to a system report.  To copy the report, we’ll click the design report button, and click the copy report option.  If you do not see the design report button, this means you don’t have permission to design reports.  You’ll need to contact your database administrator to make the custom report.  You’ll then need to give your report a name; this can be anything you would like.  I’ll name mine Customized Income Statement, and click the OK button.  Once you click OK, this will open the report directly into the report designer.  On the left side of the designer, you’ll see a toolbar of buttons.  These are all the report object options; in other words, they are the different items you can add to the report.  For example, the fourth item from the top is used when adding a text field.  The second item from the bottom is the button for the new MgrIndentMemo field.  Since this is an existing statement report, we already have the MgrIndentMemo field added to the report.  You’ll see it in the DetailData1 band.  If the field was not already present in the report, you would click the left toolbar button, and draw the field on the report where you want it.  You’d then use the down arrow key shown when hovering over the field to set the field name.  When you select the MgrIndentField, the name of the field appears at the bottom of the screen.  Notice it says TMgrIndentMemo1.  This is exactly what we want to see, because this means it is our new field that has the additional options for indenting and formatting.

The first new option we’ll look at is the indent width property.  On the bottom left of the screen, you’ll see the object inspector.  This shows all available properties for the selected report field.  We’ll go ahead and make sure our MgrIndentMemo is chosen.  Then, we’ll scroll down in the object inspector until we see the IndentLevelFieldName property.  All items in the object inspector are in alphabetical order.  The IndentLevelFieldName property should always default to IndentLevel.  If it doesn’t, go ahead and select it from the available drop down list.  This property tells the report that we want to look at the value in the IndentLevel field of the Statements table in the database to determine the indent level of the current statement item.  The next field is the IndentWidth.  The unit of measurement for the indent width is shown in the bottom left hand corner of the report designer.  The default unit of measurement is inches.  If your report is not in inches, you can double click on the unit of measurement shown to change it.  The default IndentLevel for the system reports is .15 inches.  You can increase or decrease this amount by entering your own number.  For instance, if I change this to .5 inches, and preview the report by clicking on the preview toolbar button, you’ll notice that the indent width is much larger than it previously was.  Now, I’ll click the close button to close the preview, and I’ll change my IndentWidth back to .15 inches.

The next new option we’ll look at is the HeaderGroupStyle.  All options contained in this main property will only affect the headers you’ve configured in your statement setup.  When you click the plus sign to the left of the HeaderGroupStyle, you’ll see five different options.  The ExtraIndent field gives you the option to apply an extra indent to the headers.  The font options allow you to change the font name, font size, and font style.  If we click the plus sign to expand the font options, and then click the plus sign to expand the style options you’ll see the normal bold, underline, italics, and strikethrough options.  If you choose any of the font options in the HeaderGroupStyle, you’ll want to make sure you check the UseFont option.  This tells the report to override any of the default font options, and use the special font options you’ve configured here.  We’ll go ahead and set our header size to 12 and we’ll also underline it.  Now, we’ll preview our header changes.  You’ll now see that only the headers have a larger font size and are underlined.

The next option is the Frame option which contains the various options for setting the field’s frame such as the frame color, frame width, and frame type.  To apply a frame type, you’ll expand the Typ property and set the desired property to true.  If you choose any of the frame options in the HeaderGroupStyle, you’ll want to make sure you check the UseFrame option.  This tells the report to override any of the default frame options, and use the special frame options you’ve configured here.

The other new option on the MgrIndentMemo is the FooterGroupStyle.  The properties contained in the FooterGroupStyle are the same as the options contained in the HeaderGroupStyle except they only apply to the footers you configured in your statement setup.

If there is more than one field in a report line, you’ll need to apply any desired changes to each field.  For instance, in this report I have my display name field on the left and my period print value field on the right.  Even though they are on the same line, since they are two separate report fields they each contain their own properties.  If I wanted to turn on the top frame for the footer on the dollar amount shown on the report, I would select the period print value field, expand the FooterGroupStyle options, expand the frame options, expand the typ options, set top to true, and check the use font option.  Now, when I preview my report it shows the top frame on each of the amounts shown in the group footers.

As noted previously, you can use the preview button on the toolbar to preview any changes you have made to the report.  To close the print preview, you’ll simply click the close button on the toolbar.  When you are finished applying your changes, you’ll click the save layout and close button.  This will then close the designer and take you to the printed report.  Now, when you come into the report tab, you’ll see that your custom report appears in the group above the system reports.  You can create as many customized statement reports as needed.  Simply follow the previous steps to create the other reports.

If you have any questions or comments about customizing statement reports, please don’t hesitate to give us a call at 605-791-4872, or send an email to support@agmgr.com.

 

Single Farm Statement Setup Video

This tutorial will demonstrate how to create a statement setup for single farms in the Statements Setup section of the main Statements section of the program.  The income statement shown … Read more