BUG formula field

BUG formula field

Hello i have to use this formula but i have always error "virgolette mancanti", i add comments to simplify understanding. Someone can help me?


  2. //${Invoices.Acc.} => Money Value
  3. //${Invoices.N Scad.} => Select menù Field (value: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
  4. //${Dist. scad.} => Select menù Field (value: 30, 60, 120, 180)
  5. //${Invoices.Pag. IVA => Select menù Field (value: subito, distribuito, esente)
  6. //${Invoices.Dist. prima scad.} => Select menù Field (value: 30, 60, 120, 180)
  7. //${Invoices.Giorno Scad.} => Select menù Field (value: 10, 15, FM)


  10. Concat(
  12. //ACCONTO
  13. If(${Invoices.Acc.}==0,'',Concat('Acconto/Down Payment €',Tostring(${Invoices.Acc.}))),
  15. //PRIMA SCADENZA
  16. If(Tonumber(${Invoices.N Scad.})>=1,Concat(' - 1: ',

  18. //IVA SUBITO
  19. If(Tostring(${Invoices.Pag. IVA})=='subito',
  20. Tostring(
  21. (${Invoices.Grand Total}-${Invoices.Acc.}-${Invoices.Grand Total}/1.22)/${Invoices.N Scad.}+${Invoices.Grand Total}-${Invoices.Grand Total}/1.22
  22. ),

  24. //ESLE IVA DISTRIBUITA O ASSENTE
  25. Tostring(
  26. (${Invoices.Grand Total}-${Invoices.Acc.})/${Invoices.N Scad.}
  27. )
  28. ),

  30. //DATE 1
  31. If (Tostring(${Invoices.Giorno Scad.})=='10'
  32. //10 DEL MESE
  33. Tostring(Newdate(
  34. Year(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.}), 'DAY'),
  35. Month(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.}), 'DAY'),
  36. 10)),

  38. //15 DEL MESE
  39. If (Tostring(${Invoices.Giorno Scad.})=='15'
  40. Tostring(Newdate(
  41. Year(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.}), 'DAY'),
  42. Month(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.}), 'DAY'),
  43. 15)),

  45. //FM DEL MESE
  46. //AGOSTO O DICEMBRE
  47. Tostring(
  48. if(Or(Month(
  49. Subdate(Newdate(
  50. Year(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+30, 'DAY'),
  51. Month(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+30, 'DAY'),
  52. 1),1, 'DAY')
  53. )=12),Month(
  54. Subdate(Newdate(
  55. Year(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+30, 'DAY'),
  56. Month(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+30, 'DAY'),
  57. 1),1, 'DAY')
  58. )=8)),
  59. Tostring(Newdate(
  60. Year(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.}), 'DAY'),
  61. Month(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.}), 'DAY'),
  62. 10)),
  63. Subdate(Newdate(
  64. Year(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+30, 'DAY'),
  65. Month(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+30, 'DAY'),
  66. 1),1, 'DAY')

  68. )
  69. )
  70. )


  73. //SECONDA SCADENZA
  74. If(Tonumber(${Invoices.N Scad.})>=2,Concat(' - 2: ',

  76. //IVA SUBITO
  77. If(Tostring(${Invoices.Pag. IVA})=='subito',
  78. Tostring(
  79. (${Invoices.Grand Total}-${Invoices.Acc.}-${Invoices.Grand Total}/1.22)/${Invoices.N Scad.}
  80. ),

  82. //ESLE IVA DISTRIBUITA O ASSENTE
  83. Tostring(
  84. (${Invoices.Grand Total}-${Invoices.Acc.})/${Invoices.N Scad.}
  85. )
  86. ),

  88. //DATE 2
  89. If (Tostring(${Invoices.Giorno Scad.})=='10'
  90. //10 DEL MESE
  91. Tostring(Newdate(
  92. Year(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+Tonumber(${Invoices.Dist. scad.})*1, 'DAY'),
  93. Month(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+Tonumber(${Invoices.Dist. scad.})*1, 'DAY'),
  94. 10)),

  96. //15 DEL MESE
  97. If (Tostring(${Invoices.Giorno Scad.})=='15'
  98. Tostring(Newdate(
  99. Year(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+Tonumber(${Invoices.Dist. scad.})*1, 'DAY'),
  100. Month(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+Tonumber(${Invoices.Dist. scad.})*1, 'DAY'),
  101. 15)),

  103. //FM DEL MESE
  104. //AGOSTO O DICEMBRE
  105. Tostring(
  106. if(Or(Month(
  107. Subdate(Newdate(
  108. Year(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+Tonumber(${Invoices.Dist. scad.})*1+30, 'DAY'),
  109. Month(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+Tonumber(${Invoices.Dist. scad.})*1+30, 'DAY'),
  110. 1),1, 'DAY')
  111. )=12),Month(
  112. Subdate(Newdate(
  113. Year(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+Tonumber(${Invoices.Dist. scad.})*1+30, 'DAY'),
  114. Month(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+Tonumber(${Invoices.Dist. scad.})*1+30, 'DAY'),
  115. 1),1, 'DAY')
  116. )=8)),
  117. Tostring(Newdate(
  118. Year(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+Tonumber(${Invoices.Dist. scad.})*1, 'DAY'),
  119. Month(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+Tonumber(${Invoices.Dist. scad.})*1, 'DAY'),
  120. 10)),
  121. Subdate(Newdate(
  122. Year(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+Tonumber(${Invoices.Dist. scad.})*1+30, 'DAY'),
  123. Month(Adddate(${Invoices.Invoice Date},Tonumber(${Invoices.Dist. prima scad.})+Tonumber(${Invoices.Dist. scad.})*1+30, 'DAY'),
  124. 1),1, 'DAY')

  126. )
  127. )
  128. )
  129. )