0

Getting total customer ledger entries by sell to customer

Jet Reports Historic Posts

April 27, 2016 11:08

None

Follow

Hi

When using the table builder i want to create a report that gives me a total spend of sales by customer

is there a way to create a report that gives a total of the invoiced amount by sell to account.

the current process i am using only brings up the first cust ledger entry.

tables included are

Customer
No & Name
Bill to Customer

Cust Ledger Entry Table
Sell to customer and link the sell to to the No
Sales (LCY)

Add in a filter for the posting date.

The report is only showing the first entry when what i want is the total sales for the month

thanks

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts April 27, 2016 17:27

  Hello sliderxb,
  
  Take a look at the attached screenshot.
  When adding "Sales (LCY)" you need to add it via the "Sum Fields" section while selected on the "Cust. Ledger Entry" table rather than via the "Fields - Cust. Ledger Entry" section.
  
  Best regards,
  MWilson
  
  

• 0
  
  Jet Reports Historic Posts May 04, 2016 08:19

  Brilliant
  
  thanks for the help:-)