SQL View On Vendor EFT

Microsoft Dynamics GPI’ve created a number of small views to report on vendor related information (such as email remittance and email addresses) and have recently followed up with another script which returns bank details for vendors:


CREATE VIEW uv_AZRCRV_VendorAddressElectronicTransferMaster AS

SELECT
	['Address Electronic Transfer Master'].VENDORID AS 'Vendor ID'
	,['Address Electronic Transfer Master'].ADRSCODE AS 'Address Code'
	,['Address Electronic Transfer Master'].BANKNAME AS 'Bank Name'
	,['Address Electronic Transfer Master'].EFTBankCode AS 'Bank Sort Code'
	,['Address Electronic Transfer Master'].EFTBankAcct AS 'Bank Account'
FROM
	SY06000 AS ['Address Electronic Transfer Master']
WHERE
	['Address Electronic Transfer Master'].SERIES = 4
GO

GRANT SELECT ON uv_AZRCRV_VendorAddressElectronicTransferMaster TO DYNGRP
GO

This script returns the fields I was interested in for a client, but could easily be extended to include additional fields from the EFT table.

Can ISC Software help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you would like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.

Your Name

Your Email

Subject

Your Enquiry

What should we write about next?

Your Name

Your Email

Suggested Topic

Suggestion Details

2 thoughts on “SQL View On Vendor EFT

  1. Pingback: Comment
  2. Pingback: Comment

Leave a Reply

Your email address will not be published. Required fields are marked *