Skip to Content
author's profile photo Former Member
Former Member

Default BP (Vendor) GL Expense accounts

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 11:25 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 26, 2007 at 11:24 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 26, 2007 at 11:57 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 07:47 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.