0

Link "Sales Invoice Line" to "Item Ledger Entry" table

Jet Reports Historic Posts

November 05, 2014 22:38

None

Follow

Hello Everyone!

Could you please advise, is it possivle to link Sales Invoice Line to Item Ledger Entry table? I was looking for a common field but wasn't able to find one. Thank you!

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts November 06, 2014 16:00

  I don't know of a way to link them but the bigger question should be why are you trying to link them?
  
  What are you looking to accomplish in your report? Perhaps there is another table/tables that could be used or another method to accomplish what you are looking to do.

• 0
  
  Jet Reports Historic Posts November 07, 2014 02:46

  Thanks for the reply.
  
  I wanted to create a Sales Data Dump report (enclosed) and to have Net amounts, including returns. I was able to accomplish this via Sales Invoice Line but not sure how to incorporate Credit Memos here. Also, I was under the impression that Sales Reports built via Item Ledger ENtry table run faster. Thank you.

  • Sales Data Dump Report - Copy.xlsx