Document Splitting-Balancing field "Profit Centre"

[Former Member]

I am trying to post an F-02 transaction as follows:

Salary & Wages 1000 Dr. Cost Centre(A) & Profit Centre (A)

Salary & Wages 1000 Dr. Cost Centre (B) & Profit Centre (B)

Salary Payable 2000 Cr.

But when I tried to post it, the system is showing the error that "Balancing field Profit Centre not found in item 3.

I am expecting that the item-3 as above should be split and inherit the profit centre information. However, the document is not split and the system is showing the error.

I cannot assign a default Profit centre to the item -3 . How can I reslve this error. Document type used is SA and it is 'unspecified posting' in the Document Spitting method 0012.

Please help out.

[Former Member · Accepted solution]

you need to classify your "GL's" and "Document Types" for document splitting.

these are the first 2 steps in doc-split configuration.

can you make sure your config is ok for above.

[Former Member · Accepted solution]

Hi.

Thanks for the reply.

I have already assigned the relevant GL account to the item category for splitting. Document splitting method 00012 is used and the document used (SA) is already in the standard.

One more point, when I post only one Dr. item with one cost centre and Cr. item with salary payable, the Profit centre is inherited correctly. But when the Dr. items are more than one, the Cr. item is not inheriting the profit centre.

[Former Member]

I am closing this thread. Still I am not answered why system does not fill the Default profit centre from the Constant Definition for document splitting whereas the Segment is filled from the constant for the unassigned process.

[Former Member]

Dear,

Nikitha.

Isn't your system asking you profit center as your mandatory field ? If it is so just put your enter your respective profit center

and simulate the entry. ( In some cases enter your cost center system will catch assigned profit center from CC try out )

Follow the following path :-

IMG --- FA NEW -

---

General Ledger Accounting New --- Business Transaction -

---

Document Splitting -

---

Define Document

Splitting chracteristics for General Accounting.

Here is your PRCTR is defined mandatory.

If you untick it your system will allow you to post the document. But listen if you have activated segment also with that.

Your reporting will be of no use and result void.

In the SAP best practices it is said dont untick it if you have posted documents with same activated functionality

By unticking your profit center wise & segmental reporting will be of no use.

or do one thing go to down side of the same path a little you will see one transaction as Edit constants for non assigned

process select your constant and double click on assignment of profit center maintained there default profit center or

maintained dummy profit center 9999. Now your system will pick this profit center 9999 or your mentioned one

as your default profit center.

Or one more else thing you can do is by posting key make your profit center optional through its posting key's field status

group.

Hope this helps you to solve your issue.

Please revert back for further clarification.

Regards,

Pankaj.

Edited by: pankaj_ab on Nov 24, 2009 12:45 PM

[Former Member]

Hi

Thanks for the replies.

My problem is not with the field status groups. I have enabled the profit centre field as option along with segment.

Profit centre is a mandatory setting that is why system is not allowing me to post without the profit centre information.

Now regarding the constant definition for a profit centre 9999, I want the following clarification.

What I am expecting is for the two debit different cost centre/profit centre items, the since credit item have to be split with the respective profit centres. Is that not avilable as a standard ? Or I should assign a constant value for the profit centre for such type of entries ? When I assign a default profit centre in the field in the credit line item, it is posting fine with additional clearing lines for segment.

But if I assign a default profit centre in FAGL3KEH for this "Salary payable a/c", it will be defaulted to the documents where there is only one Dr. line also.

Regarding cosntant value, will that be picked only for those transactions when the system does not inherit a profit centre from the other items ?

Please clarify.

[Former Member]

This message was moderated.

[Former Member]

Hi Pankaj

As you suggested, I defined a constant for document splitting and assigned a default profit centre and a default segment. I assigned this constant in the activation screen also.

But while I doing the posting again, the line items is filled with default segment but no default profit centre is filled and hence I am not able to post. Am I missing again something ?

[Former Member]

Dear Nikitha.

Please go through the following example.

This error generally comes when system tries to split the line items based on your config. Suppose you have activated the document split at Profit center level in your system then this error means that system is not able to derive the profit center from the corresponding line item. I am not sure about your entry but to clarify it further just take an example:

GL PROFIT CENTER AMOUNT DR./CR.

001P&L A101 100 DR.

002 P&L A102 100 DR.

003 BS 200 CR.

In case you want to post above entry in your system and you have activated document split at PRCTR then system will try to split your B/S line into 2 line items based on the ratio of expense lines. After splitting your entry should look like this:

GL PROFIT CENTER AMOUNT DR./CR.

001P&L A101 100 DR.

002 P&L A102 100 DR.

003 BS A101 100 CR.

003 BS A102 100 CR.

You are getting this error in your system because system is not getting correct configuration to split the balance sheet line items at profit center level so the line item where system is not able to derive the PRCTR system gives this message so that you can correct your config.

To check where your config error is. Try to simulate your entry in Journal ledger view and click on expert mode tab. Now open your entry so that you can see where system is not able to derive the profit center. You need to check the base item category and the item categories to be edited. Then go to the transaction variant in your config to check why system is not deriving. Hope this helps

Regards,

Pankaj.

[Former Member]

Hi Pankaj

What you have explained with the entries are perfect to my case.

In my setting Profit centre is a mandatory setting. Even after assigning a constant value for Profit Centre & Segment for unspecified posting, the line item does not got that Profit centre whereas Segment gets the default value. But since Profit centre is mandatory, the posting would not happen even Segment information is available for that line item.

This is the place where I am stuck. Document type used is SA and it is there in the document classification for splitting configuration.

Please help me out.

[Former Member]

..

Edited by: Sharvari Joshi on Nov 24, 2009 6:38 PM

[Former Member]

Hi

The document SA, trans 0000 and variant 0001 & unspecified posting is by default available in the system.

[Former Member]

Dear ,

Nikitha.

Thanks for additional input of SA document type.

Tell me have you define Business Tranasction 0000 Unspecified Posting & Variant 0001 ?

If not maintained it. And let me know.

What I told are all standard way outs of this problem.

Reply.

Regards,

Pankaj.

[Former Member]

The document SA, trans 0000 and variant 0001 & unspecified posting is by default available in the system.

One thing I dont understand, even after giving the default values of Segment & Profit Centre in the constant definition, only Segment is defaulted in posting whereas Profit Centre is not defaulted.

[Former Member]

...

Edited by: Sharvari Joshi on Nov 24, 2009 7:08 PM

[Former Member]

Dear

Nikitha.

Kindly find one more thing to check out in T.code GSP_LZ2.

The categories are defined as under :-

Balance Sheet Account :- 01000.

Vendor :- 03000.

Customer special GL transaction :- 02100.

Fixed asset :- 07000.

Material :- 06000.

Cash Account :- 04000.

Revenue :- 30000.

Customer :- 02000.

Expense :- 20000.

Check out.

Regards,

Pankaj.

[Former Member]

This is also in place already Pankaj.

[Former Member]

Hi,

What item category did you assign to the salary payable account? If it is 01000 (balance sheet account), split will not happen. 01000 is for balancing posting.

Regards,

Ming

[Former Member]

Hi Minghong

I have assigned the item category as 01000 to the salary payable account.

[Former Member]

Hi Nikitha,

Please try to following

Change the assignment of the "Classify Document Types for Document Splitting" as follows for document type "SA":

Business Transaction - 0100

Variant - 0001

This should resolve your problem.

Regards

Venkatesh

[Former Member]

Dear,

Nikitha.

I woululd like to suggest you some SAP Best Practices. If you are not able to post with given document type please

create one new document type and maintain the same in GSP_VZ3

Let me clear you concept , as per when when some postings and certain are not recognised when & how they can be

used in standard business process they are defined as Unspecified Postings in document splitting rule.

So that as per general scenario SA document type is used for all postings that Vendor , Customer , Assets , GL Account,

Material hereforth all these account types can not be covered in single Business Transaction hence as per

SAP Best Pratices it is suggested that Unspecified Postings should be used to receive desired output.

Or else defined New Business Transaction as per your requirement.

But I will suggest you to create new document Type.

I hope this helps you to solve your issue.

Regards,

Pankaj.

I know your document type is standard but still have try.

[Former Member]

Hi friends

As suggested, I created another document type and assigned the 0100 and 001 values for trasaction and variant for doc splitting.

But, this also does not resolve my issue. Line items do not get Profit Centre data still.

[Former Member]

Dear,

Nikitha.

Please maintain in document type for document splitting and define transaction 0000 & 0001.

As I said this mus tsolve your problem.

Regards,

Pankaj.

[Former Member]

Hi Pankaj

This is the standard available and with this setting it is not working.

[former_member221515]

Since there are two profit center, SAP is getting confused which profit center needs to be picked up. So you will have to manually give profit center.

If the profit center is not visible, you will have to change field status in OB41 & OBC4

[Former Member]

Hi Deepak

If the profit centre is assigned manually, it becomes possible to post the document. But what I am looking for to avoid the user intervention for manually keying a profit centre for this type of composite posting.

[former_member221515]

Let me know why you cannot post Profit Center.

If the field is not available, then you have to change field status group in OBC4 and OB41