How do you edit them?
Regards 
252 08/15/2013 01:20:10 pm
Re: [Resolved] FA Database Backup not working (1 replies, posted in Report Bugs here)
There was a misconfiguration on the ISP's MySQL that caused the time outs on my package.
They have corrected that and it is now working fine.
253 08/14/2013 09:58:11 pm
Re: Enter "Create new item" button on Direct invoice (12 replies, posted in FA Modifications)
Thanks Janusz. Much appreciated.
Wynand
254 08/14/2013 09:38:57 pm
Topic: [Resolved] FA Database Backup not working (1 replies, posted in Report Bugs here)
Still no ideas for the taking. Been struggling to make a backup of Frontaccounting database. Last backup was posible on 24/06/2013. Tried the following with the same result:
1. Backup in Front accounting: Just keeps running until it times out.
2. Cpanel Backups: Joomla database backup fine but Front Accounting continues until it times out as well
3. PHPMyAdmin: Same issue if I try and export front accounting database as sql, time out and eventually gives an error.
I have upgraded to the latest version and now my accounting system does not open at all.
I am desparate to try and find a solution. Do not know if it might be a problem on this particular shared server, but why is it only happening with the one company's FA database.
What are FA backup using that Joomla might not? Could the problem be on the particular server?
Apache version 2.2.24
PHP version 5.2.17
MySQL version 5.0.96-community
Any ideas would be greatly appreciated
Wynand
255 08/14/2013 09:33:01 pm
Re: Backups not working 2.3.15 (9 replies, posted in Report Bugs here)
Still no ideas for the taking. Been struggling to make a backup of Frontaccounting database. Last backup was posible on 24/06/2013. Tried the following with the same result:
1. Backup in Front accounting: Just keeps running until it times out.
2. Cpanel Backups: Joomla database backup fine but Front Accounting continues until it times out as well
3. PHPMyAdmin: Same issue if I try and export front accounting database as sql, time out and eventually gives an error.
I have upgraded to the latest version and now my accounting system does not open at all.
I am desparate to try and find a solution. Do not know if it might be a problem on this particular shared server, but why is it only happening with the one company's FA database.
Any ideas would be greatly appreciated
Wynand
256 08/14/2013 09:23:19 pm
Re: TAX INVOICE (12 replies, posted in Accounts Receivable)
Thanks Alastair and Janusz. It sounds like a great idea. Where do I find the an_Au to look at the details?
Regards
Wynand
257 08/14/2013 01:02:36 pm
Re: Enter "Create new item" button on Direct invoice (12 replies, posted in FA Modifications)
Did that but nothing. now F4 does nothing in Firefox. Where would one find these commands in Front accounting?
Wynand
258 08/14/2013 11:13:22 am
Topic: Email Receipt to customer (9 replies, posted in FA Modifications)
Hi
Is it possible to add feature to be able to email the receipt to the customer. should use the same email under the branch as that for invoicing.
regards
wynand
259 08/14/2013 11:11:29 am
Topic: DATABASE ERROR (2 replies, posted in Report Bugs here)
I have entered new client, did direct invoice, received and allocated payment. When I want to print statement for client on outstanding amount I get the following message if I do not select Yes to "show also allocated". If I select Yes, the statement disappears.
DATABASE ERROR : No transactions were returned
error code : 1305
error message : FUNCTION aquilla1_Front.ABS does not exist
sql that failed was : SELECT 0_debtor_trans.*, (0_debtor_trans.ov_amount + 0_debtor_trans.ov_gst + 0_debtor_trans.ov_freight + 0_debtor_trans.ov_freight_tax + 0_debtor_trans.ov_discount) AS TotalAmount, 0_debtor_trans.alloc AS Allocated, ((0_debtor_trans.type = 10) AND 0_debtor_trans.due_date < '2013-08-14') AS OverDue FROM 0_debtor_trans WHERE 0_debtor_trans.tran_date <= '2013-08-14' AND 0_debtor_trans.debtor_no = '48' AND 0_debtor_trans.type <> 13 AND ABS(0_debtor_trans.ov_amount + 0_debtor_trans.ov_gst + 0_debtor_trans.ov_freight + 0_debtor_trans.ov_freight_tax + 0_debtor_trans.ov_discount) > 1e-6 AND ABS (ABS(0_debtor_trans.ov_amount + 0_debtor_trans.ov_gst + 0_debtor_trans.ov_freight + 0_debtor_trans.ov_freight_tax + 0_debtor_trans.ov_discount) - alloc) > 1e-6 ORDER BY 0_debtor_trans.tran_date
If I try and email the statement it gives me a message:
You have no email selected for this customer, but I just emailed the invoice to the customer.
any assistance would e valued.
regards
Wynand
260 08/14/2013 10:04:14 am
Re: Enter "Create new item" button on Direct invoice (12 replies, posted in FA Modifications)
That is OK. F2 opens customer (If you want to add or change customer) and F3 opens branch ( if you want to add or change branch)
261 08/14/2013 09:23:17 am
Re: Enter "Create new item" button on Direct invoice (12 replies, posted in FA Modifications)
Joe
F3 opens pop-up for new customer creation.
F4 Does nothing. Opens PHP development bar on Fire Fox.
Regards
262 08/14/2013 09:20:30 am
Re: Inventory Item Listing (3 replies, posted in Report Bugs here)
It seems that were the service item price is not set up it does not appear on this list.
It would be quite handy if one could have such a an item list to verify all the codes used.
Regards
264 08/14/2013 08:02:30 am
Topic: TAX INVOICE (12 replies, posted in Accounts Receivable)
In South Africa we have to print TAX INVOICE if the company is registered for VAT.
In FA it only displays INVOICE on the sales documents even though a VAT number was entered for the company.
How and where can I change this from INVOICE to TAX INVOICE.
Regards
Wynand
265 08/14/2013 07:57:02 am
Topic: Adding a new Tab for Reports (1 replies, posted in FA Modifications)
It would be great if we could have a tab for reports that one can go directly to the reports in stead of going through one of the Sales, Purchases; Items, Bank and General Ledger tabs to get to a specific report.
Regards
Wynand
266 08/14/2013 07:54:36 am
Topic: Enter "Create new item" button on Direct invoice (12 replies, posted in FA Modifications)
Is it possible to have a button to enter a new stock item in a popup window while you are busy in the direct invoice tab.
I have found a way around the issue by right clicking on the inventory tab and open it in a new window.
Regards
Wynand
267 08/14/2013 07:52:38 am
Topic: Inventory Item Listing (3 replies, posted in Report Bugs here)
Is it possible to have and Inventory Item Listing in the Inventory reports that will just list all the Inventory including service items.
All the reports come back blank on service items.
Regards
Wynand
268 08/14/2013 07:51:01 am
Topic: Include a Purchase Repeating Invoices (2 replies, posted in FA Modifications)
Is it possible to add a Purchase repeating invoice and purchase Invoice template simulacra to that on sales.
I have quite a number of repeating supplier invoices and have to do them one by one through the Direct Purchase Invoice section.
Regards
Wynand
269 08/14/2013 07:49:22 am
Topic: Email Client name in Invoice sending displayed wrong (6 replies, posted in Report Bugs here)
When sending an email to a client, the email would only contain the client's surname in the client address for example:
Dear "Surname" or "Last Name", instead of First Name or Full name. Only $contact['name2'] was displayed.
Would be nice to have some way of choosing the way a client is addressed in the email or at least use the full name.
Resolved the issue by changing line 1006 in pdf_report.inc
Changed contact details to:
$contact['name'].' '.$contact['name2']
Regards
Wynand
270 08/14/2013 07:14:47 am
Re: Item not displayed in Sales (8 replies, posted in Accounts Receivable)
Janusz
Yes the *_item_codes table structure does not contain 'item_code' nor 'stock_id' fields in the table when adding new item on Items page.
After creating the item and adding the selling price, I presume that the item will now be created in all the tables to be used for all purchase and sales.
Not entirely sure at which stage what should happen.
All I can deduct is that when new item is created, it is allocated to the *_stock_master table and when price is entered the item price is created in the *_prices. I am not sure at which stage it will create or is suppose to create the information in the *_item_code table.
Wynand
271 08/13/2013 06:58:36 am
Re: Item not displayed in Sales (8 replies, posted in Accounts Receivable)
Hi
Thanks for the response.
Have tried it all. Nothing. Even if I log out and log in again the item is appears the item list, on the Supplier documents but not on the sales quotation, order, or direct invoice.
Can not figure out why it is not creating the item in the item_code table.
272 08/12/2013 06:57:13 pm
Re: Item not displayed in Sales (8 replies, posted in Accounts Receivable)
Does anyone have any idea? It is quite urgent to get a resolution on this?
Thanks
Wynand
273 08/06/2013 12:16:40 pm
Re: Item not displayed in Sales (8 replies, posted in Accounts Receivable)
Elax
Thanks for the quick response.
The item is active and it is not excluded from sales.
I have checked the database through phpmyadmin. I had to manually create the items in item_code.
the table item_code does not contain the item_code nor stock_id at all. I presume that this is the table that will be displayed in the direct invoice stock or item list.
The stock_master contains the stock_id and the Prices contain the stock_id with all the detail of the items. Why would it not create the info in item_code?
regards
274 08/06/2013 10:09:30 am
Topic: Item not displayed in Sales (8 replies, posted in Accounts Receivable)
Hi
I have created a sales item but it is not displayed in the sales order/ quote/ or Direct Invoice.
I have maid transactions against the Items before and all of a sudden it is on the item and inventory tab but not on the sales tab. It is also displayed under the purchases.
What could be the issues. It happens quite often that it does not pull through to sales.
Regards
275 07/15/2013 09:16:03 pm
Re: Backups not working 2.3.15 (9 replies, posted in Report Bugs here)
I have the same issue. Made a backup on 24/06/2013. worked then, baut after that nothing. It just keeps running and you can not log out or do anything. Does anybody have an answer yet?
regards