26 Reply by amdawi

(8 replies, posted in Accounts Receivable)

Let me explain What I want again ,
I have 2 locations
Item 1 Qty 100  in Location 1
Item 1 Qty 50    in Location 2
-----------------
We want to make invoice contains Item 1 with Qty : 130,
so our order will be insufficient quantities.

so we need to join 2 locations in the same order.

Thanks,

Go to forum: Accounts Receivable

27 Reply by amdawi

(8 replies, posted in Accounts Receivable)

Dear itronics,
I did not understand , Could you please explain more?

Thanks in advance.

Go to forum: Accounts Receivable

28 Topic by amdawi

(8 replies, posted in Accounts Receivable)

Hello,

I want to create sales order , and delivered from multi Location.
Item 1   - From Loc1
Item 2   - From Loc2
Item 3   - From Loc3

Is that possible?

with regards,

Go to forum: Accounts Receivable

29 Reply by amdawi

(3 replies, posted in Report Bugs here)

So, what can I do ??
Thanks,

Go to forum: Report Bugs here

30 Topic by amdawi

(4 replies, posted in Accounts Receivable)

Hello,
In direct invoice, when I click F3 to choose branch from Pop windows and select any one, it is not working and nothing change in branch list.
Why ? maybe it's bug.

Thanks,

Go to forum: Accounts Receivable

31 Topic by amdawi

(2 replies, posted in Installation)

Hello,
I have made a lot of modifications in 2.2.4 version, how can I upgrade to 2.2.5 without lose my modifications on 2.2.4?
Is there a list of modifications in 2.2.5?

Thanks & regards,

Go to forum: Installation

32 Reply by amdawi

(3 replies, posted in Accounts Receivable)

Thanks  itronics

Go to forum: Accounts Receivable

33 Reply by amdawi

(3 replies, posted in Accounts Receivable)

Please any help about.
I need to understand the steps, How?

Regards,

Go to forum: Accounts Receivable

34 Topic by amdawi

(3 replies, posted in Accounts Receivable)

Hello,
I want to add new field on Sales Order Items line?
Could you please help me, how?
Do I need to change in Cart Class ?

with Regards & Thanks,

amdawi,

Go to forum: Accounts Receivable

35 Topic by amdawi

(1 replies, posted in Dimensions)

Hello,
I want to add pages function below the list of Dimensions ( 10 list for every page )
admin/tags.php?type=dimension
Like this :
Tag Name     Tag Description        
  Tag1            
  Tag2
  Tag3
----------------------------------------------
1-1                                < >
How can I use display_db_pager($table)?


Thanks,

Go to forum: Dimensions

36 Topic by amdawi

(1 replies, posted in Banking and General Ledger)

Hello,
Can I close year automatically?
So, all balances for will be foreword to next year, and expenses/incomes will be begin as 0 and forward its balances to Profit/Loss account.
I could not see that routine in Frontaccounting?

Thanks,

Go to forum: Banking and General Ledger

37 Reply by amdawi

(4 replies, posted in Accounts Receivable)

Yes, It's work
Thank you itronics & Joe.
I have restarted it my Apache.

Go to forum: Accounts Receivable

38 Reply by amdawi

(4 replies, posted in Accounts Receivable)

Dear Joe,
No.
When I click Direct Invoice , directly i got this pop up window >>
http://img94.imageshack.us/img94/5822/errorsk.jpg   [   screen shot ]
My Platform is : Linux Ubuntu
Web Server    : XAMPP

Thanks,

amdawi,

Go to forum: Accounts Receivable

39 Topic by amdawi

(4 replies, posted in Accounts Receivable)

Hello,
I am working with fronaccounting 2.2.2.
when click Direct Invoice, it pop up window to open with application.

Thanks,

Go to forum: Accounts Receivable

40 Reply by amdawi

(6 replies, posted in FA Modifications)

Any idea, Please

Go to forum: FA Modifications

41 Reply by amdawi

(6 replies, posted in FA Modifications)

Dear Joe ,
I want to remove tables and borders.
I need a blank invoice with values only and then print to my formal invoice.

Thanks,

Go to forum: FA Modifications

42 Topic by amdawi

(1 replies, posted in Items and Inventory)

Hello,
I have seen error when updating any item ,
**************
DATABASE ERROR : The item could not be updated
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'no_sale='0' WHERE stock_id='-1'' at line 12
sql that failed was : UPDATE 0_stock_master SET long_description='', description='Disciunt0', category_id='2', sales_account='4510', inventory_account='1510', cogs_account='5010', adjustment_account='5040', assembly_account='1530', dimension_id='0', dimension2_id='0', tax_type_id='1' no_sale='0' WHERE stock_id='-1'

*************
I have fixed as the following
inventory/manage/items.php
go to line 17 ,
$sql = "UPDATE ".TB_PREF."stock_master SET long_description=".db_escape($long_description).",
        description=".db_escape($description).",
        category_id=".db_escape($category_id).",
        sales_account=".db_escape($sales_account).",
        inventory_account=".db_escape($inventory_account).",
        cogs_account=".db_escape($cogs_account).",
        adjustment_account=".db_escape($adjustment_account).",
        assembly_account=".db_escape($assembly_account).",
        dimension_id=".db_escape($dimension_id).",
        dimension2_id=".db_escape($dimension2_id).",
        tax_type_id=".db_escape($tax_type_id)."
        no_sale=".db_escape($no_sale);
replaced by
$sql = "UPDATE ".TB_PREF."stock_master SET long_description=".db_escape($long_description).",
        description=".db_escape($description).",
        category_id=".db_escape($category_id).",
        sales_account=".db_escape($sales_account).",
        inventory_account=".db_escape($inventory_account).",
        cogs_account=".db_escape($cogs_account).",
        adjustment_account=".db_escape($adjustment_account).",
        assembly_account=".db_escape($assembly_account).",
        dimension_id=".db_escape($dimension_id).",
        dimension2_id=".db_escape($dimension2_id).",
        tax_type_id=".db_escape($tax_type_id).",
        no_sale=".db_escape($no_sale);

the error was because there is no , after     tax_type_id=".db_escape($tax_type_id)."

Go to forum: Items and Inventory