0

Report from Detailed Cust Ledg Entry with shortcut dimension

Jet Reports Historic Posts

May 01, 2012 01:27

None

Follow

Hi,
i am trying to write a report that pulls information from detailed cust ledger entry table. In addition, I have some shortcut dimension entered in NAV. May i know if there is any dimension tables that is linked to detailed cust ledger entry table? As far as i understand, only customer ledger entry table can link to ledger entry dimension table.


Advices are welcome..

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts May 01, 2012 07:07

  Hi
  Im just guessing but is it possible to use to the document no. from table 359 (posted document dimension) and link that to the document no. from the detailed cust ledger entry ?
  
  -søren

• 0
  
  Jet Reports Historic Posts May 01, 2012 15:44

  You could manually create the link using the same dimension tables that are used for the Cust. Ledger Entry itself as søren suggests. Probably the easier way to do this would just use Link= to link to the Cust. Ledger Entry and then return the dimension or filter on the dimension from the Cust. Ledger Entry table. Does that make sense?
  
  Regards,
  Hughes