document6

Upload: ciurila-ovidiu

Post on 09-Mar-2016

216 views

Category:

Documents


0 download

DESCRIPTION

Tema 6 TAO

TRANSCRIPT

  • CENTRALIZATORFACTURI

    CodClient NumeClient Localitate Adresa Nrfactura Datafacturii Valoare Platit

    100 Client1 Constanta Str.Florilor 456 2/12/2014 30zile 38,060,000 NU101 Client2 Bucuresti Str.Averescu 888 1/9/2014 30zile 21,000,000 DA102 Client3 Brasov Str.1Mai 343 8/14/2013 15zile 7,000,000 NU100 Client1 Constanta Str.Florilor 87 11/24/2014 20zile 5,200,000 DA103 Client4 Cluj Str.Iancului 566 3/15/2004 0zile 9,500,000 NU102 Client3 Brasov Str.1Mai 70 10/15/2015 15zile 4,000,000 NU100 Client1 Constanta Str.Florilor 244 9/25/2015 20zile 3,600,000 DA103 Client4 Cluj Str.Iancului 670 1/17/2004 0zile 12,500,000 DA101 Client2 Bucuresti Str.Averescu 122 4/12/2011 30zile 6,760,000 NU100 Client1 Constanta Str.Florilor 406 12/16/2014 30zile 2,300,000 NU100 Client1 Constanta Str.Florilor 111 7/3/2014 30zile 10,000,000 DA

    Interogriprinfiltruautomat

    SseafisezelistaclientilordinConstanta Localitate

    SseafisezelistaclientilordinBucurestisidinBrasov ConstantaSseafisezelistaclientilordinBucuresticarenuaupltitfacturileSseafisezefacturilenencasateacrorvaloaredepestecuantumulde6mil.SseafisezefacturileemisencursulanuluitrecutSseafisezefacturileacarorvaloareestecuprinsntre10mil.si20mil.

    Localitate

    BucurestiInterogariprinfiltruavansat Brasov

    Saseafisezelistaclientilorcareaumajorarideintarzierecuprinseintre20%si80%dinvaloareSaseafisezelistaclientilorcucaresocietateaaincheiatcontracteinlunacurenta

    Nrzilegratie

    Datascadentei

  • Saseafisezelistafacturiloremiseinultimele6luni,pentrucareclientulabeneficiatdeuntermendegratie

    Saseafisezelistafacturilorneplatitelacarenrziledeintarzieredepasestemediaacestora Localitate Platit

    Catefacturisauamisinzileledeweekend Bucuresti NUCareestefacturalacaresauaplicatcelemaimaripenalitatidatoritanerespectariiconditiilorcontractuale

    CareesteanulincaresauemiscelemaimultefacturiCareesteziuaincaresauincheiatcelemaimultefacturiinlunacurenta?Saseafisezelistafacturilorneplatitepentrucaresadepasitscadentacumaimultdeunandezile

    Functii(inlocultestuluifinal)

    1.Sasecalculezedatascadenteiexcluzandweekendurilesisarbatorilelegale2.Rubricaplatitvacontineolistaderulanta,curaspDA/NU,carevafidisponibilapentruuncodclientnumericsinonvid3.Dataplatiivafivalidataastfel:laplatitavemvaloareaDAsisafiemaimicasauegalacudatacurentasimaimaresauegalacudatafacturii4.Sasecalculezemajorariledeintarziere5.Saseinserezeonouacoloanainbazadedateundesevorcalculamajorariledeintarziereprintrofunctiedefinitadeutilizator

  • CENTRALIZATORFACTURI1/29/2016

    Majorari TVA nrzileint

    #VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!

    CodClient NumeClient Localitate Adresa Nrfactura Datafacturii Valoare Platit

    100 Client1 Constanta Str.Florilor 456 2/12/2014 30zile 38,060,000 NU100 Client1 Constanta Str.Florilor 87 11/24/2014 20zile 5,200,000 DA100 Client1 Constanta Str.Florilor 244 9/25/2015 20zile 3,600,000 DA100 Client1 Constanta Str.Florilor 406 12/16/2014 30zile 2,300,000 NU100 Client1 Constanta Str.Florilor 111 7/3/2014 30zile 10,000,000 DA

    CodClient NumeClient Localitate Adresa Nrfactura Datafacturii Valoare Platit

    101 Client2 Bucuresti Str.Averescu 888 1/9/2014 30zile 21,000,000 DA102 Client3 Brasov Str.1Mai 343 8/14/2013 15zile 7,000,000 NU102 Client3 Brasov Str.1Mai 70 10/15/2015 15zile 4,000,000 NU101 Client2 Bucuresti Str.Averescu 122 4/12/2011 30zile 6,760,000 NU

    Sumadatorata

    Nrzilegratie

    Datascadentei

    Nrzilegratie

    Datascadentei

  • CodClient NumeClient Localitate Adresa Nrfactura Datafacturii Valoare Platit

    101 Client2 Bucuresti Str.Averescu 122 4/12/2011 30zile 6,760,000 NU

    Platit CodClient NumeClient Localitate Adresa Nrfactura

    NU 1 100 Client1 Constanta Str.Florilor 456 2/12/2014 30zile102 Client3 Brasov Str.1Mai 343 8/14/2013 15zile103 Client4 Cluj Str.Iancului 566 3/15/2004 0zile101 Client2 Bucuresti Str.Averescu 122 4/12/2011 30zile

    CodClient Localitate Adresa Nrfactura Valoare

    12/30/1899 100 Client1 Constanta Str.Florilor 456 2/12/2014 30zile 38,060,000101 Client2 Bucuresti Str.Averescu 888 1/9/2014 30zile 21,000,000100 Client1 Constanta Str.Florilor 87 11/24/2014 20zile 5,200,000100 Client1 Constanta Str.Florilor 406 12/16/2014 30zile 2,300,000100 Client1 Constanta Str.Florilor 111 7/3/2014 30zile 10,000,000

    CodClient Localitate Adresa Nrfactura Valoare

    0 103 Client4 Cluj Str.Iancului 670 1/17/2004 0zile 12,500,000100 Client1 Constanta Str.Florilor 111 7/3/2014 30zile 10,000,000

    Nrzilegratie

    Datascadentei

    Datafacturii

    Nrzilegratie

    Datascadentei

    NumeClient

    Datafacturii

    Nrzilegratie

    Datascadentei

    NumeClient

    Datafacturii

    Nrzilegratie

    Datascadentei

  • Majorari

    3,425,40000

    207,0000

    Majorari

    0315,000180,000608,400

  • Majorari

    608,400

    Valoare Platit Majorari

    38,060,000 NU 3,425,4007,000,000 NU 315,0009,500,000 NU 06,760,000 NU 608,400

    Platit Majorari

    NU 3,425,400DA 0DA 0NU 207,000DA 0

    Platit Majorari

    DA 0DA 0

  • Centralizatorulfacturiloremise

    Localitate Adresa Nrfactura

    100 Client1 Constanta Str.Florilor 456 9/12/2015101 Client2 Bucuresti Str.Averescu 888 10/15/2015102 Client3 Brasov Str.1Mai 343 8/14/1999100 Client1 Constanta Str.Florilor 87 11/24/1999103 Client4 Cluj Str.Iancului 566 3/15/2014102 Client3 Brasov Str.1Mai 70 10/15/1999100 Client1 Constanta Str.Florilor 244 9/25/1999103 Client4 Cluj Str.Iancului 670 1/17/2000101 Client2 Bucuresti Str.Averescu 122 4/12/2000100 Client1 Constanta Str.Florilor 406 12/16/1999100 Client1 Constanta Str.Florilor 111 7/3/1999

    FORMULA REZULTATUL CRITERIISumavaloricafacturilorncasatedelaclientiidinConstanta LocalitateConstanta

    MaximulvaloricalfacturilornencasatedinBrasov LocalitateBrasov

    Minimulvaloricalfacturiloremisede"Client1"Client1

    Mediafacturiloremisesinencasate PlatitNU

    NumrulfacturiloremisenClujsiBrasov

    Careestevaloareafacturiinumrul888 Nrfactura888

    Careestesumadatorataaferentafacturilorncasate Platitpeultimele4luni DA

    Mediavaloricafacturilornepltitedeclientiidin PlatitBucurestinanulcurent NU

    Cateziledegratiesauacordatpentrufacturanumarul244? Nrfactura244

    CodClient

    NumeClient

    Datafacturii

    NumeClient

  • Centralizatorulfacturiloremise

    Valoare Platit Majorari TVA

    30zile 10/23/2015 38,060,000 NU 16,974,760 10,456,60430zile 11/26/2015 21,000,000 NU 5,460,000 5,027,40015zile 9/3/1999 7,000,000 NU 413,980,000 79,986,20020zile 12/22/1999 5,200,000 DA 0 988,0000zile 3/15/2014 9,500,000 NU 57,665,000 12,761,350

    15zile 11/5/1999 4,000,000 NU 234,040,000 45,227,60020zile 10/22/1999 3,600,000 DA 0 684,0000zile 1/17/2000 12,500,000 DA 0 2,375,000

    30zile 5/24/2000 6,760,000 NU 381,940,000 73,853,00030zile 1/27/2000 2,300,000 NU 132,664,000 25,643,16030zile 8/13/1999 10,000,000 DA 0 1,900,000

    CRITERII

    Platit 18800000DA

    Platit 7000000NU

    2300000

    12660000

    Localitate4

    ClujBrasov

    21000000

    Err:5041

    Localitate Err:504Bucuresti 0

    20

    Nrzilegratie

    Datascadentei

  • Sumadatorata654913643148740050096620061880007992635028326760042840001487500046255300016060716011900000

    Err:5041 0

    Err:5040 1

    Err:5041

    Err:5041

    Err:5040 10 1

    Err:5040 Err:504

    0 1 Err:504

    1 0 0 Err:504

    0 Err:504Err:504

    NumrulfacturiloremiseinencasatedelaclieniidinClujiBrasovnanulprecedent.

  • Adresa Valoare

    100 Client1 Constanta Str.Florilo 456 2/12/2014 30zile 38,060,000101 Client2 Bucuresti Str.Avere 888 1/9/2014 30zile 21,000,000102 Client3 Brasov Str.1Mai 343 8/14/2013 15zile 7,000,000100 Client1 Constanta Str.Florilo 87 ### 20zile 5,200,000103 Client4 Cluj Str.Iancul 566 3/15/2004 0zile 9,500,000102 Client3 Brasov Str.1Mai 70 ### 15zile 4,000,000100 Client1 Constanta Str.Florilo 244 9/25/2015 20zile 3,600,000103 Client4 Cluj Str.Iancul 670 1/17/2004 0zile 12,500,000101 Client2 Bucuresti Str.Avere 122 4/12/2011 30zile 6,760,000100 Client1 Constanta Str.Florilo 406 ### 30zile 2,300,000100 Client1 Constanta Str.Florilo 111 7/3/2014 30zile 10,000,000

    Saseafisezelistaclientilorcareaumajorarideintarzierecuprinseintre2%si80%dinvaloare

    Adresa

    ### 100 Client1 Constanta Str.Florilo 456 2/12/2014102 Client3 Brasov Str.1Mai 343 8/14/2013102 Client3 Brasov Str.1Mai 70 10/15/2015101 Client2 Bucuresti Str.Avere 122 4/12/2011100 Client1 Constanta Str.Florilo 406 12/16/2014

    CodClient

    NumeClient

    Localitate

    Nrfactura

    Datafacturii

    Nrzilegratie

    Datascadentei

    CodClient

    NumeClient

    Localitate

    Nrfactura

    Datafacturii

  • Platit Majorari TVA

    NU ###DA ###NU ###DA ###NU ###NU ###DA ###DA ###NU ###NU ###DA ###

    Valoare Platit Majorari

    30zile 38,060,000 NU 3,425,40015zile 7,000,000 NU 315,00015zile 4,000,000 NU 180,00030zile 6,760,000 NU 608,40030zile 2,300,000 NU 207,000

    Sumadatorata

    nrzileint

    Nrzilegratie

    Datascadentei

  • Adresa Valoare

    100 Client1 Constanta Str.Florilo 456 2/12/2014 30zile 38,060,000101 Client2 Bucuresti Str.Avere 888 11/9/2015 30zile 21,000,000102 Client3 Brasov Str.1Mai 343 8/14/2013 15zile 7,000,000100 Client1 Constanta Str.Florilo 87 ### 20zile 5,200,000103 Client4 Cluj Str.Iancul 566 3/15/2004 0zile 9,500,000102 Client3 Brasov Str.1Mai 70 ### 15zile 4,000,000100 Client1 Constanta Str.Florilo 244 9/25/2015 20zile 3,600,000103 Client4 Cluj Str.Iancul 670 1/17/2004 0zile 12,500,000101 Client2 Bucuresti Str.Avere 122 ### 30zile 6,760,000100 Client1 Constanta Str.Florilo 406 ### 30zile 2,300,000100 Client1 Constanta Str.Florilo 111 7/3/2014 30zile 10,000,000

    Saseafisezelistaclientilorcucaresocietateaaincheiatcontracteinlunacurenta

    Adresa

    0 0 101 Client2 Bucuresti Str.Avere 888 11/9/2015

    CodClient

    NumeClient

    Localitate

    Nrfactura

    Datafacturii

    Nrzilegratie

    Datascadentei

    CodClient

    NumeClient

    Localitate

    Nrfactura

    Datafacturii

  • Platit Majorari TVA

    NU ###DA ###NU ###DA ###NU ###NU ###DA ###DA ###NU ###NU ###DA ###

    Valoare Platit Majorari

    30zile 21,000,000 DA 0

    Sumadatorata

    nrzileint

    Nrzilegratie

    Datascadentei

  • Adresa Valoare

    100 Client1 Constanta Str.Florilo 456 2/12/2014 30zile 38,060,000101 Client2 Bucuresti Str.Avere 888 11/9/2015 30zile 21,000,000102 Client3 Brasov Str.1Mai 343 8/14/2013 15zile 7,000,000100 Client1 Constanta Str.Florilo 87 ### 20zile 5,200,000103 Client4 Cluj Str.Iancul 566 3/15/2004 0zile 9,500,000102 Client3 Brasov Str.1Mai 70 ### 15zile 4,000,000100 Client1 Constanta Str.Florilo 244 9/25/2015 20zile 3,600,000103 Client4 Cluj Str.Iancul 670 1/17/2004 0zile 12,500,000101 Client2 Bucuresti Str.Avere 122 ### 30zile 6,760,000100 Client1 Constanta Str.Florilo 406 ### 30zile 2,300,000100 Client1 Constanta Str.Florilo 111 7/3/2014 30zile 10,000,000

    Saseafisezelistafacturiloremiseinultimele6luni,pentrucareclientulabeneficiatdeuntermendegratie

    Adresa Nrfactura

    1 0

    101 Client2 888102 Client3 70100 Client1 244

    CodClient

    NumeClient

    Localitate

    Nrfactura

    Datafacturii

    Nrzilegratie

    Datascadentei

    CodClient

    NumeClient

    Localitate

    CodClient

    NumeClient

    Nrfactura

    Datascadentei

  • Platit Majorari TVA

    NU ###DA ###NU ###DA ###NU ###NU ###DA ###DA ###NU ###NU ###DA ###

    Saseafisezelistafacturiloremiseinultimele6luni,pentrucareclientulabeneficiatdeuntermendegratie

    Valoare Platit Majorari

    Sumadatorata

    nrzileint

    Datafacturii

    Nrzilegratie

    Datascadentei

  • Adresa Valoare

    100 Client1 Constanta Str.Florilo 456 2/12/2014 30zile 38,060,000101 Client2 Bucuresti Str.Avere 888 11/9/2015 30zile 21,000,000102 Client3 Brasov Str.1Mai 343 8/14/2013 15zile 7,000,000100 Client1 Constanta Str.Florilo 87 ### 20zile 5,200,000103 Client4 Cluj Str.Iancul 566 3/15/2004 0zile 9,500,000102 Client3 Brasov Str.1Mai 70 ### 15zile 4,000,000100 Client1 Constanta Str.Florilo 244 9/25/2015 20zile 3,600,000103 Client4 Cluj Str.Iancul 670 1/17/2004 0zile 12,500,000101 Client2 Bucuresti Str.Avere 122 ### 30zile 6,760,000100 Client1 Constanta Str.Florilo 406 ### 30zile 2,300,000100 Client1 Constanta Str.Florilo 111 7/3/2014 30zile 10,000,000

    Saseafisezelistafacturilorneplatitelacarenrziledeintarzieredepasestemediaacestora

    Platit Adresa Nrfactura

    NU 0

    CodClient

    NumeClient

    Localitate

    Nrfactura

    Datafacturii

    Nrzilegratie

    Datascadentei

    CodClient

    NumeClient

    Localitate

  • Platit Majorari TVA

    NU ### 24DA ### 25NU ### 26DA ### 27NU ### 28NU ### 29DA ### 30DA ### 31NU ### 32NU ### 33DA ### 34

    Valoare Platit Majorari TVA

    Sumadatorata

    nrzileint

    Datafacturii

    Nrzilegratie

    Datascadentei

    Sumadatorata

    nrzileint

  • Adresa Valoare

    100 Client1 Constanta Str.Florilo 456 2/12/2014 30zile ###101 Client2 Bucuresti Str.Avere 888 11/9/2015 30zile ###102 Client3 Brasov Str.1Mai 343 8/14/2013 15zile 7,000,000100 Client1 Constanta Str.Florilo 87 ### 20zile 5,200,000103 Client4 Cluj Str.Iancul 566 3/15/2004 0zile 9,500,000102 Client3 Brasov Str.1Mai 70 ### 15zile 4,000,000100 Client1 Constanta Str.Florilo 244 9/25/2015 20zile 3,600,000103 Client4 Cluj Str.Iancul 670 1/17/2004 0zile ###101 Client2 Bucuresti Str.Avere 122 ### 30zile 6,760,000100 Client1 Constanta Str.Florilo 406 ### 30zile 2,300,000100 Client1 Constanta Str.Florilo 111 7/3/2014 30zile ###

    Catefacturisauamisinzileledeweekend

    0

    Adresa

    103 Client4 Cluj Str.Iancul 670 1/17/2004101 Client2 Bucuresti Str.Avere 122 ###

    CodClient

    NumeClient

    Localitate

    Nrfactura

    Datafacturii

    Nrzilegratie

    Datascadentei

    CodClient

    NumeClient

    Localitate

    Nrfactura

    Datafacturii

  • Platit Majorari TVA

    NU ### 24DA ### 25NU ### 26DA ### 27NU ### 28NU ### 29DA ### 30DA ### 31NU ### 32NU ### 33DA ### 34

    Valoare Platit Majorari TVA

    0zile 12,500,000 DA 0 3130zile 6,760,000 NU 608,400 32

    Sumadatorata

    nrzileint

    Nrzilegratie

    Datascadentei

    Sumadatorata

    nrzileint

  • Adresa Valoare

    100 Client1 Constanta Str.Florilo 456 2/12/2014 30zile 38,060,000101 Client2 Bucuresti Str.Avere 888 11/9/2015 30zile 21,000,000102 Client3 Brasov Str.1Mai 343 8/14/2013 15zile 7,000,000100 Client1 Constanta Str.Florilo 87 ### 20zile 5,200,000103 Client4 Cluj Str.Iancul 566 3/15/2004 0zile 9,500,000102 Client3 Brasov Str.1Mai 70 ### 15zile 4,000,000100 Client1 Constanta Str.Florilo 244 9/25/2015 20zile 3,600,000103 Client4 Cluj Str.Iancul 670 1/17/2004 0zile 12,500,000101 Client2 Bucuresti Str.Avere 122 ### 30zile 6,760,000100 Client1 Constanta Str.Florilo 406 ### 30zile 2,300,000100 Client1 Constanta Str.Florilo 111 7/3/2014 30zile 10,000,000

    Careestefacturalacaresauaplicatcelemaimaripenalitatidatoritanerespectariiconditiilorcontractuale

    Adresa

    1 100 Client1 Constanta Str.Florilo 456 2/12/2014

    CodClient

    NumeClient

    Localitate

    Nrfactura

    Datafacturii

    Nrzilegratie

    Datascadentei

    CodClient

    NumeClient

    Localitate

    Nrfactura

    Datafacturii

  • Platit Majorari TVA

    NU ### 3524 24DA ### 12542 25NU ### 2154 26DA ### 15845 27NU ### 2105 28NU ### 25468 29DA ### 6521 30DA ### 5488 31NU ### 6524 32NU ### 5422 33DA ### 1542 34

    Careestefacturalacaresauaplicatcelemaimaripenalitatidatoritanerespectariiconditiilorcontractuale

    Valoare Platit Majorari TVA

    30zile 38,060,000 NU 3,425,400 3524 24

    Sumadatorata

    nrzileint

    Nrzilegratie

    Datascadentei

    Sumadatorata

    nrzileint

  • Adresa Valoare

    100 Client1 Constanta Str.Florilo 456 2/12/2014 30zile ###101 Client2 Bucuresti Str.Avere 888 11/9/2015 30zile ###102 Client3 Brasov Str.1Mai 343 8/14/2013 15zile 7,000,000100 Client1 Constanta Str.Florilo 87 ### 20zile 5,200,000103 Client4 Cluj Str.Iancul 566 3/15/2004 0zile 9,500,000102 Client3 Brasov Str.1Mai 70 ### 15zile 4,000,000100 Client1 Constanta Str.Florilo 244 9/25/2015 20zile 3,600,000103 Client4 Cluj Str.Iancul 670 1/17/2004 0zile ###101 Client2 Bucuresti Str.Avere 122 ### 30zile 6,760,000100 Client1 Constanta Str.Florilo 406 ### 30zile 2,300,000100 Client1 Constanta Str.Florilo 111 7/3/2014 30zile ###

    Careesteanulincaresauemiscelemaimultefacturi

    Adresa

    1 100 Client1 Constanta Str.Florilo 456 2/12/2014101 Client2 Bucuresti Str.Avere 888 11/9/2015100 Client1 Constanta Str.Florilo 87 ###103 Client4 Cluj Str.Iancul 566 3/15/2004102 Client3 Brasov Str.1Mai 70 ###100 Client1 Constanta Str.Florilo 406 ###

    CodClient

    NumeClient

    Localitate

    Nrfactura

    Datafacturii

    Nrzilegratie

    Datascadentei

    CodClient

    NumeClient

    Localitate

    Nrfactura

    Datafacturii

  • Platit Majorari TVA

    NU ### 3524 24DA ### 12542 25NU ### 2154 26DA ### 15845 27NU ### 2105 28NU ### 25468 29DA ### 6521 30DA ### 5488 31NU ### 6524 32NU ### 5422 33DA ### 1542 34

    Valoare Platit Majorari TVA

    30zile 38,060,000 NU 3,425,400 3524 2430zile 21,000,000 DA 0 12542 2520zile 5,200,000 DA 0 15845 270zile 9,500,000 NU 0 2105 28

    15zile 4,000,000 NU 180,000 25468 2930zile 2,300,000 NU 207,000 5422 33

    Sumadatorata

    nrzileint

    Nrzilegratie

    Datascadentei

    Sumadatorata

    nrzileint

  • Adresa Valoare

    100 Client1 Constanta Str.Florilo 456 2/12/2014 30zile 38,060,000101 Client2 Bucuresti Str.Avere 888 11/9/2015 30zile 21,000,000102 Client3 Brasov Str.1Mai 343 8/14/2013 15zile 7,000,000100 Client1 Constanta Str.Florilo 87 ### 20zile 5,200,000103 Client4 Cluj Str.Iancul 566 3/15/2004 0zile 9,500,000102 Client3 Brasov Str.1Mai 70 ### 15zile 4,000,000100 Client1 Constanta Str.Florilo 244 9/25/2015 20zile 3,600,000103 Client4 Cluj Str.Iancul 670 1/17/2004 0zile 12,500,000101 Client2 Bucuresti Str.Avere 122 ### 30zile 6,760,000100 Client1 Constanta Str.Florilo 406 ### 30zile 2,300,000100 Client1 Constanta Str.Florilo 111 7/3/2014 30zile 10,000,000

    Careesteziuaincaresauincheiatcelemaimultefacturiinlunacurenta?

    Adresa Nrfactura

    0 0 101 Client2 Bucuresti Str.Avere 888

    CodClient

    NumeClient

    Localitate

    Nrfactura

    Datafacturii

    Nrzilegratie

    Datascadentei

    CodClient

    NumeClient

    Localitate

  • Platit Majorari TVA

    NU ### 3524 24DA ### 12542 25NU ### 2154 26DA ### 15845 27NU ### 2105 28NU ### 25468 29DA ### 6521 30DA ### 5488 31NU ### 6524 32NU ### 5422 33DA ### 1542 34

    Valoare Platit Majorari TVA

    11/9/2015 30zile ### DA 0 12542 25

    Sumadatorata

    nrzileint

    Datafacturii

    Nrzilegratie

    Datascadentei

    Sumadatorata

    nrzileint

  • Adresa Valoare

    100 Client1 Constanta Str.Florilo 456 2/12/2014 30zile 3/14/2014 38,060,000101 Client2 Bucuresti Str.Avere 888 11/9/2015 30zile 12/9/2015 21,000,000102 Client3 Brasov Str.1Mai 343 8/14/2013 15zile 8/29/2013 7,000,000100 Client1 Constanta Str.Florilo 87 ### 20zile ### 5,200,000103 Client4 Cluj Str.Iancul 566 3/15/2004 0zile 3/15/2004 9,500,000102 Client3 Brasov Str.1Mai 70 ### 15zile ### 4,000,000100 Client1 Constanta Str.Florilo 244 9/25/2015 20zile ### 3,600,000103 Client4 Cluj Str.Iancul 670 1/17/2004 0zile 1/17/2004 12,500,000101 Client2 Bucuresti Str.Avere 122 ### 30zile ### 6,760,000100 Client1 Constanta Str.Florilo 406 ### 30zile 1/15/2015 2,300,000100 Client1 Constanta Str.Florilo 111 7/3/2014 30zile 8/2/2014 10,000,000

    Saseafisezelistafacturilorneplatitepentrucaresadepasitscadentacumaimultdeunandezile

    Platit Adresa Nrfactura

    NU 1 100 Client1 Constanta Str.Florilo 456102 Client3 Brasov Str.1Mai 343103 Client4 Cluj Str.Iancul 566101 Client2 Bucuresti Str.Avere 122

    CodClient

    NumeClient

    Localitate

    Nrfactura

    Datafacturii

    Nrzilegratie

    Datascadentei

    CodClient

    NumeClient

    Localitate

  • Platit Majorari TVA

    NU ### 3524 24DA ### 12542 25NU ### 2154 26DA ### 15845 27NU ### 2105 28NU ### 25468 29DA ### 6521 30DA ### 5488 31NU ### 6524 32NU ### 5422 33DA ### 1542 34

    Valoare Platit Majorari TVA

    2/12/2014 30zile 3/14/2014 38,060,000 NU 3,425,400 3524 248/14/2013 15zile 8/29/2013 7,000,000 NU 315,000 2154 263/15/2004 0zile 3/15/2004 9,500,000 NU 0 2105 28

    ### 30zile ### 6,760,000 NU 608,400 6524 32

    Sumadatorata

    nrzileint

    Datafacturii

    Nrzilegratie

    Datascadentei

    Sumadatorata

    nrzileint

    Filtru avansatFunctii BDSheet4Sheet5Sheet6Sheet7Sheet8Sheet9Sheet10Sheet11Sheet12