in table " debtor_trans " what is the column "trans_link" ??
is it a link to some thing ? what is this thing ?????
please help me !!
1 06/09/2010 01:11:53 pm
Topic: what is " trans_link " ?? (0 replies, posted in Items and Inventory)
2 06/08/2010 08:17:17 am
Re: Confusion in understanding how data stored ? (2 replies, posted in Items and Inventory)
ok , i know that .
but if you enter a " direct invoice " you will find data in debtor_trans table as i showed you before
i know that these allocation of direct invoice has no effect of customer payment and credit notes
but why data stored as shown , i don't know
thank you
3 06/08/2010 07:40:49 am
Topic: Confusion in understanding how data stored ? (2 replies, posted in Items and Inventory)
firstly :
i want to enter anew sales order >> deliver >> invoice >> pay for this order .
these are the tables used to store data about sales orders
( "sales_orders" , "sales_orders_details" , "debtor_trans" , "debtor_trans_details" , "audit_trial" , "comments" , "refs" , "stock_moves" ).
"sales_order"and "sales_order_details" tables stores all kinds of orders as "sales quotation" , "sales order" , "direct delivery" and "direct invoice"
------------------------------------------------------------------------------------------
"debtor_trans" and "debtor_trans_details" tables stores all transaction about sales order like (delivery , invoice , payment).
------------------------------------------------------------------------------------------
if i use "direct invoice" Form it will stores as normal sales order in "sales_order" and "sales_order_details" tables // that's very good - no problem
but
see this case (i entered 3 direct invoices "1" with a value $1000 , "2" with a value $2000 , "3" with a value $3000 )
in "debtor_trans" table
i fount that there are two transactions (deliver with type "13" and invoice with type "10") stored for each one of these three "direct invoices"
but the problem is when i added the third "direct invoice" with id "3" anew transaction added to first direct invoice has id "1" in this "debtor_trans" table with type "12" that means "payment" with the third value $3000 like this table
debtor_trans
-------------------------------------------------
trans_no type ov_amount alloc
-------------------------------------------------
1 10 1000 1000
-------------------------------------------------
1 12 3000 3000
-------------------------------------------------
1 13 1000 0
===========================
2 10 2000 2000
-------------------------------------------------
2 13 2000 0
===========================
3 10 3000 3000
-------------------------------------------------
3 13 3000 0
===========================
what is the problem ????
why there is no payment stored for sales orders "1","2" and after adding the "3" the payment of it allocated to "1" sales order ???
4 06/05/2010 11:49:21 am
Re: add new sales order (4 replies, posted in Items and Inventory)
and " debtor_trans, debtor_trans_details " too
5 06/02/2010 02:26:42 pm
Topic: add new sales order (4 replies, posted in Items and Inventory)
when i enter new sales order
which database tables will be affected with this sales order entered ?
6 04/11/2010 10:44:16 am
Topic: need pure .po file (1 replies, posted in Translations)
i need pure .po file in English to translate it into any language
or
if you have .po file translated into arabic i will be grateful .
7 04/11/2010 07:52:35 am
Re: arabic language display (2 replies, posted in Translations)
thank you ..
but the problem is that not all arabic letters are corrupted
some of them displayed correct and some letters corrupted ..
what is that problem ???
8 04/10/2010 01:27:57 pm
Topic: arabic language display (2 replies, posted in Translations)
i'm using OS= "windows xp sp3" and xampp server on localhost machine
i installed the Arabic language on front accounting system in the localhost and its working well ..
but when i uploaded these project on an another web host server the arabic letters changed and another strange symbol appears instead of the arabic letters.
i found that the server i uploaded my project on it run with OS="linux" not "windows" like the localhost server on my machine .
can you help me..
what is the problem ? and what is the solution ?
thank you all ...
9 03/14/2010 12:10:59 pm
Re: file attachment ... (6 replies, posted in Setup)
its working well ..
thank you very much ...
10 03/14/2010 10:47:02 am
Re: file attachment ... (6 replies, posted in Setup)
what will i do with this php script ?
11 03/07/2010 08:08:18 am
Re: file attachment ... (6 replies, posted in Setup)
thank you joe for your help ..
i know what you said. i imagined that these types plays as a categories of file attached,
but using any type during attaching has no effect after that.
according my old imagine, after attaching many different file in each category when i choose any type ,it will show me just the file attached for this type not all files attached. but that occurs is FA show me all attached file not categorized as attachment.
when i watched how these file stored in database i saw that all attached file has the same type_no = '20' . what is that type number and why all files had the same one ??
12 03/06/2010 01:08:30 pm
Topic: Forms Setup (1 replies, posted in Setup)
what is the use of forms setup ??
13 03/06/2010 12:58:22 pm
Topic: file attachment ... (6 replies, posted in Setup)
what is use of the drop down list "type" in attachments page ??