User Tools

Site Tools


dynamiczip:tables:dz_zip2_tax_purchase_link_table

DZ Purchase Tax Link table

Display Name DZ Purchase Tax Link
Technical NameKD_PurchaseTaxLink
Physical Name DZ01404
Database COMPANY

This table1) is used to synchronize tax on purchases with tax on sales.

The table is populated during the import of tax on sales. The data in the table is not used unless tax on purchases is subsequently imported for the same state(s).

Background

Most states tax purchases when used internally (use tax). However this tax may not be exactly the same as charged on sales in the same location. For example, quite often use tax is only levied at the state level or maybe the state and county level but more rarely at the city or district level.

Tax on sales and tax on purchases coexist on the same Dynamics GP tax schedule. The DynamicZip import needs to keep the two types of taxes synchronized so that when a tax schedule gets selected based on tax location, that schedule will be correct for use with either tax on sales or tax on purchases.

Function

This table is used to make sure that each sales tax schedule gets the appropriate purchase tax details added to it.


DynamicZip Tables

1)
This table was added with Build 74
dynamiczip/tables/dz_zip2_tax_purchase_link_table.txt · Last modified: 2018/05/03 20:43 by conni

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki