User Defined Payment Field - Supplier

[daeco]

When adding a supplier on the Bank Details screen there is a drop down Payment field which lists BACS, Cash, Cheques etc it also has User Defined 1 - 5 fields, please can someone advise how I am able to edit the User Defined 1 to an appropriate payment method (ie I want to add Visa Debit Card).

Running Sage 50 Professional

Thanks

[brucedenney]

In version 2011 (You don't say which version you are using)

Press the button with three dots in it to the right of the drop down and you can edit the labels on the user defined options.

[pauljj]

Hi,

Is there anyway to show these methods on a report ?
i can find the payment method ID on the purchase ledger, but not the actually the method name.
I'm using v24
Thanks
Paul

[brucedenney]

You can do it.

See attached sample report and PDF of the result

What you need to do is to go to Report>Joins and add the table "PAYMENT_METHOD"
Now create a link between the PAYMENT_METHOD_ID field in the PURCHASE_LEDGER table and the UNIQUE_ID in the PAYMENT_METHOD
You do this by dragging and dropping one field on the other.

Back in the maid report window you will now have the PAYMENT_METHOD table and you can add the DESCRIPTION field from that table to the report.

Hope this has been of help.

Bruce

[pauljj]

Hi Bruce,

Thanks you so much for this work, you've helped me with Joins before, so it was good to know how to do this again.
This is perfect .

thanks
Paul