Symptom
In the General Ledger work center, the goods and service receipt is shown in the Unposted Source Documents list, the error message is: Cannot Find Account Determination Group for Product Category. But the goods and service receipt document is for fixed asset procurement process, you feel the system should not give such an error message.
Environment
SAP Business ByDesign
Reproducing the Issue
- In the General Ledger work center, choose the Closing Cockpit view.
- Select the Source Documents subview.
- Show Unposted Source Documents.
- Select the not posted goods and services receipt document in question.
- Choose View Business Transaction, you can see the same error message: Cannot Find Account Determination Group for Product Category XYZ.
- Go to the Fixed Assets work center, and choose the common task Edit Asset Class Determination.
- You can see that product category XYZ (XYZ means the Product Category ID) is assigned with a Fixed Asset Class, so the system should not give error message: Cannot Find Account Determination Group for Product Category XYZ, which looks for an expense account.
Cause
Starting from ByDesign 3.5 release, it is possible to purchase several individual materials that belong to each other and will be treated as one fixed asset in the system. If you create a purchase order, goods receipt, or supplier invoice with a product category for fixed assets, you can now create new individual materials directly in the purchase order, and you can also create a purchase order for an individual material that represents an existing fixed asset. If the individual material is not created in the related purchase order, later on, you can also create the individual material in the goods and service receipt document. When the goods receipt is posted, the system uses the derivation rule together with the Company and Product Category to determine the relevant asset class, and creates a fixed asset with its assigned individual material.
If a new individual material is not created, or the account assignment type in the purchase order is not set as Individual Material, then the system will not post the item as fixed asset but as expense even though the Product Category is assigned with a Fixed Asset Class. This is why the system gives error message: Cannot Find Account Determination Group for Product Category XYZ.
Resolution
To successfully post the item as fixed asset, follow the steps below:
- First of all, cancel the goods and services receipt document in question:
- Go to the Goods and Services Receipts work center, and then select the Receipts and Returns subview.
- Show All Documents, and select the goods receipt document in question.
- Select Cancel Document.
- A cancellation document is created, but cannot be successfully posted as well because of the same error message in the original goods receipt document.
- Mark the cancellation document as irrelevant.
- In the General Ledger work center, choose the Closing Cockpit view.
- Select the Source Documents subview.
- Show Unposted Source Documents.
- Select the cancellation goods receipt document created above.
- Choose View Business Transaction, and then select Mark as Irrelevant.
- Then both the source document and the cancellation document are set irrelevant to accounting.
- Create new goods and services receipt document with new individual material.
- When you cancel the original goods receipt, the related purchase order is displayed in the Purchase Order to Be Delivered list.
- Go to the Goods and Services Receipts work center, and select the Purchase Order to Be Delivered view.
- Select the purchase order in question, and then choose New Goods and Services Receipt.
- In the Items list, select the item and then choose New Individual Materials.
- Finally, choose Post.
You should be able to successfully post the item as fixed asset.
Keywords
fixed asset procurement; product category; , KBA , product category , cannot post goods and servcies receipt , individual material , fixed asset , account determination group , #### , ####### , account assignment for fixed asset , SRD-FIN-GL , General Ledger , How To