You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Santosh Malviya <sa...@hotwaxmedia.com> on 2009/02/19 10:38:48 UTC
How to add Invoice sales tax
Hello all,
I have done it in my purchase invoice but not able to see it in my
overall price while my invoice shipping and handling price added
successfully.
Thanks in advance.
Thanks & Regards
Santosh Malviya
Re: How to add Invoice sales tax
Posted by David E Jones <da...@hotwaxmedia.com>.
It sounds like you've now got a definition of what is happening that
someone could actually look into.
Are you interested in looking into this more? If so, one thing that is
interesting about this that might be a place to look is that you
mentioned manually adding tax and shipping, but only shipping made it
through (if I understand right what you wrote... I'm not totally sure
because there is no mention of the data you entered so I couldn't
match it up to compare)... so something is wrong with the tax invoice
item.
Some things that come to mind as possibilities to pursue:
1. are there any errors in the log?
2. is there some configuration missing for that InvoiceItemType?
3. is there an issue with the code, perhaps that handles the override
glAccountId? what happens if you don't specify an override account?
-David
On Feb 19, 2009, at 11:23 PM, Santosh Malviya wrote:
> Hello David,
> I have done following :
> (1)At first I created a purchase order, approved the order,
> generated a shipment, issued items, received items. Then in
> Accounting I edited purchase invoice by adding new items like adding
> invoice sales tax and invoice shipping and handling. Here I added
> invoice sales tax(of unit price $10) and two invoice shipping and
> handling(one with the Gl Account Id and other without ) with
> override Gl Account Id = 516100 PURCHASE ORDER ADJUSTMENTS and unit
> price of both and then I set "status to ready". This generated 4
> transaction entries which are follows :
> Credit; in account 210000 - "ACCOUNTS PAYABLE"; amount: 288$
> (After adding all taxes and shipping charges) Debit;
> in account 214000 - "UNINVOICED ITEM RECEIPTS"; amount: 270$ (Actual
> price of 10 items of WG-1111)
> Debit; in account 510000 - "FREIGHT IN"; amount: 5$ (Shipping
> invoice without Gl account Id)
> Debit; in account 516100 - "PURCHASE ORDER ADJUSTMENTS";
> amount: 3$ (Shipping invoice with Gl account Id)
>
> (2) I was expecting here transaction entry of invoice sales tax
> while its tax was added into total price(ACCOUNTS PAYABLE, amount
> 288$).
> (3) Only four entries were there as a result of this invoice.
>
> Thanks and Regards
> Santosh Malviya
>
> David E Jones wrote:
>>
>> Santosh,
>>
>> I don't understand this question, and I'm not sure if others do
>> either. For example, what do you mean by "when I add Invoice sales
>> tax"? Where and how do you add it? Could you please rewrite this
>> question in terms of:
>>
>> 1. what you did
>> 2. what you expected to happen
>> 3. what actually happened
>>
>> -David
>>
>>
>> On Feb 19, 2009, at 3:07 AM, Santosh Malviya wrote:
>>
>>> Sorry for inconvenience, my question should have been when I add
>>> Invoice sales tax of unit price say $10 then I am unable to see
>>> its transaction entry while invoice shipping and handling entries
>>> are there. Where this entry is done. Am I missing something?.
>>> Thanks in advance.
>>>
>>> Thanks & Regards
>>> Santosh Malviya
>>>
>>>
>>> Santosh Malviya wrote:
>>>> Hello all,
>>>> I have done it in my purchase invoice but not able to see it in
>>>> my overall price while my invoice shipping and handling price
>>>> added successfully.
>>>> Thanks in advance.
>>>>
>>>> Thanks & Regards
>>>> Santosh Malviya
>>>>
>>>
>>
>>
>
Re: How to add Invoice sales tax
Posted by Santosh Malviya <sa...@hotwaxmedia.com>.
Hello David,
I have done following :
(1)At first I created a purchase order, approved the order, generated a
shipment, issued items, received items. Then in Accounting I edited
purchase invoice by adding new items like adding invoice sales tax and
invoice shipping and handling. Here I added invoice sales tax(of unit
price $10) and two invoice shipping and handling(one with the Gl Account
Id and other without ) with override Gl Account Id = 516100 PURCHASE
ORDER ADJUSTMENTS and unit price of both and then I set "status to
ready". This generated 4 transaction entries which are follows :
Credit; in account 210000 - "ACCOUNTS PAYABLE"; amount: 288$
(After adding all taxes and shipping charges)
Debit; in account 214000 - "UNINVOICED ITEM RECEIPTS"; amount:
270$ (Actual price of 10 items of WG-1111)
Debit; in account 510000 - "FREIGHT IN"; amount: 5$ (Shipping
invoice without Gl account Id)
Debit; in account 516100 - "PURCHASE ORDER ADJUSTMENTS";
amount: 3$ (Shipping invoice with Gl account Id)
(2) I was expecting here transaction entry of invoice sales tax while
its tax was added into total price(ACCOUNTS PAYABLE, amount 288$).
(3) Only four entries were there as a result of this invoice.
Thanks and Regards
Santosh Malviya
David E Jones wrote:
>
> Santosh,
>
> I don't understand this question, and I'm not sure if others do
> either. For example, what do you mean by "when I add Invoice sales
> tax"? Where and how do you add it? Could you please rewrite this
> question in terms of:
>
> 1. what you did
> 2. what you expected to happen
> 3. what actually happened
>
> -David
>
>
> On Feb 19, 2009, at 3:07 AM, Santosh Malviya wrote:
>
>> Sorry for inconvenience, my question should have been when I add
>> Invoice sales tax of unit price say $10 then I am unable to see its
>> transaction entry while invoice shipping and handling entries are
>> there. Where this entry is done. Am I missing something?.
>> Thanks in advance.
>>
>> Thanks & Regards
>> Santosh Malviya
>>
>>
>> Santosh Malviya wrote:
>>> Hello all,
>>> I have done it in my purchase invoice but not able to see it in my
>>> overall price while my invoice shipping and handling price added
>>> successfully.
>>> Thanks in advance.
>>>
>>> Thanks & Regards
>>> Santosh Malviya
>>>
>>
>
>
Re: How to add Invoice sales tax
Posted by David E Jones <da...@hotwaxmedia.com>.
Santosh,
I don't understand this question, and I'm not sure if others do
either. For example, what do you mean by "when I add Invoice sales
tax"? Where and how do you add it? Could you please rewrite this
question in terms of:
1. what you did
2. what you expected to happen
3. what actually happened
-David
On Feb 19, 2009, at 3:07 AM, Santosh Malviya wrote:
> Sorry for inconvenience, my question should have been when I add
> Invoice sales tax of unit price say $10 then I am unable to see its
> transaction entry while invoice shipping and handling entries are
> there. Where this entry is done. Am I missing something?.
> Thanks in advance.
>
> Thanks & Regards
> Santosh Malviya
>
>
> Santosh Malviya wrote:
>> Hello all,
>> I have done it in my purchase invoice but not able to see it in my
>> overall price while my invoice shipping and handling price added
>> successfully.
>> Thanks in advance.
>>
>> Thanks & Regards
>> Santosh Malviya
>>
>
Re: How to add Invoice sales tax
Posted by Santosh Malviya <sa...@hotwaxmedia.com>.
Sorry for inconvenience, my question should have been when I add Invoice
sales tax of unit price say $10 then I am unable to see its transaction
entry while invoice shipping and handling entries are there. Where this
entry is done. Am I missing something?.
Thanks in advance.
Thanks & Regards
Santosh Malviya
Santosh Malviya wrote:
> Hello all,
> I have done it in my purchase invoice but not able to see it in my
> overall price while my invoice shipping and handling price added
> successfully.
> Thanks in advance.
>
> Thanks & Regards
> Santosh Malviya
>