Item Ledger Entry.. Need a help!

Becka

Hi to all! I have a problem with that table.. So, I need to COPY selected Lines and make operations then.. But for example when i use to copy records FIELD - Cost Amount (Actual) is zero.. I know it's linked to the Value Entry table.. But when i'm trying to calculate it with functions(CALCSUMS/CALCFIELDS) it fails.. What to do? I've no ideas so help me plz.. thanks a lot

Slawek_Guzek

You are trying to use CALCSUMS or CALCFIELDS ?

CALCSUMS will fail if you don't select proper key before calling CALCSUMS, or if you put any filter on a field which is not included in selected key.

Both CALCSUM and CALCFIELDS will fail if you try to use * or ? characters in your filter.

Regards,
Slawek

Becka

I have Document No. Document Type... and it doesn't work

philippegirod

In Item Ledger Entry you may have many lines with the same Document No. and Document Type. The best would be to use the primary key (Entry No.) or, at least, something allowing to be sure you have only one line (for instance, if FINDFIRST THEN etc..).

Becka

Thanks fo help... Done with that