x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 1 reply
  • Subscribers 55 subscribers
  • Views 734 views
  • Users 0 members are here
Browse Forums
Announcements
764
topics
17
replies
Financial year end
78
topics
178
replies
General Discussion UK
7k
topics
19k
replies
General Discussion Ireland
176
topics
312
replies
Install your software
139
topics
378
replies
Making Tax Digital
286
topics
692
replies
Manage your VAT
151
topics
324
replies
Protect and repair your data
45
topics
137
replies
Run your accounts remotely
86
topics
198
replies
Working with the bank
116
topics
294
replies
FormerMember

Aged Creditors Report - customise

SOLVED
Posted By FormerMember

Hi,

I'm wanting to created a customised report for the Aged Creditors so I can see a list of suppliers that we DO NOT pay by DD/SO.

The simplest way I can think to do this is to filter the report to exclude the suppliers that have DD/SO set as the payment method but for the life of me I can't find the field. Does anyone have any ideas of what the field is called and what table it's stored in?

Thanks in advance.

Rob 

  • 0
    verified answer

    Hi Rob,

    Thanks for using Sage City.

    You could use

    PURCHASE_LEDGER.PAYMENT_METHOD_ID=1?"BACS":
    PURCHASE_LEDGER.PAYMENT_METHOD_ID=2?"Cash":
    PURCHASE_LEDGER.PAYMENT_METHOD_ID=3?"Cheque":
    PURCHASE_LEDGER.PAYMENT_METHOD_ID=4?"Credit Card":
    PURCHASE_LEDGER.PAYMENT_METHOD_ID=6?"Other":"

    This would show you everyone apart from those with DD as their payment method (PURCHASE_LEDGER.PAYMENT_METHOD_ID=5?"DD/SO":)

    If this has answered your question please click More > Verify Answer.


    Regards,

    Ian

    Sage UKI

*Community Hub is the new name for Sage City