Default BP (Vendor) GL Expense accounts

[Former Member]

How do you set up a default GL- Expense account for a particular BP (Vendor) ???

[former_member583013 · Accepted solution]

Hello Clinton,

Sorry I did not see you message till now.

Create a User defined field by going to Tools > User-Defined Fields > Manage User Fields... Master Data.. Business Partner.

Create a Formatted Search using the SQL below and link it to this User field in the BP Master. This lets the user select the G/L Account to Associate without any typing errors.

SELECT T0.FormatCode AS 'Format Code' FROM [dbo].[OACT] T0

WHERE T0.FormatCode IS NOT NULL

Create a formatted search in the A/P Invoice to select the G/L Account from this Vendor Master User field. Lets say your Vendor GL user field is U_GL, then the SQL would be

SELECT T0.U_GL FROM [dbo].[OCRD] T0 WHERE T0.CardCode = $[$4.1.0]

Link this FMS to the G/L Account field at the row level.

Hope this helps

Suda