BMF - Configurare

1. Conexiune la SQL Server

Verifica datele si apasa "Test conexiune".

Server (IP / hostname)

Port

Baza de date

Utilizator

Parola

2. Interogarea SQL pentru cheltuieli auto

Editeaza SQL-ul de mai jos. Apasa "Detecteaza tabele" pentru sugestii, apoi "Test query".

Interogare SQL (returnata coloanele: date, invoice, supplier, item, item_code, qty, net, gross, fprms, year, company_id, company, plate, vehicle, mg_name)

-- Adaptati numele tabelelor si coloanelor la schema voastra reala.
-- Pentru a vedea structura, rulati: python discover_schema.py
SELECT
    CONVERT(varchar(10), h.DataDoc, 23)        AS [date],       -- yyyy-MM-dd
    h.NrDoc                                    AS [invoice],
    f.Denumire                                 AS [supplier],
    l.Denumire                                 AS [item],
    l.Cod                                      AS [item_code],
    l.Cantitate                                AS [qty],
    l.ValoareNet                               AS [net],
    l.ValoareBrut                              AS [gross],
    h.FPRMS                                    AS [fprms],
    YEAR(h.DataDoc)                            AS [year],
    h.IdFirma                                  AS [company_id],
    fi.NumeFirma                               AS [company],
    v.NrInmatriculare                          AS [plate],
    (v.Marca + ' ' + ISNULL(v.VIN, ''))        AS [vehicle],
    g.Denumire                                 AS [mg_name]
FROM dbo.DocHeader     h
JOIN dbo.DocLine       l   ON l.IdDoc      = h.IdDoc
JOIN dbo.Furnizori     f   ON f.IdFurnizor = h.IdFurnizor
JOIN dbo.Firme         fi  ON fi.IdFirma   = h.IdFirma
LEFT JOIN dbo.Vehicule v   ON v.IdVehicul  = l.IdVehicul
LEFT JOIN dbo.GrupeMarfa g ON g.IdGrupa    = l.IdGrupa
WHERE h.FPRMS IN (2062, 2063)            -- doar facturi cumparari
  AND h.DataDoc >= '2017-01-01'
ORDER BY h.DataDoc DESC, h.NrDoc DESC;

3. Primul cont de administrator

Acest cont va putea apoi adauga alti utilizatori.

Utilizator

Parola (min. 6 caractere)

Confirma parola

4. Salvare si finalizare

Verifica ca pasii anteriori sunt verzi (OK), apoi apasa "Salveaza si activeaza".

BMF GRUP - Configurare initiala

1. Conexiune la SQL Server

2. Interogarea SQL pentru cheltuieli auto

3. Primul cont de administrator

4. Salvare si finalizare