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

[Former Member]

Hi,

At least in the french personalization it's possible, so I guess you can also in other ones.

Administration - Setup - Financials - G/L Account Determination and either you BP is a sales or purchasing partner, go to the corresponding tab.

Then check the option "Permit change of Control Accts".

After this, for each of the BP that you want, you can have different accounts (don't forget to create them all (the accounts) and to make them of type Control Account.

I'm using it every day...

regards,

Eric

[former_member583013]

Clinton,

Out of the box this feature is not available. Since I have had Clients ask for this, I have in the past created a work around by creating a User field on the BP Master Data.

Use this field to store the G/L Account that you would like to associate with ths BP.

Create a formatted search in the A/P Invoice to select the G/L Account from this Vendor Master User field.

Let me know if you would like to go this direction and need further assistance.

best wishes

Suda

[Former Member]

Suda -

Yes, I need some additional information on how to create that querry.

Can you help me?

[former_member186095]

It seems difficult to do that cos there is no specific field to define expense account in the vendor BP. You need a customisation to do that. Why do you try to set per vendor ? try to use control accounts - account payables on tab accounting in the BP. Another solution maybe keep the expense account just one ccount but using project code field to differentiate one vendor to other vendor in using the expense account