Monthly Archives: February 2015

Monthly Billing

For many people there is always a bit of anxiety when it comes to creating an invoice. There is only one reason to invoice: we need to get paid for the time and resources expended that month, so that we can invest more time and resources next month. As far as Fusion is concerned, invoicing can be boiled down to five considerations: Items, Usage, Attributes, Yardage, and Other Items. The first three areas are where we are going to set our focus, but for now let’s talk about yardage and other items.

Yardage is simply a value put against head days of a lot. Other items are a way of attributing a bulk charge against a lot. These can have a note associated with them and can be backdated, and as long as it is within the current billing period these items will appear on the invoice. You can add other items in the Billing tab of the Lot Edit window.

Both yardage and other items are quite simple to use and understand. The next few areas are a bit more involved and deserve more attention. Let’s start with “Items”. Items are ingredients, inputs, or drugs and are created in the Admin module under Set Up.

“Usage” is determined by the actions taken in the yard:

  • Feeding creates usage that will effect commodities and ingredients.
  • Chuteside events (treating or processing) will create drug and input usage.
  • Other input usage can be created by using the Bulk Add Input window for things like bedding or pen delivered hay.

Once usage is created it will be associated with an attribute. Attributes can be set at any time within the current billing period. This includes backdating the item attribute to the beginning of the billing period at a later point. Most usage will only need to be multiplied by “cost” and “bill at” values for each item, but some items like ingredients and some inputs will also rely on dry matter or equivalency values to come up with the correct usage, cost, and bill at values.

The point is that before we invoice we should review our attributes and usage. These two areas, if not set or tracked properly, will give you grey hair no matter how you create an invoice.

Here’s how we do it. First, let’s review our current attributes. As you are well aware, very few of these attributes will change month to month so it is not always necessary to print this off every time, but this is how to find your current attribute values:

  1. Open the Bulk Attribute Change window (Fusion Core → Attributes → Bulk Attribute Change).
  2. Select the item (ex. Drug) on the top left then the attribute (ex. Cost) just to the right. Now click the Fill List button.
  3. Click the Show Advanced button on the bottom left of the window. In the middle of the window you will find an area that lets you change the information in the “Previous” column based on these choices. Fill the Item Attribute, Location, and Date in with the information that you want to see. Now go ahead and click the Update Previous Column button. (Location is one thing you need to be aware of, because if you were setting location specific pricing or attributes these will only be listed per location in the list that we are about to print. If you are running location specific attributes you will need to print this list per location.)
  4. You will notice that the “Previous” column is filled with the current values that will be used for billing. Now go to any one of the column headers and right click. Four options will appear in a drop list. This is where you can print the list of current attributes.

I imagine that this list will only have to be printed off once or twice. After that you will know where to look to find current values and the list will not be needed. I also think that this is a great way to calm fears of wondering if you have everything covered.

Next let’s look at the usage for the month. You will find this in Fusion Office under Yard Reports. If you choose Feedlot Usage Report, the window that opens up will default to the previous month. Select the location (all locations is not an option). If you’d like you can narrow it down to a specific lot, but in this case we will leave that field blank. Now check all the boxes of the areas that you’d like to review (usually all of them) and print. With this report you will be able to see if you have all your cost and bill at values in correctly. You can also double check the usage for the month prior to invoicing.

If you do come across an item that was missed you can create usage in a number of ways. Depending on how you want this to happen you may have to create a virtual job or mix a load of feed and back date it, or create a drug or input event.

Once you’ve gone through these two steps you may find that you have completely missed a charge like a chute fee (which would be an input). At this point you have to go through this process:

  • Create an input called “Chute Fee”
  • Create “cost” and “bill at” attributes
  • Create usage. In a case like this I would just make an input event for the 250 “Chute Fees” against lot X if lot X had 250hd.

This would just be a bulk charge to cover the cost of what we had missed during that month. If this were a drug and I wanted the charges and withdrawals to apply to each animal I would create a virtual job.