Carrie Underwood Have Anorexia
AbanQ Recover Deleted Files: Import with lyrics on the invoices By default in field "text" table "reciboscli" is stored the number with lyrics, but the way it is produced does not work to Mexico for what needs to be modified. The required changes are:
In the script "treasury / scripts / flfactteso.qs" Add the following code in the "oficial_generarReciboCli" / * Start of code added. * /
/ / variable declaration var
rounded: Number = 0;
var cents: Number = 0;
conletra var: String;
totalconletra var: String;
conletra var = util.enLetra (amount) / / Quantity with the integer number rounded = Math.round
(amount) / / rounds the amount to the nearest whole number to see if
cents (rounded
cent = amount - rounded;
cents = cents * 100;} if (round> amount) {cents = round
- amount; cents = cents * 100;}
if (cents == 0) {
totalconletra = conletra + "PESOS" + cent + cents + "/ 100 MN";
} else {
totalconletra = conletra + "PESOS" + cents + "/ 100 MN"
} / *
would have been easier to get the decimal util.partDecimal (amount),
but returned a nice use segmentation violation:
/ / var cents: Number = util.partDecimal (amount);
* /
/ * end of code added. * /
In the same function a little further down is amended:
setValueBuffer ("text", util.enLetraMoneda (amount, currency));
By:
setValueBuffer ("text", totalconletra.upper ()) / * upper is used to display my text in uppercase. * /
The file "reports / queries / i_facturascli.qry"
Changed:
\u0026lt;tables> company facturascli, lineasfacturascli, albaranescli \u0026lt;/ tables> < importe){
By:
\u0026lt;tables> ; company facturascli, lineasfacturascli, albaranescli, reciboscli \u0026lt;/ tables>
Labels
select the same file is added the "reciboscli.texto" and the labels from change:
\u0026lt;from>
company INNER JOIN facturascli lineasfacturascli facturascli.idfactura = lineasfacturascli.idfactura
ON LEFT OUTER JOIN ON albaranescli albaranescli.idalbaran = lineasfacturascli.idalbaran
\u0026lt;/ from>
By:
\u0026lt;from>
company facturascli lineasfacturascli INNER JOIN ON facturascli.idfactura = lineasfacturascli.idfactura
reciboscli INNER JOIN ON reciboscli.idfactura = facturascli.idfactura
LEFT OUTER JOIN ON albaranescli.idalbaran = lineasfacturascli.idalbaran albaranescli \u0026lt;/ from>
The file "reports / reports / i_facturascli.kut"
call is sent the "reciboscli.texto"
\u0026lt;CalculatedField BackgroundColor = "255,255,255" BorderColor = " 0,0,0 " BorderStyle =" 0 "BorderWidth =" 1 "CalculationType =" 5 "
CommaSeparator =" 0 "Currency =" 32 "DataType =" 0 "
DateFormat =" 11 "Field =" reciboscli.texto "FontFamily =" Verdana "
FontItalic =" 0 "FontSize =" 10 "FontWeight =" 50 " ForegroundColor =" 0,0,0 "HAlignment =" 0 "Height =" 20 "
NegValueColor =" 0.0, 0 " Precision = "0" Text = "[reciboscli.texto]
VAlignment =" 1 "width =" 410 "WordWrap =" 0 "
X =" 98 "Y =" 28 "/>
0 comments:
Post a Comment