{"id":14653,"date":"2022-09-06T11:41:45","date_gmt":"2022-09-06T10:41:45","guid":{"rendered":"https:\/\/www.knowledgebase.info-bit.com\/?p=14653"},"modified":"2025-06-20T14:54:38","modified_gmt":"2025-06-20T13:54:38","slug":"errore-la-sottoquery-ha-restituito-piu-di-un-valore-in-stampa-liquidazione-iva","status":"publish","type":"post","link":"https:\/\/www.knowledgebase.info-bit.com\/?p=14653","title":{"rendered":"Errore \u2018La sottoquery ha restituito pi\u00f9 di un valore\u2019 in stampa Liquidazione IVA"},"content":{"rendered":"

SINTOMO<\/strong><\/b><\/span><\/h2>\n

In stampa di una liquidazione IVA appare il seguente messaggio:<\/p>\n

\"\"<\/p>\n

CAUSA<\/b><\/span><\/h2>\n

Il problema si presenta quando nella parametrizzazione delle stampe fiscali \u00e8 spuntata l\u2019opzione \u2018Suddividi riepilogo per registro IVA\u2019.<\/p>\n

Con questa configurazione attiva, in stampa liquidazione, il riepilogo IVA viene suddiviso per registro IVA.<\/p>\n

La suddivisione \u00e8 implementata attraverso le serie inserite nella definizione dei registri IVA.<\/p>\n

Se per\u00f2 la stessa<\/u> serie \u00e8 presente nella definizione di diversi registri IVA, quando Ring incontra una registrazione contabile associata a questa serie, non \u00e8 in grado di assegnarla, in stampa, ad un singolo registro. Questo proprio perch\u00e9 la serie fa’ parte di pi\u00f9 registri.<\/p>\n

Questa configurazione dei registri d\u00e0 luogo all’errore in questione.<\/p>\n

Ad esempio, un caso che genera l’errore, \u00e8 la presenza di due registri IVA di tipo IntraCEE (normalmente uno per acquisiti ed uno per vendite) contenenti le medesime serie di numerazione.
\nRing, nel registro IVA IntraCEE, si occupa automaticamente di stampare due volte la stessa registrazione, la seconda con importo uguale e contrario alla prima.
\nQuindi, se il tipo registro \u00e8 impostato a IntraCEE, \u00e8 errato creare due registri di questo tipo con le stesse serie di numerazione.
\nAl punto 3.1.2.2 del manuale sono presenti degli esempi di configurazione dei registri IVA.<\/p>\n

Questa query SQL pu\u00f2 aiutare a determinare i registri che determinano l’errore in oggetto:<\/p>\n

SELECT<\/strong> T1.”Code”, T1.”Name”, T0.”U_Serie”
\nFROM<\/strong> “@INFOBIT_REGIVASERIE” T0
\nINNER<\/strong> JOIN<\/strong> “@INFOBIT_REGIVADEF” T1 ON<\/strong> T1.”Code” = T0.”Code”
\nWHERE<\/strong> (SELECT<\/strong> COUNT<\/strong>(* )
\nFROM<\/strong> “@INFOBIT_REGIVASERIE” SE
\nINNER<\/strong> JOIN<\/strong> “@INFOBIT_REGIVADEF” RD ON<\/strong> SE.”Code” = RD.”Code”
\nWHERE<\/strong> SE.”U_Serie” = T0.”U_Serie” AND<\/strong> RD.”U_Tipo” IN<\/strong> (T1.”U_Tipo”, ‘I’, ‘V’, ‘A’) AND<\/strong> RD.”Code” <> T1.”Code”)
\n>0<\/p>\n

SOLUZIONE<\/b><\/span><\/h2>\n

Rivedere la definizione dei registri IVA e correggere i registri nei quali la stessa serie \u00e8 presente in due o pi\u00f9 registri dello stesso tipo.<\/p>\n

In alternativa, togliere la spunta da \u2018Suddividi riepilogo per registro IVA\u2019.<\/p>\n<\/div>

<\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":8,"featured_media":13784,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[30],"tags":[132,133],"yoast_head":"\r\nErrore \u2018La sottoquery ha restituito pi\u00f9 di un valore\u2019 in stampa Liquidazione IVA - Knowledgebase Info-Bit<\/title>\r\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<meta property=\"og:locale\" content=\"it_IT\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Errore \u2018La sottoquery ha restituito pi\u00f9 di un valore\u2019 in stampa Liquidazione IVA - Knowledgebase Info-Bit\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.knowledgebase.info-bit.com\/?p=14653\" \/>\r\n<meta property=\"og:site_name\" content=\"Knowledgebase Info-Bit\" \/>\r\n<meta property=\"article:published_time\" content=\"2022-09-06T10:41:45+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-06-20T13:54:38+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2019\/03\/Image-1.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"826\" \/>\r\n\t<meta property=\"og:image:height\" content=\"90\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Scritto da\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paolo Fornari\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuti\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/#website\",\"url\":\"https:\/\/www.knowledgebase.info-bit.com\/\",\"name\":\"Knowledgebase Info-Bit\",\"description\":\"Soluzioni rapide alle richieste dei nostri clienti\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.knowledgebase.info-bit.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"it-IT\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/?p=14653#primaryimage\",\"inLanguage\":\"it-IT\",\"url\":\"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2019\/03\/Image-1.png\",\"contentUrl\":\"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2019\/03\/Image-1.png\",\"width\":826,\"height\":90},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/?p=14653#webpage\",\"url\":\"https:\/\/www.knowledgebase.info-bit.com\/?p=14653\",\"name\":\"Errore \\u2018La sottoquery ha restituito pi\\u00f9 di un valore\\u2019 in stampa Liquidazione IVA - Knowledgebase Info-Bit\",\"isPartOf\":{\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/?p=14653#primaryimage\"},\"datePublished\":\"2022-09-06T10:41:45+00:00\",\"dateModified\":\"2025-06-20T13:54:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/#\/schema\/person\/e00be2d3822c5a64b78e45614d098ba8\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/?p=14653#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.knowledgebase.info-bit.com\/?p=14653\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/?p=14653#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Errore \\u2018La sottoquery ha restituito pi\\u00f9 di un valore\\u2019 in stampa Liquidazione IVA\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/#\/schema\/person\/e00be2d3822c5a64b78e45614d098ba8\",\"name\":\"Paolo Fornari\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.knowledgebase.info-bit.com\/#personlogo\",\"inLanguage\":\"it-IT\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff3d28814f0df84f3a9cefd94fe68429?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff3d28814f0df84f3a9cefd94fe68429?s=96&d=mm&r=g\",\"caption\":\"Paolo Fornari\"},\"url\":\"https:\/\/www.knowledgebase.info-bit.com\/?author=8\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Errore \u2018La sottoquery ha restituito pi\u00f9 di un valore\u2019 in stampa Liquidazione IVA - Knowledgebase Info-Bit","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"it_IT","og_type":"article","og_title":"Errore \u2018La sottoquery ha restituito pi\u00f9 di un valore\u2019 in stampa Liquidazione IVA - Knowledgebase Info-Bit","og_url":"https:\/\/www.knowledgebase.info-bit.com\/?p=14653","og_site_name":"Knowledgebase Info-Bit","article_published_time":"2022-09-06T10:41:45+00:00","article_modified_time":"2025-06-20T13:54:38+00:00","og_image":[{"width":826,"height":90,"url":"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2019\/03\/Image-1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Scritto da":"Paolo Fornari","Tempo di lettura stimato":"2 minuti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.knowledgebase.info-bit.com\/#website","url":"https:\/\/www.knowledgebase.info-bit.com\/","name":"Knowledgebase Info-Bit","description":"Soluzioni rapide alle richieste dei nostri clienti","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.knowledgebase.info-bit.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"it-IT"},{"@type":"ImageObject","@id":"https:\/\/www.knowledgebase.info-bit.com\/?p=14653#primaryimage","inLanguage":"it-IT","url":"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2019\/03\/Image-1.png","contentUrl":"https:\/\/www.knowledgebase.info-bit.com\/wp-content\/uploads\/2019\/03\/Image-1.png","width":826,"height":90},{"@type":"WebPage","@id":"https:\/\/www.knowledgebase.info-bit.com\/?p=14653#webpage","url":"https:\/\/www.knowledgebase.info-bit.com\/?p=14653","name":"Errore \u2018La sottoquery ha restituito pi\u00f9 di un valore\u2019 in stampa Liquidazione IVA - Knowledgebase Info-Bit","isPartOf":{"@id":"https:\/\/www.knowledgebase.info-bit.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.knowledgebase.info-bit.com\/?p=14653#primaryimage"},"datePublished":"2022-09-06T10:41:45+00:00","dateModified":"2025-06-20T13:54:38+00:00","author":{"@id":"https:\/\/www.knowledgebase.info-bit.com\/#\/schema\/person\/e00be2d3822c5a64b78e45614d098ba8"},"breadcrumb":{"@id":"https:\/\/www.knowledgebase.info-bit.com\/?p=14653#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.knowledgebase.info-bit.com\/?p=14653"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.knowledgebase.info-bit.com\/?p=14653#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Errore \u2018La sottoquery ha restituito pi\u00f9 di un valore\u2019 in stampa Liquidazione IVA"}]},{"@type":"Person","@id":"https:\/\/www.knowledgebase.info-bit.com\/#\/schema\/person\/e00be2d3822c5a64b78e45614d098ba8","name":"Paolo Fornari","image":{"@type":"ImageObject","@id":"https:\/\/www.knowledgebase.info-bit.com\/#personlogo","inLanguage":"it-IT","url":"https:\/\/secure.gravatar.com\/avatar\/ff3d28814f0df84f3a9cefd94fe68429?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff3d28814f0df84f3a9cefd94fe68429?s=96&d=mm&r=g","caption":"Paolo Fornari"},"url":"https:\/\/www.knowledgebase.info-bit.com\/?author=8"}]}},"_links":{"self":[{"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=\/wp\/v2\/posts\/14653"}],"collection":[{"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=14653"}],"version-history":[{"count":10,"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=\/wp\/v2\/posts\/14653\/revisions"}],"predecessor-version":[{"id":15042,"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=\/wp\/v2\/posts\/14653\/revisions\/15042"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=\/wp\/v2\/media\/13784"}],"wp:attachment":[{"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.knowledgebase.info-bit.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}