on 12-05-2012 5:24 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.