TMS - Integracion con Sage 50

Lo que conecta

Los costes operativos del TMS se integran con Sage 50 para contabilizar gastos de flota (combustible, peajes, mantenimiento).

Datos que fluyen

• Km recorridos -> Centro de coste en Sage
• Peajes -> Gastos deducibles
• Horas conductor -> Coste laboral

Exportacion a Sage 50

import csv, requests
from datetime import date

TMS_TOKEN=*** = []

# Rutas del dia
rutas = requests.get(
    "https://back.transcend.cargoffer.com/api/route/history?dateFrom=2026-06-17&dateTo=2026-06-17",
    headers={"Authorization": f"Bearer {TMS_TOKEN}"}
).json()

with open("gastos_flota_sage.csv", "w", newline="") as f:
    writer = csv.writer(f, delimiter=";")
    writer.writerow(["Fecha", "Cuenta", "Importe", "Concepto", "CentroCoste"])
    
    for ruta in rutas:
        writer.writerow([date.today(), "62500001", ruta["fuelCost"], "Gasolina", "FLOTA01"])
        writer.writerow([date.today(), "62900001", ruta["tollCost"], "Peajes", "FLOTA01"])