Zaokruzivanje fiskalni vp - feninzi

potrebno view korigovati

alter VIEW [dbo].[vHE_MoveItemOut]

AS                              

SELECT I.acKey, I.anNo, I.acIdent, I.acName, I.anQty, I.anQtyConverted, I.anQtyTemp, I.acUM, I.acUMConverted, I.anPrice, I.anRebate, I.anRebate1, I.anRebate2, I.anRebate3, I.acVATCode, I.anVAT, ROUND(I.anVAT,0) anVATRound, I.anStockPrice,

       I.anPriceCurrency, I.acLnkKey, I.anLnkNo, I.anTransport, I.anDuty, I.anDirectCost, I.anIncTax, I.anRTPriceP, I.anRTPrice, I.acRMAFault,

       I.anSalePrice, I.anWSPriceP, I.anWSPrice, I.anWSPrice2P, I.anWSPrice2, I.anPackQty, I.acPackNum, I.anWarrenty, I.acFieldL,

       I.acAcctCR, I.acOrigin, I.acDeclarForOriginType, I.anExcise, I.anExciseP, I.acDept, I.acVATCodeTR, I.anVATIn, I.adDate, I.anFixPriceDiff,

       I.acCostDrv, I.anVType, I.anDimVolume, I.anDimWeight, I.anDimWeightBrutto, I.anInWSPrice2P, I.anInWSPrice2, I.anInWSPriceP, I.anBeatShare,

       I.anInWSPrice, I.anInRTPriceP, I.anInRTPrice, I.anInSalePrice, I.anWOPrice, I.acNote, I.adTimeIns, I.anUserIns, I.adTimeChg, I.anUserChg,

       I.anPVForPay, I.anPVVAT, I.anPVExcise, I.anPVVATBase, I.anPVDiscount, I.anPVValue,

       I.anPVOCForPay, I.anPVOCVAT, I.anPVOCExcise, I.anPVOCVATBase, I.anPVOCDiscount, I.anPVOCForPay /(1 + (I.anVAT / 100)) as anPVOCValue,   --I.anPVOCValue

       I.anPVValue - I.anPVDiscount AS anVPrice, DivT.anValue AS anPriceRebate,

       I.anDimWeight * I.anQty AS anVDimWeight,

       I.anDimWeightBrutto * I.anQty AS anVDimWeightBrutto,

       I.anDimVolume * I.anQty AS anVDimVolume, I.anRetailPrice,

       I.anPrsn3Price, I.anUMToUM3, I.acUM3, SI.anMinMargin, I.anExciseInc, I.anExciseNotInc, I.anExciseIncP, I.anExciseNotIncP,

       I.acAcctClaim, SI.acCustTariff,SI.acActive, I.acUM2, I.anVATAfterDeduction,I.anValueAfterDeduction,I.anVatValueAfterDeduction, I.acDistributeCosts,

       I.anStockPrice * I.anQty AS anValue, I.anUMDecPlaces, I.anRTPriceConverted, I.acExemptFromVATSType, I.anQId, SI.acSetOfItem

   FROM tHE_MoveItem I

        --join tHE_Move G on I.acKey = G.acKey

        LEFT OUTER JOIN tHE_SetItem SI ON SI.acIdent=I.acIdent

        CROSS APPLY dbo.fPA_DivT_ITF(I.anPVValue - I.anPVDiscount, I.anQty) DivT