Item Card AutoCalc Field broken?

Reinhard · 2008-10-09

Hi...

A client is accessing the item card from the sales order card. Then they search for a different item (settings: - any part of field, find as you type is Off) and when the new item record is found, the qty. on purchase, component lines, etc flowfields are not calculated. They always show zero. The control settings have autocalcfield as Yes. It normally works fine. I can NOT repeat this bug :bug: on my workstation, but others say they have seen this before also.

Thank you for taking your time to help me with this!

- Reinhard

here is the code to open the item card:
SalesInfoPaneMgt.LookupItem(Rec);
(Rec is a sales line)

which in turn ends up calling:
FORM.RUNMODAL(FORM::"Item Card",Item);

DaveT · 2008-10-09

Hi Reinhard,

Check that a flowfilter is not set/being set when in the item card...the most likely suspect is the date filter.

Reinhard · 2008-10-09

I see that dateFilter = ''..10/19/08 (sales line due date)

Hi Dave, so your instint was correct, but to be honest I am still confused what to do.
Specifically:
- how is the date filter being set? (all I see is a Item.GET(No.) statement)
- should I remove it?
- and what exactly is a flowFilter?

sorry to ask you all these questions but a couple hints are always helpful

thank you
- Reinhard

DaveT · 2008-10-09

Hi Reinhard,

1.This is a tricky one to track down. The function that is setting the filters is SalesInfoPaneMgt.CalcAvailability which is called because it is in the source expression for availability on the info panel. The currform.updatecontrols fires this from the onaftergetcurrrecord.

2. Should you remove? :-k - The idea (which is sound) is to show you the item picture as at the time of shipping. You could reset the filter for the item card lookup but discuss this with the customer.

3. A flowfilter is a filter that does not filter the records in the table but can be used to filter the data in the underlying table of a flowfield. i.e. you have 100 in inventory which is made up of 10 LocA1, 20 LocB1, 30 LocC1, 40 LocA2. Then a flowfilter on location filter LocA* will return a value of 50.

Hope this helps.

Reinhard · 2008-10-09

wow. very helpful. many thanks.

flowfilter - I had to read that a couple of times but yes, it makes sense.

DaveT · 2008-10-09

Glad to Help

Item Card AutoCalc Field broken?

Answers

Categories