My FA site is running in the 2.3.22 version and I will need professional assistance to update to the latest version.

My site has done some customizations (done through paid programmers) that I would like to retain after the update.
And certainly I do not want the update process impacts my company's daily operation.

If anyone with experience is interested, please kindly PM me.
It will be good if you can let me know your relevant experience in the past and your price range.

If this project goes well, there are other customizations would like to make to our site. Thank you.

@apmuthu can you help? Thank you.

Anyone who can advise which codes I should look into for this issue? Much appreciated.

Sales Order / Delivery Note - quantity stays at zero (FA 2.3.22)

We have this issue too now which didn't happen to us in the past years. For a number of products, when we input Delivery note, no matter what quantity we input, it will become zero. Then we will have to edit the line again to update the quantity. This is causing a lot of trouble as we will have to input 2 times to make the quantity right.

This position after input on DN always come as zero "null" quantities. It doesn't happen to all products but only some (not a few) products.

What should we do to fix this? Thank you very much.

We have this issue too now which didn't happen to us in the past years. For a number of products, when we input Delivery note, no matter what quantity we input, it will become zero. Then we will have to edit the line again to update the quantity. This is causing a lot of trouble as we will have to input 2 times to make the quantity right.

This position after input on DN always come as zero "null" quantities. What should we do to fix this? Thank you.

6

(5 replies, posted in Installation)

Thanks apmuthu. Actually my main issue with our current FA version (2.3.2) is we have not been able to 'Print Invoices' from the Reports and Analysis tab. I always get the orange triangle after roughly 10 seconds loading time. It may be because our database is too large. I hope that by upgrading to the latest FA version the issue could be resolved.

7

(5 replies, posted in Installation)

Dear Sir / Madam,

My company is currently running on FA 2.3.2 and we have made some customization in the system.

(The customization being we built an online shop that is connected to the FA so any order placed on the online shop are entered into FA as a new sale order automatically)

We would like to upgrade our FA version to the latest (now I believe is 2.4.7) so to improve stability and enjoy the new functionalities.

Can I ask for advice here on how we could upgrade the system without impacting the customization we have done on our FA? Thank you.

Our company have been using FA as the inventory and invoice management system. Our current process is our sale team place orders in FA after receiving orders from clients through email or phone call. We are looking for someone who can help build a web based tool for our clients to place orders directly by themselves and the orders will automatically be placed in our FA system.

Requirements are as follows:

1. The interface must be user friendly for our clients so we can encourage them to place orders through there

2. Orders placed through the web ordering tool will be created as sale orders in our usual FA system. The corresponding coverage sale person should get notified and then review the sald order. The sale person should be able to amend the sale order - edit price/quantity, delete or add items. After review, the sale person can confirm the order and issue delivery note and invoice as usual.

3. Each client should have an unique login to the web ordering tool. Under each login, we will need to have an unique price list of various items. We have over a thousand items on shelf. The corresponding sale person should be able to amend the price list at any time

4. The web tool should support multiple languages (at least 2 languages for now)

5. Clients should be able to create their own profile under their own login credentials - including company details, default delivery address, alternative delivery addresses, contact numbers etc. Sale team should be able to add/update these details at the back end too

6. The web tool doesn't need any payment gateway. No payment is required at the point of placing order on this web tool as clients will pay us separately through the usual external channels

These are the primary requirements. We look forward to receiving offers from the experienced FA programmers here

Hi everyone,

I would like to add horizontal line (or border) to separate the items one by one on Delivery Note. I believe i should update the PHP code in rep110.php. However I am not sure which line i should update and if it is possible. It will be much appreciated if anyone of you can advise me how to do this. Thank you.

I understand that in Forms Set Up, if you set a number format for Next Reference, each time when you generate a new document, let's say an invoice, the Invoice Number will increase by 1 the next time.

However, we are facing the issue that we often have the situation that more than 1 user are trying to generate invoices at the same time. All users get the same assigned invoice number. And then the first user finishes the generation process earlier and his invoice can be confirmed with that invoice number. And when the second user finishes the process, he will get alerted that 'your invoice number has already been used'

This is causing us issue so we can use sequential number.

Is it possible to avoid this? Thank you.

Thanks @apmuthu. May I know in which file I should add this max_input_vars?

Thanks.

Is it possible we set a default email address for emailing delivery note?

i.e. unless we override with a dedicated email in Customer or Customer Branch setting, delivery note can be emailed to this default address when we press 'Email Delivery Note'

Thank you.

13

(13 replies, posted in Wish List)

May I know if this issue has been addressed?

I recently came across the situation that after pressing 'Email Delivery Note', it says the email successfully delivered to the designated email but the intended recipient never receives the email. Any suggestions on possible reasons or how I can check what the issues could be? Thank you.

We have been using Stock Check Sheets under Inventory Report everyday.

However, since 3 weeks ago, when I try to generate a full Stock Check Sheets under Inventory Report, it always fails (only see the circle keeps spinning and later becomes an orange exclamation mark)

However, if i generate the Stock Check Sheets one category by category, the report can be generated and the report looks perfect.

The full Stock Check Sheets used to work perfectly before. Any ideas what are causing issue and how fix this? Thank you.

Thank you.

May I know if there is any way to show 'loc_code' or 'location_name' on Delivery Note in FA v2.3.x.?

If this info is wanted on the Sales Order, how can i add after the Item Lines?

Thank you.

Besides, I have an issue with the line below shown in the Wiki

https:/sourceforge.net/p/frontaccounting/mercurial/ci/5775c5de697a059c27e3e4786aeb7b8cedc4dfdf/tree/reporting/includes/reporting.inc?diff=5932dac9045dea6cfdcf314f4d09897232b82828

$def_orientation = (user_def_print_orientation() == 1 ? 1 : 0);


The system says user_def_print_orientation() is undefined.

Thank you.

Thanks for your replies. Yes our business process requires 'Delivery from Location' shown in the Delivery Notes. Our warehouse staff pack goods based on the Delivery Notes while we store different batches of the same product model in different locations so 'Delivery from Location' must be shown in Delivery Notes so our warehouse staff can know what batches of goods to collect.

Under 'Deliveries Against Sales Orders', the Sales can select which Location the goods should be delivered from. This is what I want to show in the Delivery Notes too.

I followed all instructions at the link below:

https://frontaccounting.com/fawiki/index.php?n=Help.BinLocationsInPackingList

After the changes, however when I press the 'Print' button for Delivery Notes, the system loads for 2 seconds but no report shown. The 'Print' button for Sales Invoices and other reports work fine.

I tried removing the file company/0/reporting/rep110.php and the 'Print' button for Delivery Notes worked again. However the shown results are the same as before all the changes made.

What should I do to show 'Delivery from Location' on Delivery Notes for each item or on the overall report? Thank you.

May I know how I can add 'Delivery from Location' or 'Location Code' in Delivery Note?

Thank you.

How can I settle/close an outstanding credit note in system if the client has accepted refund from us?

Thanks.

erwindebruin wrote:

if i select multiple invoices for printing (like invoice no 1 to 1000, all single page invoices) the PDF which is generated also includes pagenumbering. By example invoice no 2 gets pagenumber 2. I think this is incorrect and the numbering as discussed in this thread should restart on each invoice again and not on the pages when bulk printing invoices.

Any solution to this situation? Appreciate anyone's help

Strange thing happened.

With the new rep107.php file, the function under 'Customer and Sales Reports' --> 'Print Invoices' works well.
However, if I go to 'Sales' --> 'Customer Transaction Inquiry' and then print individual invoice there, I get blank page.

I replaced with the old rep107.php file and then printing in 'Customer Transaction Inquiry' returns normal.

With the new rep113.php file, printing credit note in  'Customer Transaction Inquiry' has no issue.

Thanks both for your help! I have replaced rep107, 108, 109, 111, 112, 113 in my system and now the currency filter works perfectly! Very helpful. Thank you.

I just looked deeper into the code in rep107 and it seems that currency is actually not considered in the filters
Those 'if' functions only cover invoices, debtor_no and email (I hope I am reading the code directly...)
Can this be fixed so to include currency filter? Many thanks.


            if (!exists_customer_trans(ST_SALESINVOICE, $i))
                continue;
........
            if($customer && $myrow['debtor_no'] != $customer) {
                continue;
            }
.......

            if ($email == 1)

apmuthu wrote:

Hope you have set the Customer Currency correctly. Otherwise, company's currency will be used and it will not be filterable. Currency is used in the payment link generation in pdf_report.inc in it's End() method. I have not been able to ascertain where else the "currency variable taken from the report request form" is used in report generation.

I think I set up the Customer Currency correctly because there is nowhere else I can set currency. I found this code in rep107

$cur = get_company_Pref('curr_default');

It seems the currency filter is not taking the Customer Currency but just the 'Home Currency' under Company Set Up.

What should I do so that the Currency Filter will work as per the Customer Currency?

Thank you.

apmuthu wrote:

There is a currency filter in the Invoice Printing Form and even if you choose all the invoices / customers, probably this filter may kick in - please provide feedback on it.


This filter does not seem to work. Does this 'Currency' correspond to 'Customer's Currency' field under 'Add and Manage Customers' function? What should I change to make this filter kick in? Thank you.