Thread Rating:
  • 1 Vote(s) - 1 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Customer Maintenance: Tax Reference field
12-27-2017, 01:03 PM,
#11
RE: Customer Maintenance: Tax Reference field
Okay then... Here is what I have after Round Two...

I simply created a Tax Group with each possible tax rate for FL so it can be associated with each FL Branch. I then created a Tax Authority for each Tax Group and assigned the applicable tax rate. Basically a one-to-one relationship and a bit if a hack to get us going.

INSERT INTO `taxauthorities` (`taxid`, `description`, `taxglcode`, `purchtaxglaccount`, `bank`, `bankacctype`, `bankacc`, `bankswift`) VALUES
(1, '6.0% Sales Tax', '2320', '2330', '', '', '', ''),
(2, '6.5% Sales Tax', '2320', '2330', '', '', '', ''),
(3, '7.0% Sales Tax', '2320', '2330', '', '', '', ''),
(4, '7.5% Sales Tax', '2320', '2330', '', '', '', ''),
(5, '8.0% Sales Tax', '2320', '2330', '', '', '', '');

INSERT INTO `taxauthrates` (`taxauthority`, `dispatchtaxprovince`, `taxcatid`, `taxrate`) VALUES
(1, 1, 1, 0.06),
(1, 1, 2, 0),
(1, 1, 3, 0),
(1, 1, 5, 0),
(2, 1, 1, 0.065),
(2, 1, 2, 0),
(2, 1, 3, 0),
(2, 1, 5, 0),
(3, 1, 1, 0.07),
(3, 1, 2, 0),
(3, 1, 3, 0),
(3, 1, 5, 0),
(4, 1, 1, 0.075),
(4, 1, 2, 0),
(4, 1, 3, 0),
(4, 1, 5, 0),
(5, 1, 1, 0.08),
(5, 1, 2, 0),
(5, 1, 3, 0),
(5, 1, 5, 0);

INSERT INTO `taxcategories` (`taxcatid`, `taxcatname`) VALUES
(1, 'Taxable Supply'),
(2, 'Luxury Items'),
(3, 'Exempt'),
(5, 'Freight');

INSERT INTO `taxgroups` (`taxgroupid`, `taxgroupdescription`) VALUES
(1, 'Exempt'),
(2, '6.0% Sales Tax'),
(3, '6.5% Sales Tax'),
(4, '7.0% Sales Tax'),
(5, '7.5% Sales Tax'),
(6, '8.0% Sales Tax');

INSERT INTO `taxgrouptaxes` (`taxgroupid`, `taxauthid`, `calculationorder`, `taxontax`) VALUES
(2, 1, 0, 0),
(3, 2, 0, 0),
(4, 3, 0, 0),
(5, 4, 0, 0),
(6, 5, 0, 0);

INSERT INTO `taxprovinces` (`taxprovinceid`, `taxprovincename`) VALUES
(1, 'State Sales Tax');
https://www.linkedin.com/in/eclipsepaulbecker
Reply


Messages In This Thread
RE: Customer Maintenance: Tax Reference field - by VortecCPI - 12-27-2017, 01:03 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)