VisionCore How To
Home Search Support Forum Knowledge Base Print

Added Tax fields on Invoices Line Item Grid

This enhancement will give the user to apply tax amount on each Invoice detail. Three column fields have been added on the Invoice form and they are:

 

Tax Amount: This is the (tax code percentage/ 100) * Price

Total Tax: This is Tax Amount * Shipped qty

Total Price: Total column + Total Tax

 

Below is an example:

 

TaxFields_001

 

Here's how the Total Price is being computed without discount:

Scenario 1:

There are two items added in Invoice detail. Select Tax Type on each item. As you notice, Tax Amount and Total Tax is being computed.

 

To get the Total Price of Bed-Fitted Sheet item:

Total Price = Total column  + Total Tax

      = 19.98 + 1.80

      =  21.78

 

To get the Total Price of Bed-Osaka item:

Total Price = Total column  + Total Tax

      = 6,905.45 + 103.58

      =  7,009.04

 

TaxFields_002

 

Here's how the Total Price is being computed with applied discount:

Scenario 1:

There are two items added in Invoice detail. Select Tax Type on each item.Enter the Discount amount for each item.

 

To get the Total Price of Bed-Fitted Sheet item:

 

Tax Amount: This is the (tax code percentage/ 100) * Price - Discount

 

Total Tax: This is Tax Amount * Shipped qty

Total Price = Total column  + Total Tax

      = 17.98 + 1.62

      =  19.60

 

To get the Total Price of Bed-Flat Sheet item:

 

Total Price = Total column  + Total Tax

      = 6,076.80 + 91.15

      =  6,167.95

 

 

 

Reference: Task 4765