search

siamon123 / warehouse-inventory-system

Open source inventory management system with php and mysql
http://www.oswapp.com
MIT License
379 stars 233 forks source link

Hi I love this Inventory but having issues #22

Open mrboyenrey opened 6 years ago

mrboyenrey commented 6 years ago

Generate Sales Report is Having Issues. Hoping this will be fixed because I need this software in my shop.

It has this issues Notice: Undefined variable: profit in C:\xampp\htdocs\WIS\includes\functions.php on line 83

Cannot Generate Sales Report :(

AbhisheKundalia commented 6 years ago

This is because there is no sales entry...So meanwhile you can use it after adding sales entry

mrboyenrey commented 6 years ago

ahh I see, okay, thanks for the info.

On Mon, Aug 14, 2017 at 11:50 PM, Abhishek Kundalia < notifications@github.com> wrote:

This is because there is no sales entry...So meanwhile you can use it after adding sales entry

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/siamon123/warehouse-inventory-system/issues/22#issuecomment-322228463, or mute the thread https://github.com/notifications/unsubscribe-auth/AIc0Q04Cxira00bMmU19kG3yjvpQHcvuks5sYGzLgaJpZM4OrgQU .

--

Boien Reyes Graphic Artist Techmanswork

This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.

nathanzky commented 6 years ago

After adding a sales entry I try to generate a sales report but I have this error: Error on this Query : SELECT s.qty, DATE_FORMAT(s.date, '%Y-%m-%e') AS date,p.name,SUM(p.sale_price * s.qty) AS total_saleing_price FROM sales s LEFT JOIN products p ON s.product_id = p.id WHERE DATE_FORMAT(s.date, '%Y-%m' ) = '2018-01' GROUP BY DATE_FORMAT( s.date, '%e' ),s.product_id

johnny1cr commented 4 years ago

After adding a sales entry I try to generate a sales report but I have this error: Error on this Query : SELECT s.qty, DATE_FORMAT(s.date, '%Y-%m-%e') AS date,p.name,SUM(p.sale_price * s.qty) AS total_saleing_price FROM sales s LEFT JOIN products p ON s.product_id = p.id WHERE DATE_FORMAT(s.date, '%Y-%m' ) = '2018-01' GROUP BY DATE_FORMAT( s.date, '%e' ),s.product_id

You solve this ?