top of page
Search
  • ABS
    • Oct 23, 2021
    • 1 min read

iVend Discount

You can get all discount from TrxTransactionSaleItem table Field: ManualDiscountAmount: user manual enter discount SystemDiscountAmount: system get discount from special price CouponDiscountAmount: discount from coupon PromotionalDiscountAmount: discount from Promotion DiscountAmount= ManualDiscountAmount+ ManualDiscountAmount+ CouponDiscountAmount+ PromotionalDiscountAmount SaleDiscountAmount: the discount from header (TrxTransaction.DiscountAmount) is allocated to each line. So total discount of each line will be = DiscountAmount+SaleDiscountAmount


10 views0 comments

Recent Posts

See All

SAP B1/iVend- Query Inventory In SAP

Check inventory audit in SAP select  a.CreateDate, b.USER_CODE as [User], a.TransType SAP_DocType, case when a.TransType = 13 then  'Sale Invoice' when a.TransType = 14 then  'Sale Credit Note' when a

ivend-SAP Integration Monitor from SBO to ivend Query

Select IntegrationKey,Cast(SourceType AS Varchar(20)) As SourceType,SourceKey, OperationType, isNull(LogDatetime, getdate()) As LogDatetime, Case isNull(Status, 0) When 0 Then 'Not Processed' Else 'Fa

Post: Blog2_Post
bottom of page