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 ?

34

(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