Articles
Analytics Data Source Release Notes | 11.25.2024 New
AN-3228 / LP Tank Customer Credit Status – The Credit Status field from the Customer in Agvance (CustAr.credstatus) has been added to the LP Tank data source.
Analytics Data Source Release Notes | 11.13.2024
AN-3201 / Grain Scale Activity Enhancements – Scale Ticket Grade Factors have been added tot he Scale Interface Tickets with First Split data source.
Analytics Data Source Release Notes | 10.16.2024
AN-3174 / Field Classification Data Source – A data source now exists that contains Field Classification information including Customer ID , Field ID , and Classification Name .
Analytics Data Source Release Notes | 10.10.2024
AN-3075 / Energy Force Agvance Reconciliation –A new data source that contains Agvance Invoices created by the Energy Force Daily Clear Import along with ticket information from the Energy Force database now exists. ...
Analytics Data Source Release Notes | 10.07.2024
AN-3146 / Vehicle Expense – The AP Bill data source now includes the Vehicle Description for the Vehicle on the AP Bill line item (agvehicle.description).
Analytics Data Source Release Notes | 10.04.2024
AN-3144 / Product Cost Audit – A new ProdCostAudit data source has been made that extracts data from the ProdCostAudit table in Agvance.
Analytics Data Source Release Notes | 09.16.2024
AN-3145 / Blend Tickets Data Source – The Product Set on the Blend Ticket (fldblend.prodsetid) has been added to the Blend Tickets data source.
Analytics Data Source Release Notes | 09.12.2024
AN-3130 / List Price Filter Option – List Price (prodprce.list) has been added to the Product Price Levels data source.
Analytics Data Source Release Notes | 09.04.2024
AN-3131 / UACData – The Invoice Number , Invoice Location , and Invoice Date fields have been added to the data source for including the Invoices that were paid by specific payments.
Analytics Data Source Release Notes | 08.23.2024
AN-3108 / Plan Usage – The Salesperson ID (plan.salesmanid) and Acres (fldplan.acres) fields have been added to the Plans Used data source.
Analytics Data Source Release Notes | 08.20.2024
AN-3094 / GL Bank Deposit Analysis – A new data source named GL Bank Deposits has been created. The data source includes data from the Deposits and DepositsDT table in Agvance. The data includes bank deposit detail. ...
Analytics Data Source Release Notes | 08.19.2024
AN-3101 / Sales by State Dashboard – The Quantity and Inventory UOM from the Invoice have been added to the Sales by County data source.
Analytics Data Source Release Notes | 07.31.2024
AN-2662 / 1099 Interest Grain and Patronage – A new Customer data source has been created that contains general Customer information from the Grower table in the Agvance database along with 1099 interest for Grain and Patronage. ...
Analytics Data Source Release Notes | 07.26.2024
AN-3081 / Show Ship From Location –The Ship From Location in the Blend Tickets data source is now coming from the blndli table instead of the fldblend table in Agvance since the Ship From Location in the fldblend table does not get populated. ...
Analytics Data Source Release Notes | 07.24.2024
AN-3073 / Scale Interface Farm Description – The Farm Description for the Farm on the Grain Scale Ticket has been added to the Grain Scale Interface Tickets data source.
Analytics Data Source Release Notes | 07.23.2024
AN-3071 / Online Payments Scheduled Dashboard Filter – The calculation for the posted date in the Online Scheduled Payments data source was corrected to use the posted date from the online payment instead of the created date. ...
Analytics Data Source Release Notes | 07.16.2024
AN-3063 / Planned Booking Payment Method – The Booking Payment Method (bookpaymethod.bookpaymethoddescription joined to booksplit on bookpaymethodguid) has been added to both the Product Bookings and Bookings data sources. AN-3066 / Credit Stat...