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.

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%)

https://ibb.co/6JCLX9k

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:

https://ibb.co/kB0tDwV

This is our company setup:

https://ibb.co/fpF4sjL

This is the tax setup:

https://ibb.co/L08LSKs

Display setup:

https://ibb.co/R3PN5j3

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.

https://ibb.co/cX1wBMY

and at the same time we sell him services for $30. So, the customer balance is $30.

https://ibb.co/hFVkNpr

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.

https://ibb.co/BZkBJkH

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

https://ibb.co/TqtfCH7

The second order is $10 as there is no money to be collected just the order fee.

https://ibb.co/02wC8bJ

as you can see that the $10 is Debited to the customer account and the balance amount is correct.

https://ibb.co/FW9kcmK

the issue come when you go to customer payments as you can see the amount is still $10 balance on the customer

https://ibb.co/tKTwnNS

once paid the Customer balance becomes -$40 again witch is incorrect

https://ibb.co/h1cctLC

i tried Credit note it adds to the outstanding and it still does not fix the second order Balance

https://ibb.co/BVTPhtc

so if his balance was -$40 it will become -$50 after payment it processed

https://ibb.co/sWZVZdR

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

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.

https://ibb.co/qmx5wdr

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.

https://ibb.co/c38W80G

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.

https://ibb.co/ZMg8PJM

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

kvvaradha wrote:

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 ?

41

(1 replies, posted in Report Bugs here)

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

joe wrote:

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