251 Topic by seahawk

(1 replies, posted in Report Bugs here)

big_smile 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

Go to forum: Report Bugs here

252 Reply by seahawk

(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

Go to forum: Report Bugs here

253 Reply by seahawk

(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

Go to forum: Accounts Receivable

254 Reply by seahawk

(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

Go to forum: FA Modifications

255 Topic by seahawk

(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

Go to forum: FA Modifications

256 Topic by seahawk

(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

Go to forum: Report Bugs here

257 Reply by seahawk

(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)

Go to forum: FA Modifications

258 Reply by seahawk

(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

Go to forum: FA Modifications

259 Reply by seahawk

(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

Go to forum: Report Bugs here

260 Reply by seahawk

(12 replies, posted in Accounts Receivable)

Thanks Joe.

Go to forum: Accounts Receivable

261 Topic by seahawk

(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

Go to forum: Accounts Receivable

262 Topic by seahawk

(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

Go to forum: FA Modifications

263 Topic by seahawk

(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

Go to forum: FA Modifications

264 Topic by seahawk

(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

Go to forum: Report Bugs here

265 Topic by seahawk

(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

Go to forum: FA Modifications

266 Topic by seahawk

(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

Go to forum: Report Bugs here

267 Reply by seahawk

(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

Go to forum: Accounts Receivable

268 Reply by seahawk

(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.

Go to forum: Accounts Receivable

269 Reply by seahawk

(8 replies, posted in Accounts Receivable)

Does anyone have any idea? It is quite urgent to get a resolution on this?

Thanks

Wynand

Go to forum: Accounts Receivable

270 Reply by seahawk

(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

Go to forum: Accounts Receivable

271 Topic by seahawk

(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

Go to forum: Accounts Receivable

272 Reply by seahawk

(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

Go to forum: Report Bugs here

273 Reply by seahawk

(9 replies, posted in Report Bugs here)

I am currently struggling with the same issue. Backup keeps running until FA times out.

Regards

Go to forum: Report Bugs here

274 Reply by seahawk

(9 replies, posted in Manufactoring)

You Can also do it via work Orders in manufacturing indicating the bill of material.

The unprinted shirts will have a different stock number to the printed shirts. The unprinted shirts will then be part of the bill of material.

Create printing as a work centre.

You can then trace the uncompleted work orders and enter the labour and printing costs for the item.

Not sure if you will have to do it for each shirt or if you can do 30 or so at a time.

Go to forum: Manufactoring

275 Reply by seahawk

(2 replies, posted in Items and Inventory)

Thanks Janusz. I have now realized that these settings must be set before access levels are set for users. It seems that one needs to log in on each of the user accounts to set the stock codes. If it is done in admin it is not set for all users in the display tab.

If users do not have access to the setup tab, then they can not change their display settings. Salesman only have access to sales tab and items and inventory tab.

I went into the user table through phpmyadmin and set it there.

Regards

Go to forum: Items and Inventory