We are doing these tests on 404b currently.
When we advance bill, we are linking it to the order, but it is not
bringing over any tax calculation at this point. If I go and manual
override the tax field, it now puts the $50 straight into tax instead of
into advance bill, which means we're realizing the tax far to soon.
As soon as I go and create the shipment invoice, vantage then does the
tax calculation. If it were automatic as you propose below, we'd be in
good shape.
We're actually live on 403c, perhaps I'll try there and see if it's just
a bug in 404b where it isn't bringing the tax calculation in
automatically on advance bill.
Thanks for the ideas,
Ken
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Debbie Stokes
Sent: Tuesday, July 01, 2008 4:14 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re:Advance Bill scenario
We think we have found a possible bug in the taxable amount calculation
when a line is shipped in 2 packs but invoiced together, the first of
which is less than the value of the advanced billing but I wouldn't
expect it to affect your situation (what version are you on?). (see
below) We are on Vantage 8.03.305L.
It also screws up generally if you advance bill a line for more than its
value (e.g. You have 10 lines but you advance bill for the entire value
on line 1 - don't do it! - advance bill each line for up to its full
(nett) value).
We advance bill frequently (including UK tax - is US law different
regarding tax on advance bills?). The advance bill should be for the net
amount and Vantage should add the tax automatically as it does with
shipment invoices. Make sure you link it to the order. After shipping,
the final invoice should automatically take the advance bill into
account and come out at 0.
Now to the possible bug (with epicor support but not confirmed). We had
an order which had been advance billed 30% say. When it was shipped only
10% (say) of 1 line went on the first lorry on a Friday. The remainder
was sent on the Monday morning in a 2nd pack. The final invoice was
created later that day. The first line correctly had no payment and no
tax calculated. The 2nd line was for the remaining 90% of the cost.
However when Vantage calculated the taxable amount for the 2nd line, it
took off the entire value (30%) of the advance bill and not the
remainder (20%) after taking into account line1! Thus the tax was
understated.
kind regards
Debbie Stokes
Vantage Administrator
Hilo-PSS Group
01793 647136
************************************************************************
************************************************************************
************************************************************************
*******************************************************
This email is intended for the addressee only and may contain
information that is privileged and confidential. If you are not the
intended recipient, you must not copy, distribute or take any
action in reliance on it. If this email has been sent to you in error,
please notify us immediately by telephone.
This has been transmitted by -
Hilo-PSS Group
Murdock Road
Dorcan Industrial Estate
Swindon
SN3 5HY
Company Registration No: 01028915.
The views within this email are those of the author and not
necessarily those of Planned Storage Systems Ltd.
** This email has been scanned for viruses, vandals and malicious
content **
************************************************************************
************************************************************************
************************************************
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
When we advance bill, we are linking it to the order, but it is not
bringing over any tax calculation at this point. If I go and manual
override the tax field, it now puts the $50 straight into tax instead of
into advance bill, which means we're realizing the tax far to soon.
As soon as I go and create the shipment invoice, vantage then does the
tax calculation. If it were automatic as you propose below, we'd be in
good shape.
We're actually live on 403c, perhaps I'll try there and see if it's just
a bug in 404b where it isn't bringing the tax calculation in
automatically on advance bill.
Thanks for the ideas,
Ken
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Debbie Stokes
Sent: Tuesday, July 01, 2008 4:14 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re:Advance Bill scenario
We think we have found a possible bug in the taxable amount calculation
when a line is shipped in 2 packs but invoiced together, the first of
which is less than the value of the advanced billing but I wouldn't
expect it to affect your situation (what version are you on?). (see
below) We are on Vantage 8.03.305L.
It also screws up generally if you advance bill a line for more than its
value (e.g. You have 10 lines but you advance bill for the entire value
on line 1 - don't do it! - advance bill each line for up to its full
(nett) value).
We advance bill frequently (including UK tax - is US law different
regarding tax on advance bills?). The advance bill should be for the net
amount and Vantage should add the tax automatically as it does with
shipment invoices. Make sure you link it to the order. After shipping,
the final invoice should automatically take the advance bill into
account and come out at 0.
Now to the possible bug (with epicor support but not confirmed). We had
an order which had been advance billed 30% say. When it was shipped only
10% (say) of 1 line went on the first lorry on a Friday. The remainder
was sent on the Monday morning in a 2nd pack. The final invoice was
created later that day. The first line correctly had no payment and no
tax calculated. The 2nd line was for the remaining 90% of the cost.
However when Vantage calculated the taxable amount for the 2nd line, it
took off the entire value (30%) of the advance bill and not the
remainder (20%) after taking into account line1! Thus the tax was
understated.
kind regards
Debbie Stokes
Vantage Administrator
Hilo-PSS Group
01793 647136
************************************************************************
************************************************************************
************************************************************************
*******************************************************
This email is intended for the addressee only and may contain
information that is privileged and confidential. If you are not the
intended recipient, you must not copy, distribute or take any
action in reliance on it. If this email has been sent to you in error,
please notify us immediately by telephone.
This has been transmitted by -
Hilo-PSS Group
Murdock Road
Dorcan Industrial Estate
Swindon
SN3 5HY
Company Registration No: 01028915.
The views within this email are those of the author and not
necessarily those of Planned Storage Systems Ltd.
** This email has been scanned for viruses, vandals and malicious
content **
************************************************************************
************************************************************************
************************************************
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]