0

Combine Sales Header & Sales Line information

Jet Reports Historic Posts

September 04, 2008 20:49

None

Follow

Hi there, I am so new to Jet Reports and I'm still fumbling my way through everything. I'm trying to combine information fromthe Sales Header & the Sales Line in order to get a report we use for inventory purposes. I can get the informatin seperately, but as soon as I try to combine them it's all over. Any suggestions?

Thanks :shock:

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts September 05, 2008 10:08

  Here are of couple of suggestions that may help you with your question:
  
  Functions:
  The Jet Reports functions you need are called NL("Filter") and NL(…."Link=")
  Information about these functions may be found in the Jet Reports Help in Excel and PDF file. Look for "Filtering based on data from another table". Another way to learn about these functions is to attend a Jet Reports training coures. The Jet Reports Team in Portland has great classes to offer - been there, done it, got the t-shirt :)
  
  Nav:
  The link between the sales header and sales line is based on 2 fields: Document type and document no.
  Document type descibes the document process e.g. quote, order, return order etc. You will not find this field on the standard form, but if you use tools, zoom you will find it.
  he document no. is then the quote no, the order no. etc.
  In sales header the fields are called "Document type" and "No.", in sales line "Document type" and "Document no."
  
  Examples (please read the Help for further explanation):
  1) you want to retrieve all sales order headers from January 2008 in which item 1928-S is sold:
  =NL("Rows","Sales header",,"Document type","Order","Posting date","01/01/2008..01/31/2008","Link=","Sales line","Document no.","=No.","Document type","Order","Type","Item","No.","1928-S")
  2) you want to retrieve all sales order lines from January 2008 in which item 1928-S is sold:
  =NL("Rows","Sales line",,"Document type","Order","Type","Item","No.","1928-S","Document no.",NL("Filter","Sales header","No.","Document type","Order","Posting date","01/01/2008..01/31/2008"))
  
  Please let us know if this is what you were looking for.

• 0
  
  Jet Reports Historic Posts June 10, 2010 09:10

  Hi there :)
  
  I experience a similar problem. I want to retrieve the dimension value from a Cust. Ledger Entry but because it's dimension 4, I look in Ledger entry dimension table. Although the code looks correct I get the "Calculation deferred" message on the filter.
  
  Here is the fromula I used:
  
  =NL("Rows","Cust. Ledger Entry",,"Entry No.",NL("Filter","Ledger Entry Dimension","Entry No.","Dimension Value Code","GDEL","company=","BBL Limited_Unposted"),,,,,,,,,,,,,,,,,"company=","BBL Limited_Unposted")
  
  Thanks in advance!