Which table are you speaking about ?

Jacques

From: "kunal aggarwal" <[EMAIL PROTECTED]>
Hi jacopo,

i want to know that how can i apply INV_SALES_TAX on my my orders . whenever
we
make any sales order , then it is always ITM_SALES_TAX is applied and
inserted into the table.
so can you please help me out and tell me how can i make a sales order so
that INV_SALES_TAX will be applied.

regards
kunal


On Sun, Sep 21, 2008 at 1:00 PM, Jacopo Cappellato <
[EMAIL PROTECTED]> wrote:

Hi Kunal,

if I am not wrong:

ITM_SALES_TAX is for tax adjustments for a sales invoice item
PITM_SALES_TAX is for tax adjustments for a purchase invoice item
INV_SALES_TAX  is for tax adjustments for a sales invoice header
PINV_SALES_TAX  is for tax adjustments for a purchase invoice header

Jacopo

On Sep 12, 2008, at 7:17 PM, kunal aggarwal wrote:

 Hi all

I have queried table *invoice_item_type* using following query *
*

SELECT invoice_item_type_id, parent_type_id, has_table, description,
    default_gl_account_id, last_updated_stamp, last_updated_tx_stamp,
    created_stamp, created_tx_stamp
FROM invoice_item_type
where
invoice_item_type_id like '%TAX'


I found the following result

*invoice_item_type_id     *                   *    description*

"PINV_SALES_TAX"                            "Sales Tax"
"INV_SALES_TAX"                                sales tax
"ITM_SALES_TAX"                              "Sales Tax"
"PITM_SALES_TAX"                            "Sales Tax"


I have understood how   "ITM_SALES_TAX"and "PITM_SALES_TAX"  are used in
invoice generation.

However can anyone tell me the purpose of "PINV_SALES_TAX"   and
"INV_SALES_TAX"
types ?


Please reply if anyone have this idea


regards
kunal




Reply via email to