@samsa in this theme you have included the idea of @notrinos? To have dashboard modularized?
152 06/18/2020 11:51:22 am
Re: Modularizing the Dashboard (82 replies, posted in FA Modifications)
Once you become Senior Member you will be granted that privilege automatically. That requires a good number of posts in the forum 
153 06/16/2020 06:19:37 pm
Re: Modularizing the Dashboard (82 replies, posted in FA Modifications)
you can upload the screen shot to imgur.com and share the link here
154 06/14/2020 02:57:54 am
Re: How to Add Petty Cash Account in the DropDown Payment/Deposit process (6 replies, posted in Banking and General Ledger)
I have written a module for Cash Transactions. This creates a new Transaction Type Cash Payment and Cash Deposit.
I don't remember if for this I made some core changes. Just give a try. May be this solves your problem.
155 06/12/2020 11:26:12 am
Re: Sales Order Inquiry -- Wrong Figure (7 replies, posted in Accounts Receivable)
Fix is here.
Change the lines of the function get_sql_for_sales_order_view() as follows
function get_sql_for_sales_orders_view($trans_type, $trans_no, $filter,
$stock_item='', $from='', $to='', $ref='', $location=ALL_TEXT, $customer_id=ALL_TEXT)
{
if ($filter=='OutstandingOnly')
$order_value = 'Sum(line.unit_price*(line.quantity-line.qty_sent)*(1-line.discount_percent))+freight_cost AS OrderValue,';
else
$order_value = 'Sum(line.unit_price*line.quantity*(1-line.discount_percent))+freight_cost AS OrderValue,';
$sql = "SELECT
sorder.order_no,
sorder.reference,
debtor.name,
branch.br_name,"
.($filter=='InvoiceTemplates'
|| $filter=='DeliveryTemplates' ?
"sorder.comments, " : "sorder.customer_ref, ")
."sorder.ord_date,
sorder.delivery_date,
sorder.deliver_to,
$order_value
sorder.type,
debtor.curr_code,
Sum(line.qty_sent) AS TotDelivered,
Sum(line.quantity) AS TotQuantity,
Sum(line.invoiced) AS TotInvoiced,
alloc,
prep_amount,
allocs.ord_payments,
inv.inv_payments,
sorder.total,
sorder.trans_type156 06/11/2020 07:18:15 am
Re: Sales Order Inquiry -- Wrong Figure (7 replies, posted in Accounts Receivable)
No, If we go through Menu Sales Order Inquiry then it shows Order Total.
But if we go through Menu Delivery Against Sales Order then it is supposed to show the Total of Outstanding.
In the above case I mentioned Delivery Against Sales Order is not showing the Total of Outstanding correctly.
The Order was big and all items are fully delivered except for one that I highlighted.
The system shall show the Total Outstanding as 90,000 (5 * 18000) but it is showing 108,000 (6 * 18,000).
Regards.
157 06/10/2020 12:14:48 pm
Topic: Sales Order Inquiry -- Wrong Figure (7 replies, posted in Accounts Receivable)
When we check the Delivery Against Sales Order Inquiry View, it shows the Order Total Value for the Value of the order that is still not delivered. But there is still an anomaly there.
In the attached image you can find that there was big order and all delivered except for one item.
That items total value in the order is 108,000.
Undelivered is 5 out of 6.
The inquiry page shall show the amount 90,000 but it is showing 108,000.
If this is a bug then need a fix. Or if I am mis interpreting it then please let me know.
158 05/13/2020 10:35:21 am
Topic: [Solved] Line Endings Issue (1 replies, posted in Development)
Dear All,
My last two days were too hectic. My FA was not exporting the reports in Excel Properly. No Error was shown. I was unable to locate the issue. I had one month old backup that has no issue. I compared both and found an issue that one of latest module's hooks.php file was not having LF line endings.
I found this Swiss File Knife Tool helpful to check in bulk and convert the whole projects Line Endings to LF.
Since I am using Linux server so I needed LF.
This Post is also helpful https://stackoverflow.com/a/16886243
Once installed the above tool. Open the Project Directory in Command Prompt and write the below command
> sfk remcr -dir your_project_directory -yes
159 05/10/2020 08:59:48 pm
Topic: PHP 7.4 bug (20 replies, posted in Report Bugs here)
Unparenthesized `a ? b : c ? d : e` is deprecated. Use either `(a ? b : c) ? d : e` or `a ? b : (c ? d : e)` in file: gl/includes/db/gl_db_trans.inc at line 464
160 04/21/2020 06:51:38 am
Re: Interest in Magento Integration or Shopify Integration (5 replies, posted in Modules Add-on's)
@bkort, yes you can sell it commercially. Since FA has no marketplace so you make a free version and then paid version. Free users can then migrate to paid one.
Free version can then be made available at FA forum.
Can you do the same for WooCommerce? I have few clients who may be interested in that.
161 04/17/2020 06:32:42 pm
Topic: Edit Multiple Bank Payments in Multiple Tabs (0 replies, posted in Banking and General Ledger)
I just want to give a bundle of thanks to @BraathWate for his work in this commit that has solved a great problem for me.
Hats off for you @Braath.
162 03/22/2020 10:46:16 am
Re: The Header option from module itself (19 replies, posted in Modules Add-on's)
can u provide a sample template to test?
163 03/22/2020 10:37:15 am
Re: Added Functionality to Manufacture Multiple Products with One WO (6 replies, posted in Manufactoring)
hello I am travelling now so couldn't check earlier. I will send you the demo soon once reached.
164 02/24/2020 06:50:04 pm
Re: Data Migration from Another Accounting Software (6 replies, posted in Jobs wanted/offered, non-free offers)
This is the modified import_items that takes care of opening stock.
165 01/22/2020 03:40:37 am
Re: Theme with chat (7 replies, posted in Wish List)
you can use tawk.to. Its totally free and can be easily integrated in FA theme. Just add the JavaScript code you get from tawk.to on includes/page/footer.inc before the last line.
166 01/14/2020 05:09:01 pm
Re: System being logged out (7 replies, posted in Accounts Receivable)
I have debugged the issue in detail and found that calling the below function is making the system being logout.
function regenerateSession()
When in one session.inc call the above function is called and regenerates the new session id
On the next call when
function validateSession() is called it returns false on following condition
if (isset($_SESSION['EXPIRES']) && $_SESSION['EXPIRES'] < time()) {
return false;
}
Any idea? Why regenerate is important? and this condition is failing?
167 01/05/2020 03:56:22 am
Re: GL Account Transactions (1 replies, posted in Reporting)
You need to modify the report rep704.php
168 01/04/2020 04:02:29 am
Re: Direct Invoice Issue (2 replies, posted in Items and Inventory)
Probably in Company Setup >> User Interface Options >> Search Item List is checked.
169 01/04/2020 04:00:04 am
Re: One domain's database on another domain (1 replies, posted in Setup)
FA has nothing to do with domain. If the table prefix is same on both domains then you can restore it.
170 01/02/2020 06:01:47 am
Re: The Future of FrontAccounting (6 replies, posted in Development)
What about Future of FrontAccounting? Long awaited 2.5 is taking time I think due to work load with Jansuz. Are you still with the plan to get further developers involved.
171 01/01/2020 11:03:00 am
Topic: Amendment Required in rep601.php (1 replies, posted in Reporting)
On Line # 50 Please add following code
AND amount != 0
Otherwise all voided transactions are shown in Bank STatement.
172 12/20/2019 12:34:39 pm
Re: Server Being Crashed (3 replies, posted in Installation)
2 Core Server with 4 GB RAM, Debian Linux, DigitalOcean
173 12/19/2019 12:40:11 pm
Re: Modularizing the Dashboard (82 replies, posted in FA Modifications)
Ok, your explanation given in Post#10 is enough to create a sample module. Except nothing should be done in dashboards folder instead reporting folder shall be used in module to create the file custom_dashboards.php.
Thanks for this great feature.
174 12/19/2019 10:10:40 am
Topic: Server Being Crashed (3 replies, posted in Installation)
I have checked the Logs of my server when It Crashes as CPU Usage reaches 100%.
I found few core pages and my module pages with a query string /modules/container/containers.php?JsHttpRequest=0-xml
Is this an Ajax Call?
This is a simple Page to add Containers against Jobs (Dimensions).
This client have more than 3000 open Jobs (Dimensions).
Is this Ajax Call taking so much resources is due to the Dimensions Being Loaded in the Drop Down List?
Or there is any other reason for this resource consumption.
@All Gurus please guide me.
Regards.
175 12/19/2019 09:31:08 am
Re: Modularizing the Dashboard (82 replies, posted in FA Modifications)
Hello @notrinos I am working on this dashboard system. In Post # 19 you have given a link of Sample Dashboard Module. That link is not working. Can you share that sample again.
Regards.