AxaltoMike
New Member
Hello
To create a sales tax report based on table tx2d_det, ar_mstr and ih_hist, what date field should be used to be able to reconcile with the GL for the sales tax account? For invoices, is the field tx2d_post always the invoice posted date? For ar_mstr, is ar_tax_date also the invoice post date? I see that tx2d_effdate is equal to the ship date of the invoice, which date is also stored in ih_ship_date and ih_tax_date. These dates are not the same as ar_tax_date.
Any info appreciated.
rds
Mike
To create a sales tax report based on table tx2d_det, ar_mstr and ih_hist, what date field should be used to be able to reconcile with the GL for the sales tax account? For invoices, is the field tx2d_post always the invoice posted date? For ar_mstr, is ar_tax_date also the invoice post date? I see that tx2d_effdate is equal to the ship date of the invoice, which date is also stored in ih_ship_date and ih_tax_date. These dates are not the same as ar_tax_date.
Any info appreciated.
rds
Mike