Description |
Issue when calling *fnGetItemTaxComputationForVendor* the query will get slow.
Acceptance: Optimize the function to get the tax quickly.
1. Take the back up from below location.
!pastedImage_d88144_0.png!
2. Execute the attached Stored Procedure uspGRProcessSettleStorage and debug by the below SQL.
BEGIN TRAN
EXEC uspGRProcessSettleStorage '129286STR-47Calculate2017-12-12T21:12:03090.57231241155.1906155.19064284512410481242267.84267.84428481241048124338.026638.0266428491241048461.05729.950.410.35'
ROLLBACK TRAN
3. Below high lighted is the time taken for tax calculation of the Vouchers.
!pastedImage_d88144_1.png!
|