Spectrum / Vista Export File Mapping

Spectrum / Vista Export File Mapping

Fast-Weigh Web Portal

  To add the NetSuite Accounting Integration to your Fast-Weigh subscription, contact us at 865-219-2980 or support@tacinsight.com .

Spectrum Material Management / Vista MS Ticket Import File Layout

  • For Spectrum MM import, file column numbers typically match the line numbers in the import template.
  • Some values will need to be hard coded in the Vista import.
  • Two common hard codings are:
    • Material Sales Company :  (insert company number or code)
    • Batch Transaction Type :  A

1 Ticket #
2 Customer ID
3 Job
4 Product ID
5 Date - quirk: Vista Month Column Ex: MM/01/YYY (3 y's is correct)
6 Time
7 Yard Code / From Location
8 Truck ID
9 Hauler ID
10 Unit Price
11 Net Units
12 Gross Weight
13 Tare Weight
14 Order Number
15 Phase
16 Cost Type
17 Freight Rate (To charge)
18 Freight Amount (To charge)
19 Surcharge Amount
20 Tax Code
21 Tax Total
22 Batch Code
23 PO #
24 Order Description
25 Not Used
26 COD Flag (Y/N)
27 Ticket Total
28 Sale Type (C/J)
29 Not Used
30 Invoice #
31 Hauler Amount (To pay)
32 Not Used
33 Not Used
34 Order UDF1
35 Order UDF2
36 Order UDF3
37 Hauler Type (H/E/N)
38 Haul Basis (If per load, 1. If per unit, net units)
39 Haul Rate (To charge)
40 Deliver To (First Line)
41 Haul Zone Name
42 Ticket Note
43 Material Amount
44 Ticket UDF1
45 Ticket UDF2
46 Ticket UDF3

Fast-Weigh Spectrum Accounting Integration  is an optional feature add-on. To add the Spectrum Accounting Integration to your Fast-Weigh subscription, contact us today at 865-219-2980 or support@tacinsight.com



    • Related Articles

    • Connecting Fast-Weigh to Spectrum Accounting

      Fast-Weigh Web Portal To add the Spectrum Accounting Integration to your Fast-Weigh subscription, contact us at 865-219-2980 or support@tacinsight.com . The primary link between Fast-Weigh and Spectrum accounting is the Spectrum Data Exchange (SDX) ...

    • Ticket Query: Locate, View, & Edit Tickets 🎥

      Fast-Weigh Web Portal ? Using the Ticket Query on the Fast-Weigh Web Portal Click here for more Fast-Weigh training videos. Using the Ticket Query Use the filter parameters at the top of the Ticket Query screen to narrow your search results. A ...

    • Creating Hauler Statements

      Fast-Weigh Web Portal To add the Fast-Weigh Hauler Pay module to your Fast-Weigh subscription, contact us at 865-219-2980 or support@tacinsight.com . The Hauler Pay module allows you to organize groups of tickets into batches for invoicing a Hauler , ...

    • Billing: Batching Tickets & Creating Invoices

      Fast-Weigh Web Portal Fast-Weigh Invoicing is an optional feature add-on. To add Invoicing to your Fast-Weigh subscription, contact us at 865-219-2980 or support@tacinsight.com. Fast-Weigh features a flexible billing system that integrates with ...

    • Ticket Import: Preparing your Import Format

      Fast-Weigh Web Portal Before you can import external tickets into your Fast-Weigh Web Portal, you will first need to set up the format of your import. Setting up your Import: Navigate to Settings > Import Format. Click on [+ New Format] to begin ...