SAP Knowledge Base Article - Public

3082480 - Unposted Source Document Error: Cannot find acct determination group for mat. 123, comp. PQR, bus. res. DEF

Symptom

You have noticed an unposted source document (for example, Purchase Order) and an error message which prevents the document  being posted.

Error message: Cannot Find Acct Determination Group for Mat. 123, Comp. PQR, Bus. Res. DEF

(123 represents Material ID)

(PQR represents Company ID)

(DEF represents Business Residence ID)

Remark: this error message may also appear in the log of a GR/IR Clearing Run.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the General Ledger work center.
  2. Go to the Closing Cockpit view.
  3. Go to the Source Documents subview.
  4. Search for your Source Document ID, in this case the Source Document is a Purchase Order.
  5. Select the ID and under the Details session you can see this error:

'Cannot Find Acct Determination Group for Mat. 123, Comp. PQR, Bus. Res. DEF'

(or)

  1. Go to the Inventory Valuation work center.
  2. Go to the Periodic Tasks view.
  3. Click GR/IR Clearing subview.
  4. Select Run ID.
  5. Select Processed with Errors tab.
  6. You can see the error:
  7. 'Cannot Find Acct Determination Group for Mat. 123, Comp. PQR, Bus. Res. DEF'

Cause

The reason is that you have not maintained Account Determination Group for the respective material of the company and Business Residence combination. If a material is involved in any business transaction (for example, Purchase order), then respective G/L account is derived using the Account Determination Group of this material in the combination of Company and Business Residence in the Valuation view.

Resolution

You need to update the Material master data for Account Determination Group in the combination of Company PQR and Business Residence DEF:

  1. Go to the Products and Services Portfolio work center.
  2. Go to the Materials view.
  3. Select the Material 123 used in the Purchase Order.
  4. Press View all.
  5. Go to the Valuation tab.
  6. Click Add Row.
  7. Enter Company PQR in the Company field and Business Residence DEF in the Business Residence field.
  8. Maintain the Account Determination Group and Perpetual Cost Method.
  9. Select the option Active from the dropdown list of Status field.
  10. Press Save.

Also check if the G/L account is maintained under Account Determination Group, as follows:

  1. Go to the Business Configuration work center.
  2. Go to Overview view.
  3. Go to the Fine Tune and select the activity Charts of Accounts, Financial Reporting Structures, Account Determination.
  4. Select the link Inventories under Account Determination.
  5. Select the Account Determination Profile YYY and navigate to Inventory tab. (YYY represents Account Determination Profile ID)
  6. Maintain G/L Account for the respective Account Determination Group RRR. (RRR represents Account Determination Group ID)
  7. Click Save button. 

Now you are able to post the Unposted Source Document, as follows:

  1. Go to the General Ledger work center.
  2. Go to the Closing Cockpit view.
  3. Go to the Source Documents subview.
  4. Search for your Source Document ID, Purchase Order.
  5. Select the ID and press Actions and select Post Business Transaction. 

See Also

2672132 - Unposted Source Document Error: Account Determination for Inventories is Missing for Acct Det. Group XXX

Keywords

Source document error, Account Determination Group, Business Residence, Material , KBA , account determination group , valuation view , account determination group for material , business residence , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions