0

Compare two fields from the same table

Jet Reports Historic Posts

February 02, 2008 12:05

None

Follow

Dear All,

Seasons Greetings…

I am not getting the proper values when i am comparing two fields from the same table. I am using Item Ledger Entry Table.
The Secenario is like:

I would like to design a report such that i should display all the Document Nos. along with the required fileds grouped on Source No. where, quantity is not equal to invoiced quantity. , which means "Stock received but not invoiced".

Suggest me this case

Regards

Gowri Shanker

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts February 03, 2008 11:47

  Hi Gowri,
  
  If I get you right you need 2 NL functions to build the report:
  - 1 to group the source nos;
  - 1 to retrieve the document details per vendor (document nos, item nos, quantities etc.)
  In your posting you refer to stock received so the source nos. refer to vendor nos.
  
  Group the source nos
  In Cell C4 you could enter a function that build the groups:
  =NL("Rows=3";"Item ledger entry";"Source no.";"Source type";"Vendor";"Document no.";"=IF(NF(;""Quantity"")<>NF(;""Invoiced quantity"");NF(;""Document no.""))").
  
  Retrieve the details per vendor
  In Cell D5 you could do it like this:
  =NL("Rows";"Item ledger entry";;"Source no.";"Vendor";"Source no.";$C4;"Document no.";"=IF(NF(;""Quantity"")<>NF(;""Invoiced quantity"");NF(;""Document no.""))")
  And then of course you need a couple NFs on Row D6 to get some information in the report.
  
  Please let me know if these functions work for you.

• 0
  
  Jet Reports Historic Posts February 04, 2008 07:28

  Hi Han Fousert
  
  Thank You Very Much
  
  I could able to solve my query with ur help..
  
  Thanks and Regards
  
  Gowri Shanker