Lookup to Item Turnover Lines

david.weeks

Hello All

Within standard Navision item card, within menu, there is an option to view Turnover within statistics.

How do you call this if you are using a lookup button on a field?
i.e. In code?

This is strange because the source of the Form 354 is date.
Ideas?

Thanks

david.weeks

Hello All,

Further to this, I am trying various methods and am now getting this message:

"Copying all filters at once can only be done between records belonging to the same table

Date <- Item

Copy record filters one at a time."

Any ideas on what I need to do to copy filters one at a time within code for the lookup of the text box.

Currently I am using the following that gives me the above message:

CLEAR(GfrmItemTurnover);
GrecItem.SETFILTER("No.", Rec."No.");
GfrmItemTurnover.SETTABLEVIEW(GrecItem);
GfrmItemTurnover.SETRECORD(GrecItem);
GfrmItemTurnover.RUNMODAL;

Thanks

Savatage

maybe i misiing the point but i have an Item Turnover report in the Inventory section. Couldn't you just call the report & not use the statistics part?

david.weeks

Hi,

Unfortunately, I need to pass in the item number to the item turnover form.

If I just call the report, no data appears.

I am out of ideas really.

Thanks anyway

DenSter

The Item Turnover form (number 158) has the Item table as its source table. You should be able to use SetRecord. I think you are looking at the Item Turnover Lines form (number 354), which is a subform on the Item Turn over form.

<edit>ok so I read your initial question again and you ARE using the subform. Use the actual form and try again. Your code with the SETRECORD method should work. btw, comment out the SETTABLEVIEW line, that's not necessary</edit>

david.weeks

Hi "DenSter"

Thank you very much.
How did I miss that? I can't believe it.

Thanks again

Cheers