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 ?

30

(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