It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by DrCard
What is best way to do custom modern theming frontaccounting where style and even layout could be changed for specific pages to have pixel-perfect look similar to other systems and themes like https://puzzle.io/ and https://themeforest.net/item/vuexy-vuejs-html-laravel-admin-dashboard-template/23328599 .
Is it using the frontaccounting theming functionality or by creating APIs to create alternative frontend using modern web framework such as laravel or by modifying the core of frontaccounting?
I tried to increase the limits as you said and even set the memory limit to something big such as memory_limit = 4G or 6G which I think is way too much what if there is page leaking it might hang my server.
Anyway after increasing the limit I got 10 month to work by 11+ months doesn't work.
Can pagination be implemented with this page?
When I try query one year using the gl inquiry in my database using one of my accounts which have ~16000 transaction in 2024 the page stuck like what shown in the picture at the attachment and no result given.
How can I let FA give me the result I'm running FA in server with 8GB of ram using RHEL 9 based distro using nginx and php 8.3.
Yes, How can i get a report that shows this.
If i want to Lock the reconciled transactions in FA 2.4 How can i do it.
Regards and thank you very much for your reply
I need both ways. Some items are output and inputs.
For example, I have 100 strawberries. I will use 60 strawberries to make juice and 40 strawberries to make milkshakes.
The milkshake will require both the strawberry juice made from the 60 strawberries and the remaining 40 strawberries to be produced.
How can I lock reconciled transactions after reconciling them so no body can edit after reconciling them just like that video shows:
https://www.youtube.com/watch?v=BNGMn9Muai0
We have a manufacturing business.
is there a report that show how many Products that I can Manufacture from the current inventory based on the BOM. And If I need to produce a given amount of an item, how many more BOM Stocks I would need.
Example:
So, to Produce Item A, it would need 2 Item B and 1 Item C. So, at the moment I have 3 from Item B and I have 2 From Item C. So I need a report shows me that I can Produce 1 Item A.
Also, lets say i needed to produce 100 Item A, it would tell me that I need 197 Item B more (3 in inventory so in total 200) And 98 from Item C (2 in inventory so in total 100).
Any updates guys?
this video in attachment demonstrate the issue and the temporary fix while using default theme without select2
It seems you are using the select2 feature in every drop down. It's not core of FA. You you might modified the version of it.
So when you choose certain customers. The drop down or the items list might be directly connected to the sales price.
Or there can be the custom query which is failed to get results..
Or if any drop down or the list might be oversized. And it fails to load.
Or may be timeout. Increase the time if it.
Looks like you are a developer to modify the theme..So check those perspective.
Try something more on that to elaborate the error
Theme seems to be unrelated I tried disabling and it doesn't solve the issue.
Temporary solution is to use customer not affected by this issue and then switch to effected one and then I'm able to proceed.
Compare the DB structures of the good and erroneous instances.
Compare the file and folder permissions of the web facing files.
Try to make the unset command into two separate commands, one for each variable, preferably after checking if it exists.
Compare the php.ini files across both installations.In the file sales/sales_order_entry.php, at line 603, the unset appears as:
unset($_POST['_stock_id_edit'], $_POST['stock_id']);Wonder what the subsequent page_modified() does after the above statement that causes the error.
I tried separating unset without any success also when this issue happen page_modified() is not reached it stuck and unset and that's it.
This image in the attachment
For some customers mostly but not always customers with many transactions I can't add new item to the direct invoice and receive only
warning triangle without response to the request and leave no logs or footprint in php logs or nginx or php-fpm
https://i.ibb.co/vcWQknV/ibba.png
after debugging the issue seems to appear in the line containing
unset($_POST['_stock_id_edit'], $_POST['stock_id']);
in the function handle_new_item() while the $_POST['_stock_id_edit'], $_POST['stock_id'] are defined and I could print them with
display_error and such and also this unset() call work on some customers and didn't work on others
I tried to change my php version from 8.2 to 7.4 and it worked for while but then it stopped and never worked even when I clear the cache
I'm using nginx and php 8.2 in rocky linux 8
do anyone face same issue?
None of them until now are talking about slim 4 update
Will there be any update for Slim 4 integration with front accounting apis ?
As our servers are running with php 8.
With
https://github.com/andresamayadiaz/FrontAccountingSimpleAPI
Currently we are using 1 api package that is built with slim 2 and that is not compatible with php 8.
I am trying use this with front accounting 2.14.4.
Any solution for this.
Or alternatives
I think this bug was fixed short after the 2.4.12 release.
We have fixed some more PHP 8 bugs as well.
Vi are planning a minor release next week so hopefully you will be satisfied then.
Joe
I'm running Version 2.4.12 Build 27.08.2022
and its not fixed
I'm still facing the same problem
you can duplicate the transaction and setting that are in the pictures, you will get the same result
ill will check the next release
thanks Joe
Check the order of the entries. Looks okay except for the order.
I checked the orders and the entries but it still gives me the same problem.
I think this is a bug.
Thanks for the reply.
The journal entries that was made automatically from the sales invoice is Dr ≠ Cr
The sales invoice amount is 5.060 and there is a tax included (0.847116%)
The Journal entry here as you can see the total of Dr ≠ the total of Cr as front accounting shouldn't allow unbalanced amounts but in this transaction it did.
Look at the following:
This is our company setup:
This is the tax setup:
Display setup:
Thank you so much for the reply.
As you have done it before, do you have the changes in the files or the code that i need to modify in the debtor_ref, supp_ref and ST_CUSTOMER_SUPPLIER.
I will be very very thankful if you can provide me with the modification.
Many many thanks.
P.S I THINK FA SHOULD HAVE THIS AS AN OPTION IN SETUP
I have a supplier who is also a customer. we are buying from him products and at the same time selling him services.
so, first we bought products for $100. The balance is for the supplier is $100.
and at the same time we sell him services for $30. So, the customer balance is $30.
so at the end we should reach a conclusion that we have to pay $70 (-$100+$30).
is there a way to automate the reconciliation between customer balances and Supplier balance.
or is there a way that we can have the customer and supplier account linked with each other ?
Regards
Great! I'm now nearly Finished with the (Allocate Customer payments) Api also
just testing it to make sure it works with no problems
please tell me where you want me to push and I'm reedy
Thank you so much Mr Joe 'Allocate Customer payments' fully did the job nicely now i have to do it throw API
i have made Purchase (suppliers) & edit/delete APIs if you like i can push them in a git if you like , i have fully tested them and they are working fine
Thank you Joe for the reply
this is the entry for the $40 that is Credited to account receivable under customer account in this case KK.
as you can see we took $50 the order price is $10 USD and we Credited the customer account with $40 as in the report we have to pay $40 to the customer -$40 is showing in the report
The second order is $10 as there is no money to be collected just the order fee.
as you can see that the $10 is Debited to the customer account and the balance amount is correct.
the issue come when you go to customer payments as you can see the amount is still $10 balance on the customer
once paid the Customer balance becomes -$40 again witch is incorrect
i tried Credit note it adds to the outstanding and it still does not fix the second order Balance
so if his balance was -$40 it will become -$50 after payment it processed
Please post for me the entries if my way is incorrect to take off the $10 payment for the second order.
Thank you so much Joe
FrontAccounting forum → Posts by DrCard
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.