Cust./Vend. Ledger Entry Bug or what?

merana

Hi,

I wonder did anyone notice and knows is there any purpose that fields Amount and Amount (LCY) in table Customer/Vendor Ledger Entry have the same CalcFormula?!
They are both reffer to the same field in detail. cust/vend. ledg. entry - AMOUNT.

Is there reasone for that (???), or it is just a small bug?

Tnx, in advance!

HalMdy

Wich version do you use ?

In my 3.10 version, it seems to be ok. Bug in a earlier release ?

merana

No it's 3.60?!

Strange isn't it?

CHEMINTEL

I have 3.60, and I have two diferent calcformula:

for amount field:
Sum("Detailed Cust. Ledg. Entry".Amount WHERE (Cust. Ledger Entry No.=FIELD(Entry No.),Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Expenses|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'),Posting Date=FIELD(Date Filter)))

for amount (lcy)
Sum("Detailed Cust. Ledg. Entry"."Amount (LCY)" WHERE (Cust. Ledger Entry No.=FIELD(Entry No.),Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Expenses|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'),Posting Date=FIELD(Date Filter)))

kine

May be error from your previous upgrades?

merana

Thanks for opinions!

Maybe it's an error that is made with localization.
Our first instalation and to few clients-customers was 3.60. Really funny!