7.0.25640 | 05.28.2024 General Release

  • FTM-3501 / Attributes – Values can now be set on the Attributes listed below. By setting the Value on an Attribute, it will be required to pick from a specific Attribute value already in the drop-down. The following paths have this new feature enabled:
    • Customer Attributes on the Customer tab at Hub / Setup / Company Preferences
    • Product Attributes on the Product tab at Hub / Setup / Company Preferences
    • Lot Attributes on the Product tab at Hub / Setup / Company Preferences
    • Attributes on the Farm tab at Hub / Setup / Company Preferences
    • Field Attributes on the Field tab at Hub / Setup / Company Preferences
    • GL Account Attributes on the G/L tab at Accounting / Setup / Preferences
    • Vendor Attributes on the A/P tab at Accounting / Setup / Preferences
    • Employee Attributes on the Payroll tab at Accounting / Setup / Preferences
    • Tank Attributes at Energy / Setup / Preferences
  • FTM-3731 / Region and Sub-Region – The Current Region and Sub-Region options automatically default to checked where available.
  • FTM-3557 / 1099 Interest Information – Two new fields were added to the Grower table (Interest for Patronage and Interest for Grain) for Analytics. At the close of December fiscal month for Grain, only the INT 1099 marked as Interest was moved to this field. These totals will be moved during this process. Values can also be modified at Hub / Utilities / Admin Utilities / Accounting / Edit Customer Balances.
  • FTM-3603 / ACH Email – Vendors can now have multiple ACH email addresses. When bills are paid for these ACH vendors, all of the Vendor's email addresses will be added to the To list of the email and sent the same information as what was sent in the past.
  • FTM-3508 / Product Selection – When selecting Products with the multi-select Product window, Departments with only inactive Products will be suppressed unless the filter to Show Inactive Products is chosen.
  • FTM-3741 / Show Ingredients Information – The Products, quantities, and costs (all levels) for the raw ingredients are saved to the INVLI record where Manufactured Formulas exist for the Product in all modes of saving the Invoice.

Inventory

  • FTM-3657 / Import Sales Order into Delivery Ticket – When Sales Orders are imported into Delivery Tickets at Accounting / Inventory / Delivery Tickets, a new filter is available to indicate which Status to import. By default, this will be Approved but can be filtered for other statuses.
  • FTM-3118 / Product Substitution Utility – The Grower Order Product Substitution utility at Inventory / Manage Seed Orders now has a way to review the Bookings when making a substitution. Upon reviewing each Booking, the Booking can be changed similar to editing a single Grower Order and saving.
  • FTM-3763 / Product Request Status Changes – A new control has been added to the Product Request form at Accounting / Inventory / Product Requests that gives the ability to those with the appropriate permissions to change the status of any row for which they have the lock to any status that can exist in the database.

A/R

  • FTM-3311 / Grain ACH Files NACHA – Based on the setting on the Customer profile (File / Open / Customer on the Grain Information tab) Grain ACH files created at A/R / Process Grain ACH will identify growers as consumer or corporate accounts. This is for standard banks, not Canadian. The ACH Type has also been added to the report generated.
  • FTM-3596 / Business Influence Bookings – When a split Invoice is created for multiple Customers who are on the same Business Influence Booking, the quantity available on the Booking is updated as expected.

G/L

  • FTM-3580 / Bank Deposit ScreenUser ID and User Name columns are now included at G/L / Bank Deposit.

Setup

  • FTM-3433 / New Location Preference – A new option (Stop Voids that will result in Negative Amount On Hand of Inventoried Products) for voids of transactions to stop the inventory from going negative for A/R Invoices and Purchase Receipts is available at Accounting / Setup / Location Preferences.
  • FTM-3792 / Federal Tax Tables Import – The Import Fed, FICA, Medicare Info from Web button at Setup / Payroll / Payroll Tax Tables has been removed.

Transfers

  • FTM-3256, 3642 / PMR Export – A new PMR option is available at Accounting / Transfers / Export / PMR. This export will send information by use of an API - not an FTP site. Additional information regarding this export can be found here.
  • FTM-3695 / PMR Export Ship To – In the new PMR export at Accounting / Transfers / Export the PartnerIdentifier Agency attribute in the Ship To section has been corrected to AssignedByBuyer.
  • FTM-3755 / PMR Export – When the new PMR export is turned on at Accounting / Transfers / Export / PMR, the existing export at Accounting / Transfers / Export / Agrimine will be disabled.
  • FTM-3756 / PMR Export Invoice Limit – The number of Invoices included in a single upload to the web service is now limited to 100.
  • FTM-3746 / PMR Export Filtering – The PMR Export at Transfers / Export / PMR now has the capability to filter by Product Classifications or Department Categories.
  • FTM-3775 / Agrimine & United Suppliers Export – The EDI Sales export for Agrimine and United Suppliers has been removed from all existing batch jobs from AgvAgent and can no longer be selected as sources for new batches when the new PMR export has been database-activated. The existing batch job for AgvAgent will be removed upon using the new PMR export.
  • FTM-3759 / Multiple Salesperson Gilbarco Passport Invoices Import – The Gilbarco Passport Invoices import at Accounting / Transfers / Import will now honor the multi-department default Salesperson setup when importing these Invoices into Agvance. It will now use the Grower if one exists and the department-level Salespeople for the Invoice by the first Product. This does not use Ship To information as that does not exist on the Invoices created. The Default Salesperson uses hierarchy option must be checked to use the multiple Salesperson rules.

Accounting Reports

  • FTM-3429 / Sales Analysis Manufactured Ingredients – A new option to expose the manufactured ingredients is available on the Sales Analysis report at A/R / Sales by selecting the Show Ingredients option. With this selected, a new sub report is displayed with the same options as the existing Gross Margin calculations but at the raw ingredient level.
  • FTM-3785 / TX Fertilizer Tag Include Slow Release – The % Slow Release for Nitrogen and its Slow Release Derived From Product List values from the Product setup will now print below the Derived Statement on the TX State Fertilizer Tag.
  • FTM-3672 / Canada Fertilizer Tag – On the Canadian Fertilizer Tags, the N, P, and K will now print the word Minimum at the start of these three major nutrients. Additionally, 0% values will no longer print in the Detail section. Two documents will now print for states that are Canadian states - an English and a French version.

Setup

  • FTM-3312 / Texas State Fertilizer Tag – A new print preference was added on the Print Prefs tab at Blending / Setup / Location Preferences under the Fertilizer Tag Heading drop-downs titled Manufactured for and Guaranteed By. Additionally, a second Location setup was added that allows for a Location address to be different for the Distributed By Locations. When both of these are populated, the Locations will print side by side for the TX tag.
  • FTM-3682 / Current Region and Sub-Region – The Select a Field and Select a Blend Ticket windows now have the ability to filter with the Current Region & Sub-Region checkbox when loading the Customer list.
    Note: This is only available if the setup at Hub / Setup / Recent Customers by Region has been saved.

Setup

  • FTM-3607 / Tank RRN Attribute – When the new Use Energy Force Tank RRN Attribute when posting API Tank Readings option is enabled at Energy / Setup / Preferences, the API will use the TankNumber property to search the Tank RRN # Attribute specified in the Setup Energy Force window to determine the Tank to update. When this option is NOT enabled (the default), the property will continue to search the Tank serial number in the Agvance database.

Transfers

  • FTM-3683 / Energy Force Void Journal – The Post Import report from Energy Force at Transfers / Import / Energy Force / Daily Clear will now include the void information in its totals.
  • FTM-3571 / Purchase Contract Signed – The ability to see if a Purchase Contract is signed has been added to the Purchase Contracts tab when viewing a Customer at File / Open / Customer Account Details.

Operations

  • FTM-3561 / Purchase Contract Amendments Tab – The rounding of Futures, Basis, and Cash Prices will now allow up to five decimal places. When entering a Rate on the Amendments tab of a Purchase Contract, if adjusting the Basis or Futures Price and the fee is applied to Futures or Basis, five decimals can be entered. If not, this will be four decimal places.
  • FTM-3631 / Message When Deleting Purchase Contract – When attempting to delete a Purchase Contract that was used as the source of an Advance, the deletion will be stopped and a message displayed indicating why the Purchase Contract cannot be deleted.
  • FTM-3330 / Settlement Date – When reversing a Settlement at Grain / Operations / Settlements, the date can be changed and will be saved. This feature will default to today's date but can be changed.
    Note: This is available when selecting Reverse and Rev/Start.
  • FTM-3631 / Deleting a Purchase Contract – When attempting to delete a Purchase Contract that was used as the source of an Advance, the process will be stopped and a message will display explaining why it cannot be deleted.
  • FTM-3691 / MOT on Sales Contract Migration – When migrating a Sales Contract at Grain / Operations / Sales Contracts, an option is now available to select a new MOT for the new contract. The default will be what is currently on the existing Sales Contract. The option to require this MOT will also be honored during the migration.
  • FTM-3788 / Basis & Futures Month Settlement Source Records – New inputs are now available on the Settlement Source grid to enter the Futures Month and Basis Price. These are required when the source is an IL PL Contract and settling to Priced, Deferred Payment, Installment Sale, Priced Not Paid, or Basis Fixed. Sources are a Settlement Contract that was Priced Later from a Location that is PL PL/BF or a Scale Ticket/Assembly tied to a Purchase Contract that is Priced Later and had the Contract format indicating IL PL/BF Contracts.

Grain Reports

  • FTM-3264 / Grain Reports Sorting – The Grain Balance Detail report found at Grain / Grain Reports / Customer Analysis and by selecting Print on the Grain Balances tab at File / Open / Customer Account Details will now sort the Purchase Contract and Obligation sections by Primary and Secondary Sorts and will include totals.
  • FTM-3742 / IL Priced Later Contract Signature Method – A new report is available at Grain / Grain Reports / Purchase Contracts when a Location in the database is an IL PL/BF Location. The IL Priced Later Contract Signature Method report summarizes the Contract Signed status of IL PL/BF Contracts from either Purchase or Settlement Contracts. It reports whether or not they were signed and how they were signed.

Setup

  •  FTM-3784 / Ohio Compliance Scale Ticket – The Grain Scale Interface FP 2 Up - Gross will now honor the Price Later Alternate Name option at Grain / Setup / Preferences on the General tab.
  • FTM-3614 / AgLogic Authentication Methods – The authentication methods used to integrate to AgLogic have been updated to support the OAuth 2.0 required by John Deere. This will require logging into the account from the Setup window in the Hub.  If attempting to save a Blend Ticket with Custom Applied or Loaded fields selected based on the setup and the new credentials cannot be validated, a message will display indicating the credentials need updated by navigating to the setup or continue without updating AgLogic. Once the new credentials are entered, there will be no difference how the application functions.
  • FTM-3034 / Crop Zones – Those using a version of SKY Mapping will now have the ability to import the Crop, Crop Chemistry, Acres, and Application Boundary from SKY Mapping for Fields linked to that database. If the Field is not linked, it will continue to use the Agvance Mapping selection of Crop Zones.

Reports

  • FTM-3412 / Grower Summary Report – The Grower Summary report at Planning / Reports will now honor the ZN Blended Analysis when the Show Blended Analysis Recap option is checked. 
  • FTM-3593 / Crop Planning Report – A new Crop Planning Report option is available on the Grower Summary report at Planning / Reports / Grower Summary. When selected, new options are enabled giving the ability to Print Selected Summaries Only that are by Plan, Crop, Product, or Manufacturer. This report also uses the logo set up on the Logo tab at Accounting / Setup / Location Preferences.
  • FTM-3637 / Android Devices – The carrot to allow navigation to the next screen showing the Requested Quantity and Lot information is now available on the Outbound window for Android devices.