416 Commits

Author SHA1 Message Date
FrancescoUK
0c2c999746 Minor improvement 2018-06-03 16:39:40 +01:00
FrancescoUK
b13ac8d4f0 Fix Summary report table header (#1972) 2018-05-12 20:34:27 +01:00
FrancescoUK
5f0d8b2312 Add extra payment combinations (#1982) 2018-05-12 17:21:18 +01:00
FrancescoUK
4558cf0e50 Add spaces to SQL statement 2018-05-12 13:42:47 +01:00
truchosky
507294a4a6 temporary "fix" to wrong summary_payment report
I still cant find a solution to this,  summary payment in cash is wrong, like you know it considers payment ammount and it doesnt discount change, so the cash payment will be always a higher value, and if you try to discount change directly on query then it only discounts sales with 1 item, and not discounts sales with multiple items, the condition sales_items.line = 1 cause that.

This change considers item price * item qty, so at lest summary payment in cash will be acurated no matter tendered ammount  but leaves out "due sales"
2018-05-11 21:48:52 -03:00
truchosky
1acac824a1 Missing Payment Count 2018-05-06 00:26:19 -03:00
FrancescoUK
bcd1b05961 Fix customer import issue and complete anonymisation (#1949) 2018-04-30 21:28:32 +01:00
FrancescoUK
fdbdf55e71 Better Customer data privacy protection (#1949) 2018-04-29 14:13:00 +01:00
FrancescoUK
3e9e144075 Fix subtle error with Stock location SQL query 2018-04-29 10:38:38 +01:00
FrancescoUK
c8d1bfee35 Fix Expense amount and tax amount update issue (#1955) 2018-04-24 20:39:41 +01:00
Steve Ireland
cdd966878d Various fixes for the item kit feature. 2018-04-21 17:46:39 -04:00
FrancescoUK
4bab3fc4e3 Code style adjustments 2018-04-14 14:40:02 +01:00
FrancescoUK
5c1baf20b0 Improve get_found_rows query performance (#1940) 2018-04-13 19:54:22 +01:00
FrancescoUK
075d4e1aeb Improve get_found_rows query performance (#1940) 2018-04-12 22:42:56 +01:00
FrancescoUK
9e2a757b16 Fix over counting of totals (#1896) 2018-03-25 21:44:11 +01:00
FrancescoUK
4079e44572 Allow password change with no restrictions + code reorg (#1894) 2018-03-25 19:18:03 +01:00
FrancescoUK
a7ecec4bd3 Small code refactoring (#1896) 2018-03-25 14:39:52 +01:00
FrancescoUK
ae472d0176 Print reports date in different formats, remove sorting (#1896) 2018-03-25 13:57:20 +01:00
FrancescoUK
bf76450ca5 Fix Summary_payments report location (#1896) 2018-03-24 18:32:02 +00:00
odiea
3368c62690 Update Specific_customer.php 2018-03-20 12:07:45 -06:00
FrancescoUK
b84d9d894f Fix Summary Takings including not completed transactions (#1886) 2018-03-16 19:56:56 +00:00
FrancescoUK
7525c650ab Total Inv. Retail Price & Quantity 2018-03-04 17:02:21 +00:00
odiea
022dfea51a Update Specific_customer.php 2018-02-15 23:46:12 +01:00
odiea
58e8469dde Added filters to customer 2018-02-15 23:46:12 +01:00
odiea
49d60313f6 Update Detailed Reports. Add payment type to Specific Customer. 2018-02-15 23:46:12 +01:00
Steve Ireland
2258938604 More missing language elements and one bad reference to a config value. 2018-02-11 20:09:24 -05:00
Steve Ireland
7a55c2311e More missing language elements and one bad reference to a config value. 2018-01-11 00:07:22 +01:00
Steve Ireland
62f34663ae Provide a way to enter a line total and have the quantity sold automatically calculated. 2017-12-31 16:22:04 -05:00
FrancescoUK
2a306b888f Fix discount detail report (#1736) 2017-12-31 14:29:51 +00:00
FrancescoUK
a7d7cbe43c Fix clash of item_id and item_number (Barcode) (#1747) 2017-12-23 21:20:48 +00:00
FrancescoUK
c96c2a69a6 Fix Reports and few other minor things 2017-12-12 20:58:36 +00:00
FrancescoUK
a08826e909 Add extra Expense fields (#1235) 2017-12-11 17:28:42 +00:00
odiea
d3cb3b7f87 Added Company search to Customer and Sales 2017-11-30 16:07:01 -07:00
FrancescoUK
b058e91a99 Fix code indentation issues 2017-11-27 20:52:46 +00:00
FrancescoUK
2cde603949 Add Expenses support (#1235) 2017-11-26 20:45:57 +00:00
Steve Ireland
64c2996c74 Improve the ability to restore canceled sales. 2017-11-25 21:38:00 +00:00
Steve Ireland
2f221004fb Correct issues with renaming stock locations 2017-10-28 19:57:36 -04:00
FrancescoUK
37ed01ed3e Move Office Icons to the right (#1624) 2017-10-13 20:17:38 +01:00
objecttothis
79d5bc9156 Correcting Round-up and Round-down bug
Former code ignored precision and just rounded up or down to the nearest integer.  This code rounds up or down to the precision in cash decimals.
2017-09-19 16:28:40 +04:00
FrancescoUK
39dbd9af52 Small code refactoring 2017-09-17 15:17:48 +01:00
Steve Ireland
d63446cdb8 Suspending Work Order lost work order number 2017-09-17 09:24:52 -04:00
FrancescoUK
7789675a55 Merge branch 'RuleDomain-fix-item-kit-cost' (#1580 #1595)
# Please enter a commit message to explain why this merge is necessary,
# especially if it merges an updated upstream into a topic branch.
#
# Lines starting with '#' will be ignored, and an empty message aborts
# the commit.
2017-09-16 20:46:12 +01:00
Steve Ireland
729283af37 Add support for item kit costing 2017-09-16 11:39:03 -04:00
FrancescoUK
6144902cc1 Fix PHP 5.6 incompatibility (#1580) 2017-09-15 09:36:25 +01:00
objecttothis
372c3ab6bf Disables unique check and fixes return
- If allow duplicate barcodes is enabled then this function automatically returns FALSE allowing item imports and new items to no longer balk.
- Modified the code to return TRUE not only when there is 1 row but when there are one or more rows.  This will fix problems with users that allow duplicate barcodes and who upgraded from older versions before unique barcode was required.
2017-09-13 09:11:32 +01:00
objecttothis
67cace93c7 allow custom format in receivings as well 2017-09-13 08:55:54 +01:00
objecttothis
6e82602a47 Allow custom suggestions format
This changes the display of the search suggestions to match the format set by the user in app_config.  It does not change the logic of how the search suggestions are gathered.
2017-09-13 08:55:54 +01:00
Steve Ireland
e85e2e5e55 Final touch on Work Orders 2017-09-09 17:39:23 -04:00
Steve Ireland
771c1b9d1e Enance reporting to accomodate work orders and canceled transactions. 2017-09-08 08:54:25 -04:00
Steve Ireland
981aceda53 Add support for Work Orders 2017-09-07 21:37:50 +01:00