FarmBooks 4.0.6.4 Release Notes

Database Conversion

This release requires a conversion before the database can be opened.

  • New invoice preference font fields (name, size, and style) to allow control over the remitter fields displayed on the invoicing forms (estimate, invoice, credit memo, finance charge invoice, and statements).
  • Data changes to the report control file for the Schedule F Report (see report changes).
  • Data analysis to add new ATIG code 0583 Fungicide.
  • Data analysis to update payroll data for the most recent two calendar years.
    • Multiple Wages lines will have the net wage amount allocated per line based on the ratio of the line’s gross wages to the paycheck’s total gross wages. Before this release, the net wage amount was placed only on the first wage line.
    • The wage line will reflect the payroll default description instead of using the employee name for the wage line. The employee name will be replaced with the payroll default description for the wages ATIG/D code.
    • Payroll Entry using Batch Entry with multiple wage lines would overstate total gross wages when posting a payroll transaction. The data is corrected by analysis process if any overstated values are detected for the most recent two calendar years having paycheck data.

General Changes to Application

Assigned Printer Paper Source for either Reports or Checks
The assigned printer paper sources in the application preferences was not being applied to the report engine correctly causing the user specified printer settings to be ignored. It would use the windows default printer settings instead. Now, the user specified printer and paper source is used.

Display phone number fields with Edit Mask when non-focused field
All screens that have the phone number listed should be listed with the edit mask ( ) - in the phone number, it is much easier to read. It would only display the edit mask when the field had the input focus and it displayed as a string of numbers when not focused. This was changed primarily in invoicing and the employee setup windows.

Default Year for Date Fields
Check / Paycheck / Deposit Entry - Default for Unspecified Year was 1999 instead of the current year. Other areas of the application with the date field displaying a "15" as a button for the popup calendar had this issue.

Printer Properties not available from Page Setup from Printer Button
The Windows operating system version determines whether the "printer" button is visible from the page setup window of the printer setup dialog in the reports preview window. In Windows 7 or 8, this printer button is no longer available. However, if you have the various features of the printer defined before starting FarmBooks these feature will be preserved as FarmBooks only overrides the paper source.

Font size increased from 8 to 10 point
The font size was increased in the main application tabs and detail check/deposit windows along with the paycheck detail window.

2015 Tax Table Rates Included with Release
If you have not downloaded the tax rates for 2015, you will not be required to download it. However, it will be necessary to apply the tax table to your database by selecting option "Have Already Installed from CD or Previous Download".

ATI - ATIG/D Codes

New ATIG/D Code 0583 FUNGICDE added to ATI section 058 HERBICIDE-INSECTICID if no user defined code found for 0583.

Batch Entry Updates

  • Validation was not requiring "Unit Entry" when the ATIG/D was set to require unit entry.
  • Payroll Entry with multiple wage lines would overstate total gross wages when posting a payroll transaction. If the paycheck was manually edited and saved after batch entry posting, it would correct the gross wages. This would only be an issue for individuals using multiple wage lines and recording paychecks from batch entry. Paychecks with single wage line in batch entry did NOT have an issue. Paycheck entry did not have an issue.

Check / Deposit Vendor with Memorized ATIGD List containing External Codes

Using a vendor with a memorized list would result in error "ATIGx ???? is undefined" when the list contained external codes. "External code entry is not allowed" displayed when entering an external code. This error would prevent users from saving the transaction. Also, the initial record position was on the last record instead of the first record in the grid after populating the grid.

Invoice Updates

Invoice Preferences
New font control fields (name, size, and style) to allow control over the remitter fields displayed on the invoicing forms (estimate, invoice, credit memo, finance charge invoice, and statements).

New Fiscal Year Updates

Allow the new fiscal year process to be re-run if no transaction data has been entered for the fiscal year. If you discover that your loan inventory data was incorrect during the roll-over (copy ending values and setting them as beginning values for inventory, loans and bank balances), you can correct the data and then re-run the process to re-create beginning values for the new year.

Paycheck Entry

  • The employee name is no longer used for the wage lines of 0411x. Instead, the payroll default description is used. This will allow for the labor description on multiply wage lines to be reflected on reports.
  • Show the employee's FICA exempt status defined in employee setup to be displayed at the top of the paycheck detail window. This value is for display purposes only and cannot be changed.

Payroll Updates

Multiple Wage Lines for a Paycheck
If you enter multiple earnings/wages lines on a paycheck and assigned a different enterprise to each one and had dollars amounts listed on each wage line, the net pay is assigned to the first wage line and there is nothing listed on the other wage lines. Thus, it puts the entire net amount to only one enterprise. Now, the net pay is allocated to each wage line based on a ratio per line of gross pay to the paycheck’s total gross pay. This change has an impact on the enterprise and transaction journal reports. Also, the register will display the net wage per wage line.

New Payroll Report and Updated Report
See the report update section for more details.

Print Checks with Square Bracket Text in Vendor Name

If the vendor name had square bracket text embedded within the name, the last character of the vendor name was not printed on the check. This has been corrected. If the square bracket text appeared at the end of vendor name, it would print correctly.

Register Updates

Transfer Funds between Accounts

  • When you use the calculator to put in the dollar amount in the TRANSFER window and click the Transfer button, you receive an Error message that states "amount cannot be zero". It wipes out the amount you’ve put in using the calculator and puts in zeroes when you click the Transfer button. Now, the amount is retained.
  • Tab / Enter key field sequence changed to Date, Amount, From Account, To Account, Memo, and then Transfer button.

Report Updates

New Reports

  • New Payroll Report - Workers' Compensation Audit Report
    A review of the compensation paid during the policy term to determine whether the exposure used to determine the original premium was accurate. Payroll is tracked by calendar year, but your workers' compensation policy may begin and end on non-calendar dates. This report allows you to specify a time period that is based on your premium year. The report shows summaries of gross pay per earnings line per employee plus any non-tax (Medicare, Social Security, State or Federal Taxes) payroll lines. The user can decide which lines would apply to their premium situation and pull values from the report.

Report Changes

  • Invoice Forms
    The bottom margin size was increased from .166 to .450 as some printers would not support printing that close to the bottom edge of the paper. This would result in the totals line being cut-off.
  • Payroll Pay Stub Report
    Multiple wages/earnings lines set up (basically a regular wages line and an overtime line). The Paystub Report is showing the overtime rate of pay on both the regular wages line and the overtime wage line. Also, YTD HOURS do not adjust accordingly if a paycheck is voided.

    Fixed the rate of pay to show the correct value when multiple wages lines used. Reviewed the voided paycheck and found that we do not show YTD hours only amounts. It will now show 0.00 for the rate of pay and the original hours worked which equal 0.00 for current.

    Changed the YTD calculation to exclude paycheck number as it was determined that this number was not always ascending and increasing in value which would result in the YTD column amounts being incorrect and possibly resetting back to zero or as if it was the first paycheck for the calendar year. Now, only date is used. It should be noted that if an employee receives two paychecks on the same day that the YTD amounts on both paychecks will be the same.
  • Enterprise Analysis
    The subtotal line before the net grain sales with the dotted line was not suppressed for crop type enterprises. It is used for other non-crop type enterprises.
  • Enterprise Transaction Journal / Transaction Journal ATIG Enterprise
    Enterprise assignments for payroll with multiple earnings lines were being displayed in duplicates or several more times (duplicated number of earning lines entered for a paycheck) than actually entered for a paycheck. The report was not including fiscal year as part of the table lookups so information was incorrectly displayed for the report. The data in the database was correctly captured. If only one earning line per paycheck was entered, the report showed the result correctly per transaction.

    If you enter multiple earnings/wages lines on a paycheck and assigned a different enterprise to each one and had dollars amounts listed on each wage line, the net pay is assigned to the first wage line and there is nothing listed on the other wage lines. Thus, it puts the entire net amount to only one enterprise. Now, the net pay is allocated to each wage line based on a ratio per line of gross pay to the paycheck’s total gross pay.
  • Income Statement
    The report was not including all values for ATIG/D codes in the Farm Expenses 100% Deductible category.
  • Transaction Journal
    Price per Unit was not showing up for negative amounts. Report was avoiding divide by zero error by check for unit > 0 instead of units not equal to zero.
  • Schedule F
    • Removed Non-Farm ATIG/D Codes from Line 30 Farm Utilities
    • Leave Line 10 Blank for Farm Car & Truck Expense –Manually determine the value based on your tax situation
    • Remove 0531 from Line 27 as it is correctly placed on Line 18
    • Line 27 had the range from 05336 to 05390 which would result in amounts being doubled on the report for example for ATIGs of 0535, 0536, etc. The range was changed to 05360 to 05390.