0

Customer statement

Jet Reports Historic Posts

April 08, 2014 21:42

None

Follow

We are trying to set up a customer statement. that shows the
bill to customer Balance
Address
City state zip code

in that type of format.

Under each bill to customer - pull from the sales invoice line for information about the customer the item was sold to.
Customer Name, description, Amount including tax,


How do we get the mailing address to appear in this format. and what would be the procedure to get the information we want in the secondary section of the report?

Thanks for any help

Elsie M

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts April 11, 2014 08:14

  Hi,
  do you want to get the mailing address belonging to the bill-to-customer-no?
  Is the mailing address a field in the table "customer"?
  
  then: (eg bill-to-customer-no in $D3)
  =NL("First";"Customer";"E-Mail";"No.";$D3) :?:
  
  regards
  jetsetter