Dirty Butter Posted December 29, 2014 Share Posted December 29, 2014 We had a recent situation where someone living in our state had an item delivered to another state. On checking the Sales Report for this month, I see that it showed the State as being Alabama, when it should have shown Arkansas for tax purposes. I changed reports.index.php from <td>{$data.state}</td> to <td>{$data.state_d}</td>. The report appears to be correct now for our needs.This is important for someone like us, where sales tax is figured on the delivery state, in that we need an accurate tax record.It looks like this is a bug. But I think my change needs to be more elegant, based on tax on billing or on delivery state. Any thoughts on this? Quote Link to comment Share on other sites More sharing options...
bsmither Posted December 29, 2014 Share Posted December 29, 2014 So, according to what you have said, in your Store Settings, General tab, you should have "Tax Customer by" => Delivery Address. Calculated taxes (assuming no other computational bugs) should then be reflected accurately and shown on each order's Order Summary as recorded in the CC_order_summary database table. So, the Sales Report Total Tax column should also be accurate, as would the sum totals at the bottom of the table. I agree that it is misleading in the Sales Report to see a State and Country columns but not know the context: Billing or Delivery (or something else if a mod is in use). Because the controller script, reports.index.inc.php, makes available both billing and delivery, perhaps changing the Sales Report table, in reports.index.php, to show: <td>{$LANG.order_state.tab_billing} {$LANG.address.state}/{$LANG.address.country}</td> <td>{$LANG.order_state.tab_delivery} {$LANG.address.state}/{$LANG.address.country}</td> <td>{$data.state}/{$data.country}</td> <td>{$data.state_d}/{$data.country_d}</td> and add a style to the column if that column represents the configuration setting: {if $CONFIG.basket_tax_by_delivery eq true}style{/if}. Or, based on the config setting, show only what needs to be shown. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted December 29, 2014 Author Share Posted December 29, 2014 I didn't make a change in reports.index.inc.php. I ended up with this on reports.index.php: <!-- SHOWS DELIVERY STATE, COUNTRY IF TAX BASED ON DELIVERY ADDRESS --> {if $CONFIG.basket_tax_by_delivery eq true} <td>{$data.country_d}</td> <td>{$data.state_d}</td> {else} <td>{$data.country}</td> <td>{$data.state}</td> {/if} <!-- END SHOWS DELIVERY STATE, COUNTRY IF TAX BASED ON DELIVERY ADDRESS --> Quote Link to comment Share on other sites More sharing options...
Adam Frey Posted February 7, 2015 Share Posted February 7, 2015 Dirty Butler, How did you generate a report with the state and country? I can't seem to find how to generate this or if there is a mod for this. Please advise as I need this functionality also please. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted February 7, 2015 Author Share Posted February 7, 2015 Bsmither's explanation should work for you. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.