Versions Compared

Old Version 4

changes.mady.by.user Joseph Castillo

Saved on

compared with

New Version 5

changes.mady.by.user Joseph Castillo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added Tax Exempt

7/2/14

Table: ItemSale, Column(s) added

NameData TypeAllow NullsDefaultNotes 

TaxExempt

boolTrueNull

Negates an order item was marked tax exempt. i.e. the staff member made a tax adjustment and set

the order item to be tax exempt.

  • When an order item is marked tax exempt an ItemSaleAdjustment record is add with AdjustmentTypeName="TaxExempt"
TaxForgivenDecimalTrue0

The amount of Tax which was forgiven due to TaxExempt being true.

  • The TaxAmount column will report 0 when the TaxForgiven column has a value.

 

Table: ItemSaleAdjustment, Enumeration added

ColumnEnum ValueNotes 

AdjustmentTypeName

"TaxExempt"

Each time the staff applies a tax exempt adjustment to an order item a record is added to the ItemSaleAdjustment table. The AdjustmentTypeName is set to "TaxExempt"

  • Note: You should block "TaxExempt" adjustments from your application if it's reporting all records in the ItemSaleAdjustment table for Sales Adjustment calculations,

 

2/17/14

Table: ItemSale, Column(s) added

...