cancel
Showing results for 
Search instead for 
Did you mean: 

distribution rule linked to a chart of account

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

KennedyT21
Active Contributor
0 Kudos

Hi Carlo Joseph Alejandro...

Apply the Dist. Rule for the both accounts which will reflect in the p&l

Regards

Kennedy

Former Member
0 Kudos

Hi,

You can use Cost Center Hierarchy function Financials >>> Cost accounting, then create P&L report by your own hierarchy.

Hope this helps,

TVSon

Former Member
0 Kudos

do you have a manual using the cost accounting?

former_member204969
Active Contributor
0 Kudos

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.

jitin_chawla
Advisor
Advisor
0 Kudos

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

azeemhafeez
Active Participant
0 Kudos

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

former_member204969
Active Contributor
0 Kudos

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.