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

distribution rule linked to a chart of account

dear experts,

we have creation distribution rules to monitor the sales for each kind of item (seeds, chemicals, others). is there a way to link the totals of each distribution rule/cost center to a g/l account so we can link it on our Profit Loss Statement:

example:

Chart of account: Distribution rule

Sales- Seeds ACS

Sales- Chemicals ACH

Sales-Others AOT

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2012 at 02:31 AM

    hi, so the distribution rule is to collect and distribute all entries posted on a particular G/L account? its not the distribution rule to enter values to the G/L account?

    if so, how can i include the distribution rule sales to my profit loss statement?

    so it would look like this:

    Sales- Seeds

    Sales- Chemicals

    Sales-Others

    our current template is just total SALES its not broken down to items

    Add a comment
    10|10000 characters needed characters exceeded

    • The Profit and Loss Statement shows the values only according to the GL accounts. So if you want to see the distribution there, you should manage to book to different GL accounts.

      Using the cost centers and distribution rules make possible to show the revenue and expenditure according to an independent aspect. The result of setting the distributing rules does not affect the GL accounts the system uses in the booking. It is an (almost) independent parameter in the booking.

      Setting a distribution rule to an account determine only the default distribution rule if the system books to this account. But the used GL accounts are determined by the setting of the item and the then referred accounting source setting.

      So if you want these separate in the Profit and Loss Statement, then you should use the settings I suggested.

  • Posted on Dec 05, 2012 at 07:55 AM

    Hi Carlo,

    Yes you can connect the Cost Center to the GL accounts through selecting the Distribution Rule tick mark in the left side of Chart of Accounts.

    Regards,

    Azeem

    Add a comment
    10|10000 characters needed characters exceeded

    • Connecting a distribution rule to a GL account is for defining the default distribution rule for the account.

      If you want to book the different kindes of items to book to different GL account, you can set these items for different item groups, define different GL accounts for these item groups and select for these items the Set G/L Accounts By to Item Group.

  • Posted on Dec 05, 2012 at 09:15 AM

    Hi,

    You can mark the G\L Account (Sales) in the Chart of Account as applicable to the distribution rule created by you.

    This will record the distribution rule for the specific G\L Account whenever the entry is posted to that G\L Account.

    However, if you do not want to have the distribution rule to each entry involving the G\L Account, the you can manually enter the Distribution Rule in the Journal Entry.

    Kind Regrads,

    Jitin

    SAP Business One Forum Team

    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.