Relocation Expense Transfer - Cap Remaining

Owned by Amanda Thomas
Jul 19, 2018
3 min read

Introduction

The expense transfer process can transfer portions of the cap balance of a layer flock to another destination flock. Although it is exceptional, this type of transfer is necessary in instances of catastrophic failure on the layer house. Birds would need to be relocated, and with them, a portion of their value.  

Configuration

Unlike the expense transfer process, you will not need to configure a Transfer Configuration. The source flock will need to have capitalized expenses, which require capitalization configurations. To configure capitalization you will need to  create cap codes, and setup the source flock's capitalization settings on the "Production" tab of the flock form. 

Getting Started

Once you have configured the system, you will need to create a transfer out record on the source layer flock. Once you select a flock, The transfer out grid is located at: Live Inventory Options -> Live Inventory Trans -> Transfer Out. Create the transfer, specify a transfer date and number of head. Specify a destination layer flock and house. To transfer a portion of the cap balance, check the "Trans Cap" field.

The transaction form used to trigger an error if the user selected both the expense transfer and trans cap option. This validation has been removed, and replaced with logic that will prioritize the transfer of cap amounts over the transfer of expenses. If any one transfer out has the "Transfer Cap" box checked the cap balance, then all "Transfer Expense" selections will be disregarded and the transfer cap process executes for the flock- you cannot execute both on the same flock.  

The Process

The process uses the exact same logic as the expense transfer process, only instead of transferring a portion of expenses it transfers a portion of each depopulation cap adjustment.  

  1. The process gets information about the source (transferring) flock (Code, Accounting Close Date).

  2. Next, it will get all transfers out for the flock, filtering out all transfers without the "Transfer Cap" option checked.

  3. Create a transfer audit table.

    1. This table is returned at the end of the process, and can be reviewed on the reconciliation form.

  4. Calculate capitalization totals for the source flock.

  5. Calculate the depreciation schedule for the source flock.

  6. Find all "Depop/T-Out" depreciation records.

    1. These records represent an adjustment of the cap balance based on all head depopulated for the period (week or day).    

  7. For each of these records.

    1. Create an audit record.

    2. Get all transfers:

      1. For this house.

      2. For this period.

      3. With the "Trans Cap" column checked.

      4. Whose destination flock has a valid cap code.

    3. Get the absolute value of all "Head Added" values for all depreciation adjustments on this date.

      1. Since birds were depopulated, and these records are not considered "Mortality Loss", this value appears as a negative number on the depreciation schedule.

      2. This is the total number of head transferred for the adjustment, for all placements. 

    4. For each transfer out:

      1. Calculate percent to apply.

      2. Calculate the amount to apply.

      3. Create a cap adjustment record for the destination flock.

      4. Update the adjustment record for this expense.

      5. Balance Pennies.

        1. Because we are multiplying values with a precision of 4 decimal places, it is likely that we will gain or lose pennies along the way. If we are off by pennies, this function will apply them to the last record created until the totals balance with the amount adjusted from the depreciation schedule. 

  8. Create Cap Adjustments on the destination flocks.

    1. Save the cap adjustment records to the destination flocks.

      1. Cap adjustment records are created on the "Manual Expense" tab of the flock expense form.

      2. For this first iteration, the process can only create Cap adjustment records for the starting cap code.

      3. Records can be created behind the accounting close date- their adjusted amount will be applied to the earliest calculated amount of the depreciation schedule.  

  9. Calculate Amount Per Head.

    1. This value is calculated for the reconciliation form.

Reconciliation

  1. The reconciliation form will open and execute the expense transfer process.

  2. The form will list all transfer out records with the "Trans Cap" field checked.

  3. Rather than list all applicable expenses and for the flock, the form will list all depreciation adjustments caused by depopulation loss.

  4. Each transfer that received a portion of an expense will be listed by transfer id on the column of the grid.

  5. If 100 % of the transfers have their trans cap field checked, then each adjustment will have a difference of zero.

  6. If there are not as many transfers configured to "Trans Cap" as there are head depopulated there may be a difference.

  7. Expense Transfer capitalization does not create a column for birds remaining, like the expense transfer process. Transferring out birds mid-cycle is exceptional- the system doesn't have a count for how many birds may be depopulated.