Payment Report.

Comments

• Options

  philippegirod Member Posts: 191

  2009-06-19

  I don't know if a report already exists, but if you build the report, a field in the Vendor table gives the sum of payments .
  
  Payment field displays the total amount that has been paid to this vendor. If you invoice a vendor in more than one currency, you should use Payments (LCY) field.

  My candle burns by both ends, it will not last the night,
  But oh my foes and oh my friends, it gives a lovely light

  0
• Options

  Savatage Member Posts: 7,142

  2009-06-19

  How about Report 10103 Vendor Account Detail
  
  Set Date Filter For the Month You Want
  Under the Vendor Ledger Entry Tab set Document Type = Payment

  Harry Ruiz
  http://www.BiloBeauty.com
  http://www.autismspeaks.org

  0
• Options

  jgudmundsson Member Posts: 13

  2009-06-20

  You can not achieve this using account schedules or analysis views, unless you create a separate dimension value for each vendor. (You might want to do this with code, but it will bloat the dimension value table.)
  
  The simplest way to do this on a form level is to design the vendor list / customer list forms to show Payments (LCY) field, and use the datefilter in field filters to limit for a particular month. Then you can export to excel using copy paste or the stylesheet buttons, and sort there if you are interested in who you are paying or collecting from the most.

  iNECTA LLC (a Dynamics NAV Implementation Partner)
  http://www.inecta.com

  0