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.
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
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
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
thank you so much
ill download it and tell you how its goes
Regards
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
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
Here you are acting as logicstics company as well as money collector. And all money comes to your bank account and moves to your customers. So it's came into your bank and moves to them.
So you need to invoice only for $10 USD and from payments you need a little modification to record the received 50 USD and 10 will be your accountable. And 40 has to transfer to the customers account. And this customer account has to be balanced with accounts receivables. This way you can process it.
Because the money reached your bank. So you need to record it in your system. And debit it from your bank and credit it on customers account. May be with that you can retain balance of multiple payments and make the payment to your customers at one entry. Till that it will be only your bank balance. So keep the GL entries to handle it..
So, I tested the method by putting a $10 in sales for the customer. Then I input an entry to debit bank and credit customer with $40. it was a succus as in the customer balances it showed me $-40.
But now there are orders with zero amounts for the items and the fees is $10. So, I have put it $10 in sales. So, again the customer balance is coming correctly however we have remaining $10 in customers payments to allocate in the system and by doing so. we will have incorrect customer balance.
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
Please advise me on what to do.
Thank you so much for the reply
Best regards
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. How do I reconcile the $10 from the $50 and pay the client $40 without effecting my sales and purchase reports (sales = $10) and how can I show that I have to pay the client $40 as this $40 is not a sale. it is a money collected on behalf of the client which goes to my bank account and then it gets transferred to the client.
Service amount (Direct Sale invoice) = $10
Money collected from Client's Customer = $50
Money needs to be transferred to client = $40
any suggestions or guidance on to how I make these transactions after making the direct sale invoice and how I reconcile the $10 from money collected and send the rest to the client?.
Hi .
I was trying to delete or cancel the invoice from api.
But i found out that the sample code has disabled the function for demonstrating how to delete with a message that it isn't implemented or tested fully.
/* Delete is currently untested, and not implemented with standard FA
// Delete
$response = $client->delete('/modules/api/sales/' . $id, array(
'headers' => TestEnvironment::headers()
));
$this->assertEquals('200', $response->getStatusCode());
$result = $response->getBody();
$result = json_decode($result);
// List again
$response = $client->get('/modules/api/sales/', array(
'headers' => TestEnvironment::headers()
));
$this->assertEquals('200', $response->getStatusCode());
$result = $response->getBody();
$result = json_decode($result);
$count2 = count($result);
$this->assertEquals($count0, $count2);
*/
I did further study. i tried to enable the code , It gave me error for loading the class AutoFacturaCore.php.inc .. Which isn't there int he project.
I need to know if there is any update on this
Hi .
I have followed the code from Sales_Test.php as below.
// Write back
$response = $client->put('/modules/api/sales/' . $id . '/' . ST_SALESINVOICE, array(
'headers' => TestEnvironment::headers(),
'form_params' => array(
'trans_type' => ST_SALESINVOICE,
'ref' => $ref, // TODO Ideally the api would default this and return.
'comments' => 'new comments',
'order_date' => '02/03/2013',
'delivery_date' => '04/05/2013',
'cust_ref' => 'cust_ref',
'deliver_to' => 'new deliver_to',
'delivery_address' => 'new delivery_address',
'phone' => 'new phone',
'ship_via' => 'new ship_via',
'location' => 'DEF',
'freight_cost' => '0',
'customer_id' => '2',
'branch_id' => '2',
'sales_type' => '1',
'dimension_id' => '0',
'dimension2_id' => '0',
// 'items' => array(
// 0 => array(
// 'stock_id' => 'TEST_ITEM',
// 'qty' => '2',
// 'price' => '3',
// 'discount' => '0',
// 'description' => 'new description'
// )
// ),
)
));
$this->assertEquals('200', $response->getStatusCode());
$result = $response->getBody();
$result = json_decode($result);
But if you can see ITEM CODE is disabled in the sample code.
I've tried to enable this code and update invoice.
But its now working as it should be . The error is ( THIS ITEM IS ALREADY ATTACHED TO THE INVOICE ) which is correct. All i need to update this product's price or details. Which it should basically just let it update.
I did further study . I found out it it always use add_to_order() function
if (isset($info["items"])) {
foreach($info['items'] as $item) {
add_to_order($cart, $item['stock_id'], $item['qty'], $item['price'], $item['discount'], $item['description']);
}
}
So.. basically its not working . And i guess that is why item editing part was disabled in sample code.
Is there any new update for this ?
Hi . I could not found the purchase invoice api in the module ( api )
Temporary, I have made a single method ( for adding purchase invoice ) by following the code flow from dashboard page where we put supplier invoice.
I need to know is there any update for this ?
Hi.
I have an issue in saving dimension id while i am creating the customer via API
Even if I pass my dimension id following the Test code below :-
const CUSTOMER_POST_DATA = array(
'name' => 'custname',
'debtor_ref' => 'debtor_ref',
'address' => 'address',
'tax_id' => 'tax_id',
'curr_code' => 'USD',
'credit_status' => '1',
'payment_terms' => '1',
'discount' => '0',
'pymt_discount' => '0',
'credit_limit' => '1000',
'sales_type' => '1',
'notes' => 'notes',
'dimension_id' => '0',
'dimension2_id' => '0',
'inactive' => '0',
);
- It doesn't save the dimension id which i passed.
- So i did little bit study. And i found in Customers.php insert method line 114
add_customer($info['name'], $info['debtor_ref'], $info['address'], $info['tax_id'], $info['curr_code'], 0, 0, $info['credit_status'], $info['payment_terms'], $info['discount'], $info['pymt_discount'], $info['credit_limit'], $info['sales_type'], $info['notes']);
The source code is putting both dimension ids as 0,0 Hardcoded. I tried them changing with dynamic values. And it worked.
But i need to know why they are hardcoded there while they are in the given test example ?
Is there any other way to do it ?
Waiting for an answer / Regards
When making a Payment or a Deposit, The bank Amount is rounded to 2 Digits. Example:
A payment of 50.555 it is rounded to 50.560, our currency is 3 digits.
The rounding error happens only for the the (Payment or a Deposit) only
https://ibb.co/L5yYp1S Input Picture
https://ibb.co/4RRkJsJ Output Picture
can you please send me the link of the repo
i would like to download rep_cash_flow_statement-2.4.0-2.pkg
thank you
I've tried logging in but the password does not work
Also where can i download the Default2 theme ?
Regards
and thank you
Hello again Guys,
I have uploaded 3 new themes that are based on flat simple colors and flat icons from flaticons.net. They have many good icons and it is easy to color the icons before downloading.
The Default2 theme, is mirroring the Default theme, but it has gone a major update.
The Flatcolor Theme is a new theme, also with flat colors. A horizontal menu at the top and a module menu dropdown.
The third, Flatcolor2 is with a sidebar accordion menu, that can be expanded and taken away with the Menu sign above the sidebar. This could be a candidate outside the defaults.
They all need a little fine tuning but please give your comments.
Did you improve yours a bit, @kvvaradha. I also guess that @notrinos has one coming. Exiting!
The url is:
https://frontaccounting.com/fa24test
User: testing Pass: password
The testing user is only allowed to make queries.
/Joe
FrontAccounting forum → Posts by DrCard
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.