Export Grain Bank balances and Bookings from Agvance to import into the Feed Mill system.
- Export Grain Bank Balances – Transfers / Export / Enhanced FMM / Grain Bank
- Export Bookings – Transfers / Export / Enhanced FMM / Bookings
Bookings Export
This exports a Contract file consisting of Bookings that can be used with the Feed Mill Manager. Agvance Bookings are exported to FMM contracts.
Information regarding the data mapping for this export can be found here.
All bookli lines with a Product part of the selected Product Classification will be exported. Each time the export is run, all Booking lines will be exported whether or not they have been invoiced.
Note: Each Product that is on a Booking not marked as Deleted or Voided and is in the Classification on the export is exported.
The quantity populated into the file will be the units on the Booking line divided by the Attribute value. If no Attribute value is set, it is assumed to be 1. The remaining quantity populated into the file will be the Quant Left units on the Booking line divided by the Attribute value.
The price in the file will be the Booking Price * Attribute value. If no Attribute value is set, it is assumed to be .
Product Conversion Attribute and Qty in Base Attributes are not required. When left blank, a value of 1 is assigned.
On the Export window, there is setup for the following items:
- Export Path – Ensure this path is accessible by both Agvance and FMM as it will be where the export file resides after being created by Agvance.
- Export File Name – This can be anything acceptable by the FMM system.
- Customer ID Cross Reference – This can be any of the Cross Reference fields from the Customer Profile or it can be Agvance ID. Whichever is chosen should be coordinated with the Grain Bank export and Delivery Ticket import.
- Product ID Cross Reference – Choose any of the Cross Reference fields from the Product Profile or choose Agvance ID. Whichever is chosen should be coordinated with the Delivery Ticket and the Purchase Receipt imports.
- Product Export Class – This is the Product Classification that must be on the Product for it to be eligible to be in the Booking Export file. Only Bookings for the relevant feed Products will be included in the export to FMM.
- Product Conversion Attribute – This is the Attribute that will hold the conversion factor between Agvance UOM and FMM UOM. If the UOM in FMM matches Agvance in a 1:1 ratio, then this Attribute can be left blank.
- Qty in Base Attribute – This is a Product Attribute set up in Agvance. The qtyInBase Attribute in an Agvance FMM export represents the quantity of the Product expressed in its base unit of measure regardless of how it was originally entered or displayed on the transaction.
Grain Bank Export
Grain Bank balances are exported out of Agvance to FMM. Information regarding the data mapping for this export can be found here.
Grain Bank quantities being exported will be calculated the same way they are at invoicing and exported as a sum total from all Locations by Commodity for the Customer. The Customer inserted in the file will be the Agvance ID or the selected Customer Cross Reference. No Grain Bank pooling amount will be included. The FMM program will handle the pooling on their side.
The Grain Bank file will have a location on each record equal to the FMM-Agvance Location Cross Reference on the currently logged into Location of the custom program.
Grain Bank balances will always be expressed in Lbs in the file.
The Commodity ID notated in the export file will be the Agvance Commodity ID or the selected Commodity Cross Reference for the Commodity being exported.
Export file is in FMS version: GrainBankInterface = 1 (FMM Dex.ini setting)
The following are included in the export:
- Customers with an open balance on one or more of the following:
- Grain Scale Ticket with Disposition of Grain Bank, Settlement Destination with To DPR of Grain Bank, and the total of these two do not offset by the total of open Grain Bank Shipments
- Any Customer with a NON-zero balance (Scale Ticket + Settlement - Grain Bank Shipment) grouped by Commodity will write a record for the currently logged in Location.
The Grain Bank Export window has the following fields:
- Export Path – The path here should be accessible by both Agvance and FMM as it will be where the export file resides after being created in Agvance.
- Export File Name – This can be anything acceptable by the FMM system.
Select Setup to display the Grain Bank Setup window.
- Customer Cross Ref. – Choose any of the four Cross Reference fields from the Customer Profile or select Agvance ID. Whichever is chosen should be coordinated with the Booking export and Delivery Ticket import.
- Commodity Cross Ref. – Select any of the four Cross Reference fields on the Commodity or choose Agvance ID.
- Agvance Location/FMM Location Grid – The grid allows each Location in Agvance to be cross-referenced to the location identifier in FMM. This identifier will be laid down in the export file based on the default Location logged into when performing the export. It will not be the Location where the Grain Bank is actually assigned in Agvance.
