Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 110
  • Last Modified:

Microsoft Dynamics GP 2015 - Vendor Term Discount Smartlist

I am trying to put together a smart list that shows all our vendors that have term discounts. However I am unsure what tables I need to include to determine which vendors offer discounts.
0
ElwayRoy
Asked:
ElwayRoy
1 Solution
 
Victoria YudinCommented:
You can get all the vendors and their payment terms in PM00200. The Payment Terms setup can be found in SY03300. (You can link PM00200.PYMTRMID = SY03300.PYMTRMID.)

If you want to find anything that has a discount percentage, that should be where DSCPCTAM in SY03300 <> 0.
1
 
ElwayRoyAuthor Commented:
Thanks so much!
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now