Accounting Reports not reflecting qty correctly

This topic has 6 replies, 3 voices, and was last updated 6 years, 10 months ago by Shawon Chowdhury.

Viewing 6 reply threads

Author

Posts
- June 4, 2017 at 1:28 am #7499
  
  bradaks
  Participant
  
  Good day,
  
  We are LOVING WPERP and Project Manager Pro. My only issue right now is that I cannot find where to go to allow decimal placement in the Qty for orders (expenses or sales). Every time I put a decimal place in for qty, the math properly adjusts but the sql saves to 2.00 instead of 2.25. Any way you can let me know where to go to change this in my site? I have been digging around the transaction table and changed a few settings, but it will always revert back to an integer.
  
  Thanks so much!
  
  Brad
- June 4, 2017 at 11:45 am #7502
  
  Shawon Chowdhury
  Moderator
  
  @bradaks,
  
  Thanks for writing.
  Right now, WP ERP accepts integer quantities only. If you want to take decimal for quantity then you have to change the type from integer to float. That means you have to customize WP ERP core codes to achieve this actually.
  
  Feel free to inform me if you are in need of more help 🙂
- June 4, 2017 at 7:46 pm #7507
  
  bradaks
  Participant
  
  I have actually changed just about EVERY “qty” reference to a float but it still saves as an int. Do you know which script specifically. I already changed the structure in the php admin interface.
  
  We need it to be a float because we want the qty to be able to read hours as well.
  
  Thanks for the response!
- June 6, 2017 at 1:25 pm #7562
  
  Lucky
  Participant
  
  @bradaks,
  Changing all the types from int to float will fix it.
- June 6, 2017 at 1:29 pm #7563
  
  Shawon Chowdhury
  Moderator
  
  @shishir,
  You got it right.
  
  @bradaks,
  Please recheck the changes you’ve made. Maybe you missed some.
  
  Thanks all 🙂
- June 7, 2017 at 10:15 pm #7605
  
  bradaks
  Participant
  
  Thank you guys so much! I was going crazy, but it turned out that one of my updates didn’t upload for some reason. Such an easy oversight, but it is all good now. We are LOVING your product. Thank you so much.
- June 8, 2017 at 12:35 pm #7621
  
  Shawon Chowdhury
  Moderator
  
  @bradaks,
  Glad to hear that you have got it fixed 🙂
Author

Posts