(Sales and Expense) qty with decimal (eg. 20.2568) support input?

  • Resolved johnvinson.go

    (@johnvinsongo)


    8 years, 4 months ago

    Hi WeDev Team,

    Thanks for the support that you had given to me last time.

    My question now is that… I am being forced on the Invoice Creation Page to put a Whole Number on the Quantity Field no matter how I tried to create one. Is there a fix or function that I could disable so that I can use Quantity w/ decimal support especially for Volumetric products (eg. Sand & Gravel or any product that is based on volume / charge)?

    Thanks in advance.

    • This topic was modified 8 years, 4 months ago by johnvinson.go.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter johnvinson.go

    (@johnvinsongo)

    I have found out the line of code that causes this issue. Field type ‘Number’ was changed to ‘Text’. Decimal Value input is now accepted. ??

    Thread Starter johnvinson.go

    (@johnvinsongo)

    I have another inquiry…

    I was able to input values with decimals now. But, when the Create Button creates the Invoice… it just saves the whole number on the DB Table.

    Is there a way for me to change this process? So that the values with decimals that I have entered on the Invoice can be saved on the DB Table as well.

    Thread Starter johnvinson.go

    (@johnvinsongo)

    Never Mind. I have found the file responsible for the issue. ?? hehehe.

    class-form-handler.php

    I have change intval to floatval. ??

    Hi @johnvinsongo, glad to hear that you figured out the solution by yourself. You’ve pointed out a very important issue. We’ve just put this into our todo list and planning to include this in version 1.2.

    Cheers!

    ~Edi

    Thread Starter johnvinson.go

    (@johnvinsongo)

    @ediadmin

    By the way, I also manually added a new qty (VARCHAR) table column on erp_transaction_items table to handle floatvalue data. The current qty (tinyint) table column can’t handle floatvalue data.

    Thread Starter johnvinson.go

    (@johnvinsongo)

    @ediadmin

    You’re welcome. I’m glad that I was able to contribute in your development.

    —
    best regards,
    John Vinson

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘(Sales and Expense) qty with decimal (eg. 20.2568) support input?’ is closed to new replies.