• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

E8.1 Tax calculation based on drop ship address

pclara74

Active Member
Hi All,
Company has decided to expand ecommerce sales and with this we are trying to create sales orders using a house account with drop ship addresses.
any suggession how we can setup taxees based on the drop ship zip code?

Thanks,
Clarence
E1 8.11
 

jdedwardsuser

Active Member
We do something similar with our B2C business as well and integration with jde . We have one house account for each MCU /warehouse location we ship out of . Now each warehouse location has a definite set of zip codes they cater to . All those zip codes are then cross referenced via a custom cross reference setup in jde to which tax rate area should be applied on sales . In our EDI interface process , when we get the ship to address of the customer , we use that and cross reference wih our setup to find the tax rate area and map that into F47011 and F47012 and then it takes it from there .
 

jdedwardsuser

Active Member
If you are not using interface , then may be an after process to parse through orders with those house accounts and check the override address info in F4006 and then update the sales table for tax rate area might work as well , like a post update UBE process
 

pclara74

Active Member
We do something similar with our B2C business as well and integration with jde . We have one house account for each MCU /warehouse location we ship out of . Now each warehouse location has a definite set of zip codes they cater to . All those zip codes are then cross referenced via a custom cross reference setup in jde to which tax rate area should be applied on sales . In our EDI interface process , when we get the ship to address of the customer , we use that and cross reference wih our setup to find the tax rate area and map that into F47011 and F47012 and then it takes it from there .

Hi,
Thanks for you reply and we are also going to use interface programs as you did and also we do have 4 locations in states. but we may not be able to create multiple accounts since some times we may have split shipments between branches. btw, how many rate area's you had to create based on zip codes?
 

jdedwardsuser

Active Member
Hi,
Thanks for you reply and we are also going to use interface programs as you did and also we do have 4 locations in states. but we may not be able to create multiple accounts since some times we may have split shipments between branches. btw, how many rate area's you had to create based on zip codes?
In our custom cross reference utility for ADDZ to refer the tax rate and rout it will go to based on zip code ,we have close to 5000 records as of now . In actual tax rate area file thats config and that has nothing to do with this functionality . You need those anyway for correct tax and revenue and finances
 
Top