Hello, see the error when the client tries to transfer credit between accounts in version 6 community in the Portuguese language, in the English language it works normally.

Error Number: 1136

Column count doesn’t match value count at row 1

INSERT INTO invoice_details (accountid, description, created_date, invoiceid, reseller_id, is_tax, order_item_id, payment_id, before_balance, product_category, charge_type, after_balance, base_currency, exchange_rate, account_currency, debit, credit) VALUES (‘2’, ‘Fund has been transfered from 4723285745 '(' 51294181 ')'’, ‘2022-11-15 21:04:02’, 8, ‘0’, 0, 0, 8, ‘697.60000’, ‘3’, ‘FUNDTRANSFER’, 687,6, ‘BRL’, ‘3.875’, ‘BRL’, 10, ‘0.00’)

Filename: /opt/ASTPP/web_interface/astpp/libraries/astpp/invoice.php

Line Number: 199

This path does not exist at this address:
/opt/ASTPP/web_interface/astpp/libraries/astpp/invoice.php

Thanks

verified in latest community v6,

working as expected. 

Did you test in Spanish and Portuguese language? Here it only worked in English, but my customers don't use English! Please access the test client area in Spanish and Portuguese and take the test. Thanks

Friends, any resolution? Thanks and regards

Verified with the specified Portuguese and Spanish languages. It's working for both languages.

Impossible!!! Have you tested it on version 6? Because the error is visible, see the attached image, is some column missing in mysql, or did you add it manually? Did you test it in the customer area in Portuguese and Spanish?

Hello, here is the attached video(screen-recording.webm) of the error in question with clean installation of astpp 6. Thanks

Thanks for the attention Danilo Borges

We are able to reproduce this issue. Fund transfer is giving error when customer account balance is in decimal value. 

Kinjal Prajapati check attached video. 

Customer, admin and base currency is BRL.

This is Fixed. PR Details are as follows. Alpesh Kaklottar can you please verify and let us know if anything.  

https://github.com/iNextrix/ASTPP/pull/676

Hello Sanket Thakkar, the problem is not fully resolved.

*Assuming I have a balance of 84,408 and I try to transfer 1.65 it says I have no balance.
*Assuming I have a balance of 264.26 and I try to transfer 1.65 it transfers 165.
*And for integer values it can now transfer correctly.
Thanks and Regards

Dear Danilo Borges Thank for the more clarification. 

Please wait for a while, internal verification is going on. We will let you know once it is ready for your verification. 

Kinjal Prajapati , when we set BRL currency (in admin, both customer, base currency) then try to transfer 1.65 amount,

more than 300 amount transferred with Portuguese language,

expected result: if there is no need to currency conversion then it should be transferred same amount because we set same currency.

please check recent attachment and try to reproduce. 

Kinjal Prajapati as we discussed to do not change base currency,

set base currency as USD, ADMIN has BRL, both customer have BRL,

1. now try to transfer with english language : got error as " you need to enter minimum 0.1905 for fund transfer"  : so it should be resolved for validation. 

2. try to transfer with portuguese language : got error as " no sufficient fund "   : where customer has sufficient fund

3. try to transfer with spanish language : fund transfer successfully. 

please do needful as mentioned above. let me know if anything. 

Hi,

After updating the 2 files via github request #677 I tested leaving the base currency in USD, and admin and user in BRL, and see that it transfers the wrong values:

user: 4727985745 balance: 250.71 BRL

user: 54004181 balance: 552.12 BRL

when transferring 25.01 from 4727985745 the balance is: 188.71  and the correct one would be: 225.70

after the transfer the balance of 54004181 was in: 614.12   and the correct one would be: 577.13

And leaving the base in BRL it says that the balance is insufficient! 

Thanks and Regards

Kinjal Prajapati

Following issues are occurring when base currency(USD) and customer's currency(BRL) are different. 

1. In English and Portuguese language, When customer transfer 25BRL, debited amount is 6.45(Which equivalent into USD from BRL conversion, exchange rate is 3.8750)
2. In Spanish language, User balance is display without decimal points and this problem is also causing incorrect amount transfer

Check attached videos. 

Danilo Borges

Can you please share below details

1. Admin's currency
2. Base currency
3. Customer's currency
4. If currency of customer and base currency is different then currency exchange rate
5. Date of set-up(Source code)

Hi, let's start from the beginning, I just gave the git command below to get the most current version:
rm -rf /opt/ASTPP
cd /opt && git clone -b V6.0 https://github.com/iNextrix/ASTPP/
chown -R www-data. /opt/ASTPP/web_interface/astpp

Configuration>>>Settings:
Decimal Points = 2
Minimum Fund Transfer = 25
Base Currency = Brazilian Real

Configuration>>>Languages>>>Languages
Default Language = Portuguese

Accounts>>>Admins:
Country = Brazil
Timezone = America/Sao_Paulo (GMT -03:00)
Currency = Brazilian Real (BRL)

Accounts>>>Customers>>>Customers:
Country = Brazil
Timezone = America/Sao_Paulo (GMT -03:00)
Currency = Brazilian Real (BRL)

In this configuration above, when I enter the user, he already enters the Portuguese language (default language), and I try to make a transfer in the amount of 26.00, he does it correctly and without errors.
When I try to do 26.71 it says "You need to enter minimum 25.0000 for fund transfer."

In this same configuration above, when I enter the user, he already enters the Portuguese language (default language), I go to the footer and change it to "English" any transfer works, both integer value 26.00 and decimal value 26.71 without any error!

Thanks and Regards

Friends, I just confirmed that the problem was solved, but for that I had to copy the files from https://github.com/iNextrix/ASTPP/pull/678/files if I just do a git it fetches the files without the changes what did you guys do, will we always have to make these changes manually or does it go to the github master?
PROBLEM SOLVED!!! THANKS

Danilo Borges Thanks for the confirmation, Definitely changes will merge into Master of ASTPP v6.0.