76

(2 replies, posted in Accounts Payable)

This solved the issue but I doubt the approach. We may even continue with this but better if we can disallow a user to add 0 quantity while updating.

By this, I mean there should not be any entry with quantity_ordered = 0 in
xx_purch_order_details table.

I do not know about if it is required. Else we surely have a workaround which is working smoothly so far. Thus it is also worth considering !

Thanks

Hi,

I encountered a scenario and reported it in Mantis.
Refer the bug here
http://mantis.frontaccounting.com/view.php?id=183

1. Entered a PO for item A (Single Line) - Quantity - 100
2. Modified the PO and set item quantity to 0 (Single item line with order quantity 0)
3. Again updated the PO and set quantity for item to - 50

Then while receiving the delivery, a false message is encountered which is not going.

This order has been changed or invoiced since this delivery was started to be actioned. Processing halted. To enter a delivery against this purchase order, it must be re-selected and re-read again to update the changes made by the other user.

What went wrong -
Step 2 should not have been accepted in first place !) One should be forced to cancel order in such case !

I check the procedure function check_po_changed() from purchasing/po_receive_items.php

The reason of the error was due to abovesaid modifications
xx_purch_order_details table has 2 entries for same item 1 with quantity_ordered = 0 and other with quantity_ordered = 50

This resulted in mismatch in function check_po_changed() as line with quantity_ordered = 0 was not having match in session[PO]->lines

Thus resulting in error !

A temporary work around applied -

In function check_po_changed()

    $sql = "SELECT item_code, quantity_ordered, quantity_received, qty_invoiced
        FROM ".TB_PREF."purch_order_details
        WHERE order_no=".db_escape($_SESSION['PO']->order_no)
        ." ORDER BY po_detail_item";

is changed to

    // Chaitanya 18-Dec-09 Consider only quantity_ordered != 0
    $sql = "SELECT item_code, quantity_ordered, quantity_received, qty_invoiced
        FROM ".TB_PREF."purch_order_details
        WHERE order_no=".db_escape($_SESSION['PO']->order_no)
        ." and quantity_ordered != 0 ORDER BY po_detail_item";

This solved the issue but I doubt the approach. We may even continue with this but better if we can disallow a user to add 0 quantity while updating.

We may need to recheck - function handle_update_item() and function check_data()
You are best judge to decide on the exact changes required.

Thanks

78

(7 replies, posted in Setup)

Hi Pete and Guys

Don't forget you need never see Training Company if your user profile is set to use a certain company as the default - it can just hang around in the background.

How do we set user profile like that ?

Thanks,

79

(2 replies, posted in Reporting)

Hi,

In error log file, this error is found multiple times.

0:admin:tcpdf.php:6238: extract() [<a href='function.extract'>function.extract</a>]: First argument should be an array
[18-Dec-2009 10:49:36]

Could you please help to diagnose and correct this ?

Thanks,

I have tested this. It works nicely and very helpful for case mentioned above.

Thanks

81

(9 replies, posted in Setup)

Hi Joe,

I could not find a way to turn on the SSL.
Please advice.

Thanks,

82

(40 replies, posted in Report Bugs here)

Thanks, This resolved the issue.

83

(40 replies, posted in Report Bugs here)

Hi,

I had also experienced similar issue while creating direct invoice.
When I key in delayed i.e. credit invoice all looks fine but if I try cash invoice.

The error "Cannot retrieve exchange rate for currency as of 12/02/2009. Please add exchange rate manually on Exchange Rates page". is appearing.
I am using single currency.

Thanks

84

(7 replies, posted in Items and Inventory)

Hi Janusz,

Yes, agreed that it is a big task.But batch production is a common need.
Generally almost all food and drugs are batch items and there are number of categories which need stock control.
So the interested group may be larger. Can we start off with batches at least ?
Please let me know, if I can be of any help.

Thanks,

85

(7 replies, posted in Items and Inventory)

Hi,

Is it possible to have stock control implemented in FA ?

Thanks

86

(12 replies, posted in Accounts Receivable)

Hi Tom,

This module is useful for me. Could you please share it if you have completed it ?

Thanks

87

(3 replies, posted in Dimensions)

Hi Joe,

Thanks for your reply. I need your advice here. The need is -

1. System had 4 levels of locations. Say, HO, Sub Level 1, Sub Level 2, Sub Level 3 locations hierarchically.
2. There are users from all levels. Each user can make accounting entry for his own level and can access reports of own and sub levels.
3. This needs to be designed for accounting.

So, I was wondering how can we design/find solution to integrate this scenario.

Thanks,

88

(12 replies, posted in Accounts Receivable)

Hi Tom,

Just a query, Is this stuff ready ?
I am interested in it.

Thanks

89

(3 replies, posted in Dimensions)

Hi Joe,

When we say we can use dimension for setting up cost-centre inside department inside company. Does this mean we can set hierarchy or we have to manually take care that cost centre from one department is not selected in other department.

Thanks

Hi Joe,

I could find easy fix for issue mentioned above.
I changed line no 309

        stock_purchasable_items_list_cells(null, 'stock_id', null, false, false, true);

to

        stock_purchasable_items_list_cells(null, 'stock_id', null, false, true, true);

It is under purchasing/includes/ui/po_ui.inc  in function po_item_controls

It enabled the Ajax trigger on combo change thus reflecting properly.

Thanks

Hi Joe,

Thanks for the clarity. But the issue here is -

Say we have a supplier ABC and 2 items with rates 100, 150 resp.
When we change item1 to item2 from item list, the prices are not changing from 100 to 150.

In short, The changing the purchase item in item table is not changing the item rate.
The Ajax effect is not getting triggered.

Could you please check if this is an issue or I am getting it in wrong way ?

Thanks

Hi Joe,

I checked the online version 2.2 stable. But the change in the purchase item (on Purchase Order Entry) is not changing the item rate. Thus conversion factor is not reflecting.

Thanks

93

(4 replies, posted in Accounts Receivable)

ok, this can be a good work around...

Thanks

94

(4 replies, posted in Accounts Receivable)

Hi Joe,

Debit note may be different than invoice itself.
Debit Note is issues in some cases like
1. Difference of rates settled post invoice.
2. To apply just extra changes to customer like Transport insurance etc. it does not involve any item sale.

Thanks

Hi,

I support this. We have facility to classify the GLs in groups, subgroups, types and tags but reporting is not possible.

Can anyone help with this ? I think this is a common need so many people may have got this developed in some or other way...

Thanks

96

(17 replies, posted in Setup)

Hi

I observed that FA has release version 2.2 stable. Thanks for new release.
I think it would be better if we can support customer login.

This functionality would need
1. Linking user account to customer. (Needs db change.)
2. Restricting customer to enter only few transactions (can be easily done by setup->access setup)
3. Customer should be able to enter transactions only for own account.

I have modified the code in order to provide all of the above features.
If moderators see any value addition in this proposal, I would be happy to share code for review.

Thanks

97

(1 replies, posted in Setup)

Hi,

I have entered a JV with certain reference number and later on I made it void.
Then I have to reenter the JV with "SAME" reference as that of voided one. I was not allowed to do so?

Is there any functional reason for this behavior ?
In case of wrong entry of say, payment I have to void the transaction and reenter it with same reference number.

Edit functionality would have helped a lot but till the time we may need to have same reference number for voided transactions.

P.S. - As I am new to FA, excuse me I have got things wrong in operational and functional sense. smile

Thanks,

Hi Joe,

I observed that in Demo of FA 2.2RC Bank reconciliation is not working as expected.
in online demo of 2.1.7 it is working fine.

Could you please take a look and help to resolve this ?

Thanks

Hi,

Could you please help me to understand how FA implements 'Simple POS functionality'?

This feature is mentioned in post -
https://frontaccounting.com/punbb/viewtopic.php?id=495

But unfortunately, I am not able to find out what this feature caters.
Also I have a query that user account setup screen mentions - User's POS

How does this field is used in FA?
Could you please guide me to get maximum output from FA ?

With Regards,

Hi,

As I see in RC2.2 release we have got account tags and dimension tags but I am finding difficulties in searching a place to pull report based on these tags. Major one is - Account Tags.

Could you please help me out here ?

With Regards,