Vendor Ledger entry filters Amount LCY colnmn

jannestigjannestig Member Posts: 1,000
This is more just a general question about how correct the standard filter applied from the LCY column sums the detailed ledger entries

the filter used is
Field Filter
Entry Type Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'

I have seen this give incorrect information to customers in certain scenarios leading to them believing an oustanding balance exists when it does not

Just have general ffeback is this filter correct or incorrect ?

Currency Code Original Amount Amount Amount (LCY)
USD 10,979.85 10,979.85 14,225.90

Posting Date Entry Type Document Type Document No. Vendor No. Currency Code Amount Amount (LCY)
31/10/10 Initial Entry Payment G04196 xxxxxx USD 10,979.85 7,903.22
01/11/10 Realized Gain Payment G04196 xxxxxx USD 0.00 6,322.68

Posting Date Entry Type Document Type Document No. Vendor No. Currency Code Amount Amount (LCY)
31/10/2010 Initial Entry Payment G04196 xxxxx USD 10,979.85 7,903.22
01/11/2010 Realized Gain Payment G04196 xxxxx USD 0.00 6,322.68
01/11/2010 Application Payment G04196 xxxxx USD -10,979.85 -7,903.32
01/11/2010 Correction of Remaining Amount Payment G04196 xxxxx USD 0.00 -6,322.58

Comments

Sign In or Register to comment.