Accounts Receivable Data Exports

 

Export

Purpose

AgCollect EMR

Includes sales to customers of products flagged as “AgCollectable”.

I want to read the white paper (with screen shots) on how to run the AgCollect Export.

Aged Receivables

A breakdown of amounts owed by customers grouped by aging buckets.

AR Invoice Summary

Summary of invoices where the invoice date falls between the given start and end date.

AR Invoice Taxes

Charged taxes on AR Invoices where the invoice date falls between the given start and end date.

Bill And Hold Invoices

List of bill and hold invoices within a given date range.

Chemical Sales Summary
(Alberta Environment)

Customized for the Government of Alberta Department of Environment. Shows sales quantities for product type or group (usually Chemicals) grouped by product and location.

Note 1: The Alberta Government requires one export file per location. Retailers with chemical sales from multiple locations will need to run & submit a file for each location separately (which is why there is no option for <Company>).

Note 2: The date range must include when the inventory moved (for example, on a LOT) which is not necessarily the date it was invoiced.

I want to read the white paper (with lots of screenshots) on the Chemical Sales Summary Export.

Comp. Customer Sales by Qty

Comparative customer sales for two date ranges. The export only shows sales in units with no dollar values. Another column shows the amount available on open committed work orders. The customer sales of the first date range are then compared with the customer sales of the second date range plus the active committed work orders.

CRM Custom Attributes

Lists all customers’ CRM custom attributes. The export creates one row per customer per attribute (so one customer with multiple attributes will have multiple rows).

Customer Balances

All balances for all customers as of a given date (chargeable item details are optional).

Customer List

Masterfile info (names, phone numbers, addresses, price level, home location, sales rep, interest rate, characteristics, etc.) for customers.

Customer Mailing List

Customer names and addresses, designed for the creation of mailing labels.

Customer Marketing Mail List

Customer names and addresses, designed for the creation of mailing labels filtered by sales during a specific date range.

Customer Permits

Lists all permits for customers.

Customer Sales

Tip
Use the Product List data export to identify products flagged as Omit from Sales Reports/Exports.

Customer sales within a given date range.

Reminder: it's not a sale until it's on an invoice.

Customer Sales of Product Sales

Tip
Use the Product List data export to identify products flagged as Omit from Sales Reports/Exports.

items sold 'on sale'

Business rules:

  • Fixed Price only
  • Invoice Date within date range of the Sale selected  
  • Invoice Line Location matches a checked Sale Location

Customer Sales Summary

Tip
Use the Product List data export to identify products flagged as Omit from Sales Reports/Exports.

Summary of customer sales within a given date range. The export can be grouped by Customer, Product, and Product Type.

Reminder: it's not a sale until it's on an invoice.

Customers Without Sales

Customers with no sales in date range.

Loadout Ticket Details

Line details for Loadout Ticket.

Loadout Ticket Summary

Header details for Loadout Tickets.

Low Sales Margins

Calculated margin = [(price – cost) / price * 100]

Inventory items only, returns are ignored. For Blends, products are itemized.

Manufacturer Sales (FMC)

Sales of items tracked by FMC for participating manufacturers.

Manufacturer Sales/Orders (Kenna)

Sales of items tracked by Kenna for participating manufacturers. 

Manufacturer Sales/Orders (TKXS)

Sales of items tracked by TKXS for participating manufacturers.

Member Patronage Summary

Sales summary by product type/group and member. Total Sales column does not include the GST Amount.

PCP Sales

Sales of products with a PCP Number.

Supplier is based on last Inventory Receipt (IR) for the product sold; if no IR displays null.

Quantity sold is the sum of all qty for the Product/Unit Type Combination (different unit types for same product will display on a separate line).

POS Data (TKXS)

POS Sales of items tracked by TKXS

Note This export is not specific to POS Invoices, it just happens to share the same name.

Prepayment Adjustments

List of prepayment adjustments.

A positive export value indicates the prepay balance was adjusted UP (the account had MORE remaining prepay than agrē thought it did.)

A negative export value indicates the prepay balance was adjusted DOWN (the account had LESS prepay than agrē thought it did).

Prepayment Transfers

List of prepayment transfers. Prepayment transfers generate two postings (one for prepay and one for the credits), but only one row per prepayment transfer is shown.

Sales by Member

Used to calculate patronage for co-op members.

Sales With Required Permits

Inventory products on Invoices and Loadout Tickets within a given date range that require a permit. Permits are per product. If a product requires multiple permits, shows a row for each permit.

Unpaid Interest

All interest charges that not paid in full as of the date provided.

Work Order Detail

Product details (blends are automatically itemized) on Work Orders. Meant for submission of "sales-to-be" to AgCollect.

I want to read the white paper (with screen shots) on how to run the AgCollect Export.

Work Order Pricing Summary

Pricing details for Committed products on Active work orders.

Work Order Summary

Header details for Work Orders.

Net Amount does not include taxes
Total Amount = Net Amount + Tax Amount
Amount Due
= Total Amount – (all prepayments linked to the work order) 
   (cannot be negative)
Paid Fully: If WO ‘Paid in Full’ is checked, then Amount Due will display as $0.00
Note: Prepayment Deposit amount is always fully applied to a work order. This can result in incorrect Amount Due if a partial Prepayment Deposit is linked to multiple Work Orders.