BAYER BAER

PowerMax admin

Enter your admin password.

Incorrect password or not an admin.

BAYER BAER
PowerMaxAdmin
Operator view

Inventory settings

Carryover balance, density factor, product label.

admin

Inventory settings

These values drive the running-inventory math across the entire app.

Bayer FSC rates

Rate per mile by effective date. The rate on a load's tender date back-calculates actual miles; the rate on the delivery date computes the corrected fuel surcharge. Auto-syncs daily at 6 AM ET from the Bayer FSC tab; use Sync now if you need it sooner.

Effective date Fuel price FSC rate (per mile) Source

Accessorial charge types

These options populate the Type dropdown when adding an accessorial charge in the AR → Trucking section.

Houff trucks

Trucks that run tendered (regular Trucking) loads. Populates the Truck # dropdown on the Trucking add-load form. Tolls whose unit matches one of these auto-route to a Trucking shipment.

Pre-selected in Truck # when adding a Trucking load.

LB trucks

Trucks that run LB Trucking loads. Populates the Truck # dropdown on the LB Trucking add-load form. Tolls whose unit matches one of these auto-route to an LB Trucking shipment.

Pre-selected in Truck # when adding an LB Trucking load.

Import historical data

Download an Excel template, fill it in, then upload it. A snapshot of existing data is taken first (saved as *.before-import.<timestamp>.json in backend/data/) so you can roll back if anything looks off.

Railcars + loads

Two-sheet workbook: Railcars (one row per railcar) and Loads (one row per truck load, linked back to a railcar by Railcar #). Optional Adjustments sheet for inventory shrink rows.


        


        

          
Trucking

          
Single-sheet workbook with one row per tendered load. Calculated fields (actual miles, fuel charge, invoice amount) are derived on the server from the FSC table after import.

          

            
            
            
          

          

        

      


      
      

        

          
Google Sheets backup

          
Every change appends one row to the configured Sheet. Sheet is the audit log; the JSON SimpleDB on disk is the source of truth.

          
    
            
  1. Reuse the Bentonite/Perlite service account (or create a new one in Google Cloud Console > Service Accounts).
    2. 
            
  2. Share your destination Sheet with the service account email (Editor access).
    3. 
            
  3. Set GOOGLE_SA_KEY_PATH and GOOGLE_SHEET_ID in /etc/roundup/env.
    4. 
            
  4. Optional: GOOGLE_SHEET_RANGE (default Activity!A1).
    5. 
            
  5. Restart: sudo systemctl restart roundup.
    6. 
          

          
          

        


        

          
Weekly inventory email

          
Sends automatically every Monday at 07:00 ET to the configured recipient. Reports inventory in gallons as of end-of-day Sunday plus the list of railcars currently in Received status. Requires EMAIL_WEBHOOK_URL.

          

            
            
          

          

        


        

          
Backfill report tabs

          
Appends every Released railcar's loads to the Railcar Loads tab and every trucking load to the Trucking Loads tab. One-shot operation — use it once after creating the tabs to populate historical data.

          
Heads-up: append-only. Running this when the tabs already have data will create duplicates. If you've already triggered a release or saved a trucking load since enabling the feature, clear those tabs in Google Sheets first (keep the header row).

          
          

        

      


      
      

        

          
Data integrity

          
Warnings or quarantines from the last server start. If a JSON file was torn or missing, the server rolls forward from a snapshot and shows the result here.

          
          

        

      


      
      

        

          
Full data dump

          
Complete JSON snapshot of railcars, loads, adjustments, trucking loads, accessorials, FSC rates, cities, and settings.

          Download JSON
        


        

          
Workbook exports

          
Operator-friendly Excel files. Each opens cleanly in Excel/Numbers/Google Sheets.

          

            
            
            
            
          

          

            Railcars + loads (all) — every railcar with its opened date; every load.

            Railcars + loads (last 7 days) — railcars opened in the last 7 days (excludes Received) and loads with a gross weight shipped in the last 7 days.

            Aging report — BILLED-but-unpaid trucking freight only (no accessorials).