Sales tax doubled? Uses statistical condition type in base calculation?
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