Factbox Temporary table NAV2013

Wojtekm · 2013-09-19

I need to add some factboxes to list page with propoerty:
SourceTableTemporary = Yes

I follow this post:
viewtopic.php?f=5&t=20084&hilit=singleinstance&start=15

The problem is there is no possibility to run any factbox function page from list page code.
Form C/AL symbol menu i can`t see any fyunctions from factbox page.

I`ve tried to use SourceTableTemporary on factbox page but with no success.
Is there any other opition to control data on factbox?

thegunzo · 2013-09-19

Is there a table with data that is the source table for your temporary table ?
Do you have the primary key of that table in you temporary table, can you then use that table for the factbox ?

Wojtekm · 2013-09-20

I have source table: sales line (temporary) on list page.
This sales lines came from my query and sum quantity values from original sales line (stored in DB) to one temp sales line per Item No. and Sell to Customer No.
That why i create another key for my temp lines (one temp line = many records in DB).
My factbox is based on temporary table also. But when i check how it works in debugger all values form record is empty.

SubPageLink: Document Type=FIELD(Document Type),Document No.=FIELD(Document No.),Line No.=FIELD(Line No.)

In tem sales line rec:
Document Type is always = Quote (default Value)
Document No = (empty value)
Line No = Different for each record, dynamic assined to each temp record.

Form temp sales line i need to transfer Item No. to factbox to see item on hands and some other values.

So there is no relation from my temp sales line to original sales line.

Wojtekm · 2013-09-20

I`ve made it using factbox based on Item table (not temporary) and link int to list page by Item."No."

My problem was propably linking FactBox to Record that does not exist i DB.

It works as a charm.

thegunzo · 2013-09-23

That is the way to do it...

Factbox Temporary table NAV2013

Answers

Categories