226 Topic by seahawk

(0 replies, posted in Accounts Receivable)

I have tried to find some info in the forum without much success.

When adding some items from  the inventory and you add the item on a direct invoice, it changes the quantity from 1 to three and changes the price from 1850 to 666.67 which is then equal to 1850.01.

I have checked the item code and there is no characters in the code.

When I go back and edit the line item the quantity can be changed but the amount now remains at 666.67 and needs to manually changed back to the selling price of 1850. When I then add, the amount and the price is correct. There is also no characters in the description field.

Any idea what could cause this?

Regards

Wynand

Go to forum: Accounts Receivable

227 Reply by seahawk

(4 replies, posted in Accounts Receivable)

tm wrote:

https://frontaccounting.com/punbb/viewtopic.php?pid=18394#p18394

Thanks tm. This solved the problem. Have added the changed file to my 2.3.19 installation for the other updates that I still have to run.

Go to forum: Accounts Receivable

228 Reply by seahawk

(4 replies, posted in Accounts Receivable)

Thanks. It still worked with 2.3.18.

SQL version is: 5.0.96-community

regards

Go to forum: Accounts Receivable

229 Topic by seahawk

(4 replies, posted in Accounts Receivable)

Hi

After Installation of FA 2.3.19 I get the following error on Print Receipt after receipt and remittance of Payment.

DATABASE ERROR : query for bank transaction
error code : 1305
error message : FUNCTION iingcoza_frontacc.IFNULL does not exist
sql that failed was : SELECT bt.*, act.*, IFNULL(abs(dt.ov_amount), IFNULL (abs(st.ov_amount), bt.amount)) settled_amount, IFNULL(abs(dt.ov_amount/bt.amount), IFNULL (abs(st.ov_amount/bt.amount), 1)) settle_rate, IFNULL(debtor.curr_code, IFNULL (supplier.curr_code, act.bank_curr_code)) settle_curr FROM bank_trans bt LEFT JOIN debtor_trans dt ON dt.type=bt.type AND dt.trans_no=bt.trans_no LEFT JOIN debtors_master debtor ON debtor.debtor_no = dt.debtor_no LEFT JOIN supp_trans st ON st.type=bt.type AND st.trans_no=bt.trans_no LEFT JOIN suppliers supplier ON supplier.supplier_id = st.supplier_id, bank_accounts act WHERE act.id=bt.bank_act AND bt.type='12' AND bt.trans_no = '33' ORDER BY trans_date, bt.id

Any advice will be appreciated.

regards

Wynand

Go to forum: Accounts Receivable

230 Reply by seahawk

(4 replies, posted in Reporting)

joe wrote:

The customer statement uses the contact defined on the customer and not the branch contact.

Setup a customer contact with relevant type (invoice).

Joe

Isn't there a way that one can copy the first branch that is created to the company as well as branch contact. Most Companies will have one contact with one branch.

At the moment only the one item is normal selected to be email and you have to manually add the rest of the documents that needs to be emailed, example  Invoice and statement.

Can't we get all selected when the auto branch is created as well as creating a contact in the company for Statements.

regards

Wynand

Go to forum: Reporting

231 Reply by seahawk

(2 replies, posted in FA Modifications)

I think it might work.

Go to forum: FA Modifications

232 Reply by seahawk

(12 replies, posted in Accounts Receivable)

Thanks Janusz. Done that

Go to forum: Accounts Receivable

233 Reply by seahawk

(12 replies, posted in Accounts Receivable)

Thanks will give it a try. Once edited where do I send the file?

Go to forum: Accounts Receivable

234 Reply by seahawk

(2 replies, posted in Report Bugs here)

Thank You. big_smile

Go to forum: Report Bugs here

235 Reply by seahawk

(12 replies, posted in Accounts Receivable)

How do you edit them?

Regards big_smile

Go to forum: Accounts Receivable

236 Reply by seahawk

(1 replies, posted in Report Bugs here)

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

Go to forum: Report Bugs here

237 Reply by seahawk

(12 replies, posted in FA Modifications)

Thanks Janusz. Much appreciated.
Wynand

Go to forum: FA Modifications

238 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

239 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

240 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

241 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

242 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

243 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

244 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

245 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

246 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

247 Reply by seahawk

(12 replies, posted in Accounts Receivable)

Thanks Joe.

Go to forum: Accounts Receivable

248 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

249 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

250 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