Yes, How can i get a report that shows this.
1 07/24/2024 09:43:01 am
Re: BOM Inventory Requirement Report and Production Feasibility (5 replies, posted in Reporting)
2 07/24/2024 09:40:57 am
Re: lock reconciliation edit from journal entry (3 replies, posted in Banking and General Ledger)
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
3 07/14/2024 10:49:26 am
Re: BOM Inventory Requirement Report and Production Feasibility (5 replies, posted in Reporting)
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.
4 07/14/2024 10:32:11 am
Topic: lock reconciliation edit from journal entry (3 replies, posted in Banking and General Ledger)
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
5 06/26/2024 08:38:57 am
Topic: BOM Inventory Requirement Report and Production Feasibility (5 replies, posted in Reporting)
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).
6 05/14/2024 10:09:50 am
Re: Can't Add Direct Invoice Item for some customers (8 replies, posted in Report Bugs here)
Any updates guys?
7 04/08/2024 09:25:37 am
Re: Can't Add Direct Invoice Item for some customers (8 replies, posted in Report Bugs here)
this video in attachment demonstrate the issue and the temporary fix while using default theme without select2
8 04/08/2024 08:20:16 am
Re: Can't Add Direct Invoice Item for some customers (8 replies, posted in Report Bugs here)
kvvaradha wrote:
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.
9 04/08/2024 08:16:37 am
Re: Can't Add Direct Invoice Item for some customers (8 replies, posted in Report Bugs here)
apmuthu wrote:
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.
10 04/07/2024 07:31:37 am
Re: Can't Add Direct Invoice Item for some customers (8 replies, posted in Report Bugs here)
This image in the attachment
11 04/06/2024 01:36:13 pm
Topic: Can't Add Direct Invoice Item for some customers (8 replies, posted in Report Bugs here)
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?
12 04/10/2023 01:45:32 am
Re: Slim 4 API for third party apps integration (3 replies, posted in Modules/Add-on's)
None of them until now are talking about slim 4 update
13 12/15/2022 11:52:12 am
Topic: Slim 4 API for third party apps integration (3 replies, posted in Modules/Add-on's)
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
14 09/07/2022 10:46:15 am
Re: Incorrect Journal Balance (sales invoice) (6 replies, posted in Report Bugs here)
joe wrote:
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
15 09/06/2022 11:31:51 am
Re: Incorrect Journal Balance (sales invoice) (6 replies, posted in Report Bugs here)
apmuthu wrote:
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.
16 01/13/2022 02:56:08 pm
Topic: Incorrect Journal Balance (sales invoice) (6 replies, posted in Report Bugs here)
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:
17 11/18/2021 11:42:41 am
Re: my customer is my supplier (7 replies, posted in Banking and General Ledger)
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
18 11/16/2021 02:33:09 pm
Topic: my customer is my supplier (7 replies, posted in Banking and General Ledger)
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
19 11/04/2021 02:53:30 pm
Re: incorrect customer balance after Cash collection transactions (12 replies, posted in Report Bugs here)
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
20 11/04/2021 09:36:15 am
Re: incorrect customer balance after Cash collection transactions (12 replies, posted in Report Bugs here)
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
21 11/03/2021 03:40:22 pm
Re: incorrect customer balance after Cash collection transactions (12 replies, posted in Report Bugs here)
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
22 11/03/2021 09:21:05 am
Re: incorrect customer balance after Cash collection transactions (12 replies, posted in Report Bugs here)
joe wrote:
This bug is related to Mantis Bug 5510 on Mantis. Fixed a couple of days ago.
Please download /sales/includes/db/custalloc_db.inc here.
And please download /reporting/rep108.php here.Replace the files and you should be running ok.
Joe
Still same issue
this is what i did
First Order Amount to be collected $50 from end customer. Fees $10.
Direct Invoice -> made an invoice of $10. Payment terms -> due within 10 days.
input an address and I have -> placed invoice.
Sales -> Customer Payments. This allocation which is for invoice -> All -> Add Payment
Banking and General Ledger -> Journal Entry -> Account : Checking account Dr. 40 -> Add Item -> Account: Account receivable -> Counter Party (Customer) -> Cr. 40 -> Process Journal Entry.
Second Order No Amounts to be collected from end customer. Fees $10.
Direct Invoice -> made an invoice of $10. Payment terms -> due within 10 days.
input an address and I have -> placed invoice.
Before second payment the Customer balance Report is correct but the payment is still outstanding in sales> customer payments.
So, if I want to clear this payment (second payment) the customer balance report will become incorrect. it should reconcile with the customer balance from the beginning which is the $40 that is in the customer account. As in with the customer balance report it becomes $ -30 and the payment is still pending.
If I do the payment, the balance changes back to $ -40.
so the bug is still there
Regards
23 11/02/2021 04:38:09 am
Re: incorrect customer balance after Cash collection transactions (12 replies, posted in Report Bugs here)
thank you so much
ill download it and tell you how its goes
Regards
24 11/01/2021 08:14:32 pm
Topic: incorrect customer balance after Cash collection transactions (12 replies, posted in Report Bugs here)
Main Post here
https://frontaccounting.com/punbb/viewt … 192#p40192
I run a delivery service which is collecting money from customers, I charge my clients 10$, the clients charge his customers $50 for the items being delivered by my company.
I invoice the client $10 and I have $50 cash in hand which will be deposited in my bank account. I reconcile the $10 from the $50 and pay the client $40 however we have remaining $10 in customers payments to allocate in the system and by doing so. we will have incorrect customer balance.
*how the we did the entry's
Direct Invoice the $10 then Receive the $50 ...Go
Banking and General Ledger ->Journal Entry
Journal Date Account Code Account Name Debit Credit Memo
01/11/2021 1060 Checking Account 50.00
01/11/2021 1200 00001 Accounts Receivables: Donald Easter 10.00
01/11/2021 2100 00001 Accounts Payable: Dino Saurius 40.00
Total 50.00 50.00
Before second Payment
https://ibb.co/b5LpQvK customer balance correct
https://ibb.co/pWNyS5g remaining for the customer to pay (shouldn't be anything left)
After second Payment
https://ibb.co/4gyd4SR customer Balance Incorrect
as kvvaradha said we need to fix the code
any suggestion or help in how to fix this bug
25 11/01/2021 02:42:11 pm
Re: Cash collection transactions (5 replies, posted in Banking and General Ledger)
Thank you so much for the fast reply
Please tell me which are the files that needs to be modified and I will do the needed adjustments to the code and post them for you after testing them.
i will also post this in the Bug section
https://frontaccounting.com/punbb/viewt … 193#p40193
Best regards