1 Topic by ali002

(1 replies, posted in Items and Inventory)

Dear all,

When i want to key in the asset entry, mysql giving an error code like below,What that's mean ?

DATABASE ERROR : could not get all assets
error code : 1436
error message : Thread stack overrun: 12912 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.
sql that failed was : SELECT *, 0_get_asset_value(a.asset_id, YEAR(now())) as current_value FROM 0_asset_types at INNER JOIN 0_assets a ON at.asset_type_id = a.asset_type_id WHERE !a.inactive

Thanks for your supports

Go to forum: Items and Inventory

2 Reply by ali002

(5 replies, posted in Items and Inventory)

Dear All,

When i import the csv file, the fa complain like this:
"Line 2: Update
The entered information is a duplicate. Please go back and enter different values."
What it mean ?

Go to forum: Items and Inventory

3 Topic by ali002

(1 replies, posted in Reporting)

I do install FA on localhost but having a problem on sending email out. The FA said the email sent ( no error report from FA ) but they email never send out or received ( i use my own altenative mail ). Just to check either FA do use PHP Mail or send mail function as i need to checking @ google more. Thanks for the software and supports.

Go to forum: Reporting

4 Reply by ali002

(4 replies, posted in Items and Inventory)

joe wrote:

This works just as it should.

Check to see the standard cost in items and inventory tab for the item.

Joe

Okay. Will check it again and thanks for your fast reply.

Go to forum: Items and Inventory

5 Reply by ali002

(11 replies, posted in Accounts Payable)

How about the unit cost for the item ? I scared the unit cost are no longer accurate.

Go to forum: Accounts Payable

6 Reply by ali002

(4 replies, posted in Items and Inventory)

joe wrote:

Are you sure there is a standard cost for the item?

/Joe

yes. The suppliers inv already key in.

Go to forum: Items and Inventory

7 Reply by ali002

(11 replies, posted in Accounts Payable)

I'm too confused why FA didn't have "discount" on the suppliers invoice / purchase order as in my country, All the invoices receive from our suppliers are mention in discount. It's very hard and not accurate when we need to take the unit cost divide by quantity as the decimal point sometime going very long (ie 6 or 7 decimal point) and at the end, the total inv are not tally anymore. Please share on this . Thanks

Go to forum: Accounts Payable

8 Topic by ali002

(4 replies, posted in Items and Inventory)

Dear All,

I would like to make standard mark up - lets said 10% from my standard cost for sales price ? How i going to do that ?
I do see there are setting on company setup - Base for auto price calculations: and Add Price from Std Cost: but when i enter the 10% for Retail sales type but there are no sales price for the item.

Please help me on the matter.

Go to forum: Items and Inventory

9 Reply by ali002

(6 replies, posted in Accounts Receivable)

joe wrote:

This is a good idea. Will be implemented in next release, 2.3.3, shipping next week.

/Joe


Have this warning been implement ? Sorry for asking as i don't think i see any warning when selling under cost.

Go to forum: Accounts Receivable

10 Reply by ali002

(3 replies, posted in Accounts Receivable)

Dear Joe,


Already set $go_debug in config.php file to 1and view errors.log in the tmp folder but there are no error. Its only display "The entered transaction does not exist or cannot be voided." but can be view. Any others idea ?

Thanks for your supports.

Go to forum: Accounts Receivable

11 Topic by ali002

(3 replies, posted in Accounts Receivable)

Dear all,

I'm just upgrade to FA 2.3.6 from 2.2.10, Now I can't void certain customer payments. Check my Bank account amount are on positif, The customer account are also still having debt. May i know any idea why i can't void this transaction ?

Thanks for your supports.

Go to forum: Accounts Receivable

12 Reply by ali002

(15 replies, posted in Installation)

Dear Bro itronics,

Thanks for your supports. Glad to hear that the problem had been solved. Really waiting for the next update......

Thanks bro

Go to forum: Installation

13 Topic by ali002

(0 replies, posted in Items and Inventory)

Dear all,

Upgrade from 2.2.20 to 2.3.5 and find out the Inventories sales report not functioning and also do test  on demo site and I think i found some bug here... I do direct invoice on demo site and go to http://demo.frontaccounting.eu/reporting/reports_main.php?Class=2 with no luck. May anyone verified this ?

The reports come out with blank reports only.


Thanks for your supports.

Go to forum: Items and Inventory

14 Reply by ali002

(15 replies, posted in Installation)

Dear all,

Tested on demo site and I think i found some bug here... I do direct invoice on demo site and go to http://demo.frontaccounting.eu/reporting/reports_main.php?Class=2 with no luck. May anyone verified this ?

Thanks for your supports.

Go to forum: Installation

15 Reply by ali002

(15 replies, posted in Installation)

Dear all,

Successful installed and upgrade to ver 2.3.5 but still no luck. My http://domainname/reporting/reports_main.php?Class=2 still resulted with blank report. Try to key in with dummy sales invoice but still no value come out from report, Please anyone can verified that this report are functioning.

Thanks for your supports.

Go to forum: Installation

16 Reply by ali002

(15 replies, posted in Installation)

Dear Bro Tom,

Thanks for your advise, already drop the table and re-import the backup, Upgrade the system without Force Upgrade and the result are" Installed" with 5 comments ( Error ) :

You have missing or invalid sales document in database ( type: 30, number : 456 ).
You have missing or invalid sales document in database ( type: 30, number : 457 ).
You have missing or invalid sales document in database ( type: 30, number : 458 ).
You have missing or invalid sales document in database ( type: 30, number : 459 ).
You have missing or invalid sales document in database ( type: 30, number : 460 ).

May i know what documents that i need to look and edit, please guide me what's the file and location to edit.

Thanks for your supports.
ali002

Go to forum: Installation

17 Reply by ali002

(15 replies, posted in Installation)

Partial Upgrade 1/4, after a few force upgrade, Upgrade Successful but when you go to Item & Eventory, under inventories sales report, all the database are none. But when you go to customer transaction, the transaction are there. Please help.

Go to forum: Installation

18 Reply by ali002

(15 replies, posted in Installation)

I tried to update from 2.2.10 to 2.3.5 or below but failed. The database can't be upgrade. I also try new installation 2.3.5 and import the database 2.2.10 with the table increase from 75 to 79 but also face the same problem. May anyone may help me by telling the step by step. Thanks

Go to forum: Installation