Sales tax doubled? Uses statistical condition type in base calculation?

[Former Member]

Hi,

I have a issue with credit/debit memos (custom pricing procedure) where Sales Tax (CTXJ/JRC4) HST for Canada only is doubled. This condition type CTXJ/JRC4 uses a custom condition type ZDRO (step 15) as base. Also in the pricing procedure there are two statistical condition types ZDLP and ZLST which are step 3 and step 7, if i remove these condition type the HST tax is calculated correctly.

How can the statistical condition type affect the tax base calculation? These are statistical, so just for information only?

How do i debug the issue?

<TABLE>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>3</td>

<td>0</td>

<td>ZDLP</td>

<td>0</td>

<td>0</td>

<td></td>

<td>2</td>

<td></td>

<td>X</td>

<td>901</td>

<td>0</td>

<td colspan=3D5 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>7</td>

<td>0</td>

<td>ZLST</td>

<td>0</td>

<td>0</td>

<td></td>

<td>2</td>

<td></td>

<td>X</td>

<td>901</td>

<td>0</td>

<td colspan=3D5 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>15</td>

<td>0</td>

<td>ZDR0</td>

<td>0</td>

<td>0</td>

<td></td>

<td>2</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>901</td>

<td>0</td>

<td>ERL</td>

<td></td>

<td>X</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>20</td>

<td>0</td>

<td>ZCR1</td>

<td>0</td>

<td>0</td>

<td>X</td>

<td>2</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>901</td>

<td>0</td>

<td>ZRL</td>

<td></td>

<td>X</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>25</td>

<td>0</td>

<td>ZCR2</td>

<td>0</td>

<td>0</td>

<td>X</td>

<td>2</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>901</td>

<td>0</td>

<td>ZRL</td>

<td></td>

<td>X</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>30</td>

<td>0</td>

<td>ZCR3</td>

<td>0</td>

<td>0</td>

<td>X</td>

<td>2</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>901</td>

<td>0</td>

<td>ZRL</td>

<td></td>

<td>X</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>35</td>

<td>0</td>

<td>ZCR4</td>

<td>0</td>

<td>0</td>

<td>X</td>

<td>2</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>901</td>

<td>0</td>

<td>ZRL</td>

<td></td>

<td>X</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>40</td>

<td>0</td>

<td>ZCR5</td>

<td>0</td>

<td>0</td>

<td>X</td>

<td>2</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>901</td>

<td>0</td>

<td>ZRL</td>

<td></td>

<td>X</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>45</td>

<td>0</td>

<td>ZCR6</td>

<td>0</td>

<td>0</td>

<td>X</td>

<td>2</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>901</td>

<td>0</td>

<td>ZRL</td>

<td></td>

<td>X</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>50</td>

<td>0</td>

<td>ZCR7</td>

<td>0</td>

<td>0</td>

<td>X</td>

<td>2</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>901</td>

<td>0</td>

<td>ZRL</td>

<td></td>

<td>X</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>55</td>

<td>0</td>

<td></td>

<td>15</td>

<td>50</td>

<td></td>

<td>0</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>0</td>

<td>0</td>

<td colspan=3D5 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>58</td>

<td>0</td>

<td>ZMSF</td>

<td>0</td>

<td>0</td>

<td>X</td>

<td>2</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>901</td>

<td>0</td>

<td>ERL</td>

<td></td>

<td>X</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>60</td>

<td>0</td>

<td></td>

<td>55</td>

<td>58</td>

<td></td>

<td>0</td>

<td>1</td>

<td></td>

<td>0</td>

<td>0</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>X</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>108</td>

<td>0</td>

<td>ZRTD</td>

<td>60</td>

<td>0</td>

<td></td>

<td>2</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>0</td>

<td>0</td>

<td>ERS</td>

<td></td>

<td>X</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>110</td>

<td>0</td>

<td>ZRTL</td>

<td>60</td>

<td>0</td>

<td></td>

<td>2</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>0</td>

<td>0</td>

<td>ERS</td>

<td></td>

<td>X</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>300</td>

<td>0</td>

<td></td>

<td>108</td>

<td>110</td>

<td></td>

<td>0</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>0</td>

<td>0</td>

<td colspan=3D5 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>705</td>

<td>0</td>

<td></td>

<td>60</td>

<td>110</td>

<td></td>

<td>2</td>

<td>2</td>

<td></td>

<td>0</td>

<td>0</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>X</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>710</td>

<td>0</td>

<td>UTXJ</td>

<td>705</td>

<td>0</td>

<td></td>

<td>0</td>

<td></td>

<td>X</td>

<td>0</td>

<td>0</td>

<td>MWS</td>

<td>MWS</td>

<td colspan=3D3 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>712</td>

<td>0</td>

<td>JR1</td>

<td>705</td>

<td>0</td>

<td>X</td>

<td>0</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>0</td>

<td>0</td>

<td>MWS</td>

<td>MWS</td>

<td colspan=3D3 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>714</td>

<td>0</td>

<td>JR2</td>

<td>705</td>

<td>0</td>

<td>X</td>

<td>0</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>0</td>

<td>0</td>

<td>MWS</td>

<td>MWS</td>

<td colspan=3D3 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>716</td>

<td>0</td>

<td>JR3</td>

<td>705</td>

<td>0</td>

<td>X</td>

<td>0</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>0</td>

<td>0</td>

<td>MWS</td>

<td>MWS</td>

<td colspan=3D3 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>718</td>

<td>0</td>

<td>JR4</td>

<td>705</td>

<td>0</td>

<td>X</td>

<td>0</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>0</td>

<td>0</td>

<td>MWS</td>

<td>MWS</td>

<td colspan=3D3 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>720</td>

<td>0</td>

<td>CTXJ</td>

<td>705</td>

<td>0</td>

<td></td>

<td>0</td>

<td></td>

<td>X</td>

<td>0</td>

<td>0</td>

<td>ZWS</td>

<td>ZWS</td>

<td colspan=3D3 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>722</td>

<td>0</td>

<td>JRC1</td>

<td>705</td>

<td>0</td>

<td>X</td>

<td>0</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>0</td>

<td>0</td>

<td>ZWS</td>

<td>ZWS</td>

<td>S</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>724</td>

<td>0</td>

<td>JRC2</td>

<td>705</td>

<td>0</td>

<td>X</td>

<td>0</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>0</td>

<td>0</td>

<td>ZWS</td>

<td>ZWS</td>

<td>S</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>726</td>

<td>0</td>

<td>JRC3</td>

<td>0</td>

<td>0</td>

<td>X</td>

<td>0</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>0</td>

<td>0</td>

<td>ZWS</td>

<td>ZWS</td>

<td>S</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>727</td>

<td>0</td>

<td>JRC4</td>

<td>0</td>

<td>0</td>

<td>X</td>

<td>0</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>0</td>

<td>0</td>

<td>ZWS</td>

<td>ZWS</td>

<td>S</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>728</td>

<td>0</td>

<td></td>

<td>710</td>

<td>727</td>

<td></td>

<td>0</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>0</td>

<td>0</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>X</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>800</td>

<td>0</td>

<td></td>

<td>60</td>

<td>0</td>

<td></td>

<td>0</td>

<td>7</td>

<td></td>

<td>0</td>

<td>0</td>

<td colspan=3D5 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>920</td>

<td>0</td>

<td></td>

<td>0</td>

<td>0</td>

<td></td>

<td>0</td>

<td>A</td>

<td></td>

<td>4</td>

<td>0</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>X</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>930</td>

<td>0</td>

<td>SKTO</td>

<td>920</td>

<td>0</td>

<td></td>

<td>9</td>

<td></td>

<td>X</td>

<td>0</td>

<td>11</td>

<td colspan=3D5 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>931</td>

<td>0</td>

<td>SKTV</td>

<td>705</td>

<td>0</td>

<td></td>

<td>14</td>

<td>D</td>

<td>X</td>

<td>0</td>

<td>2</td>

<td colspan=3D5 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>940</td>

<td>0</td>

<td>VPRS</td>

<td>0</td>

<td>0</td>

<td></td>

<td>4</td>

<td>B</td>

<td>X</td>

<td>0</td>

<td>0</td>

<td colspan=3D5 style=3D'mso-ignore:colspan'></td>

</tr>

<tr height=3D18 style=3D'height:13.2pt'>

<td height=3D18 style=3D'height:13.2pt'>ZVJHCR</td>

<td>950</td>

<td>0</td>

<td></td>

<td>0</td>

<td>0</td>

<td></td>

<td>0</td>

<td colspan=3D2 style=3D'mso-ignore:colspan'></td>

<td>11</td>

<td>0</td>

<td colspan=3D5 style=3D'mso-ignore:colspan'></td>

</tr>

<![if supportMisalignedColumns]>

<tr height=3D0 style=3D'display:none'>

<td width=3D69 style=3D'width:52pt'></td>

<td width=3D82 style=3D'width:61pt'></td>

<td width=3D54 style=3D'width:40pt'></td>

<td width=3D91 style=3D'width:68pt'></td>

<td width=3D66 style=3D'width:49pt'></td>

<td width=3D50 style=3D'width:37pt'></td>

<td width=3D77 style=3D'width:58pt'></td>

<td width=3D81 style=3D'width:61pt'></td>

<td width=3D54 style=3D'width:40pt'></td>

<td width=3D62 style=3D'width:47pt'></td>

<td width=3D117 style=3D'width:88pt'></td>

<td width=3D121 style=3D'width:91pt'></td>

<td width=3D80 style=3D'width:60pt'></td>

<td width=3D111 style=3D'width:83pt'></td>

<td width=3D34 style=3D'width:26pt'></td>

<td width=3D69 style=3D'width:52pt'></td>

<td width=3D147 style=3D'width:110pt'></td>

</tr>

<![endif]>

</table>

Edited by: Somar on Feb 28, 2011 1:08 PM

[Former Member]

Hi, statistical just means that the condition is not posted to accounting. A statistical condition can indeed add into a subtotal or base value for another condition/step that is accounting relevant.

Your JRC4 condition doesn't show line 15 as a base - although if you don't have the JRC1/2/3 on the same line item as the JRC4 - line 15 eventually feeds into line 705. (Normally this shouldn't happen expect if you are dealing with the July 2010 transition rules for ON and BC.)

You have some formulas. What might be causing the issue are group conditions with formulas. If you are accumulating a value somewhere as a base (i.e. in a work variable) the group condition may be causing this to accumulate twice. The PRICING is done a 2nd time for group conditions - so you have to be very careful with formulas. (The Canadian tax conditons are normally group conditions - the setting is on the FI condition.) I had to dynamically turn off the group setting for the HST conditions when calculating transitional amounts - because the pricing iterations for the group calculation wouldn't work.)

[Former Member]

Thanks Joshua.

I have limited knowledge of pricing, will approach this step by step.