Options

Factbox Temporary table NAV2013

WojtekmWojtekm Member Posts: 123
edited 2013-09-23 in NAV Three Tier
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?

Answers

  • Options
    thegunzothegunzo Member Posts: 274
    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 ?
    ________________________________
    Gunnar Gestsson
    Microsoft Certified IT Professional
    Dynamics NAV MVP
    http://www.dynamics.is
    http://Objects4NAV.com
  • Options
    WojtekmWojtekm Member Posts: 123
    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.
  • Options
    WojtekmWojtekm Member Posts: 123
    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.
  • Options
    thegunzothegunzo Member Posts: 274
    That is the way to do it...
    ________________________________
    Gunnar Gestsson
    Microsoft Certified IT Professional
    Dynamics NAV MVP
    http://www.dynamics.is
    http://Objects4NAV.com
Sign In or Register to comment.