Question: Wrong Calculation Balance Value In Pos Sales

Wrong Calculation Balance Value In Pos Sales

Hi... i just updated my pos module to the latest version form 3.4.13 to 3.4.40, but my pos sales for balance value is wrong calculation . idon't know why but if i reverted installation t

A

ali

Asked

Hi…

i just updated my pos module to the latest version form 3.4.13 to 3.4.40, but my pos sales for balance value is wrong calculation . idon’t know why but if i reverted installation to 3.4.13 the balance value is right.

the case problem is : if i have sale with grand total as 30 and i paid 30 the balance value is high value instead of 0. if i have sale with grand total as 30 and i paid partialy as 15 the balance value is hight too instead of 15.

i think it’s bug form the update , can you explainded . i’ve update likes your the documentation istruction.

thanks ali,

  • MS

    Mian Saleem

    Answered

    Hello,

    As I know there is not any change to balance as you mentioned in the updates. Can you please share the screenshots?

    Just a thought, was there any error while importing the sql update in step 8?

  • A

    ali

    Answered

    Here it’s error snap shot.

  • MS

    Mian Saleem

    Answered

    Hello,

    I am not sure how you got that balance numbers. Those are higher than the grand total 😦 Please let me know the step to reproduce the issue on live demo.

    Thank you

  • A

    ali

    Answered

    hello,

    just normal step… going to POS Module e.g check out 1 item with price 34,000 and i paid with payment method cash and amount is 34,000 , check in POS Sales the balance is higher instead of 0. before i used 3.4.13 it’s no problem with balance amount. i updated my version to 3.4.40 it’s error like that.

    thanks n wait from your respond .

  • MS

    Mian Saleem

    Answered

    Hello,

    I have tested locally and it’s working fine. Was there any error while import sql files on step 8?

    Can you please check the sales table in your database. The Balance is calculated as grant_total+rounding-paid

    You can try to download the file again and replace the themes/ and app/controllers/ folder then test again.

    Thank you

  • A

    ali

    Answered

    Hi,

    check my sales table in my database, i didn’t found column “rounding-paid” only “Paid” column.

  • MS

    Mian Saleem

    Answered

    Hello,

    Those three are the columns/fields of the sma_sales table.

    Please let me know your installation link with owner account details so that I can check.

    You can post private reply by enabling the PRIVATE for Staff only at top right of the reply section.

    Thank you

  • Login to Reply