cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

#COE #BA01 Cost Center on Asset Acquisition credit

RyanMuller
Participant
0 Likes
1,140

Hello,

When we get supplier invoices related to expenses to be capitalized our AP Coordinators enter them against a asset clearing account and the have a cost center. This cost center is required for workflow, management reporting, and expense tracking. 

When our Asset Accounting teams pull the posted expenses against that account later in the month and create the associated asset master data and post the asset acquisition using that clearing account as the offset we've found that the posting is missing data and is an offset only based on the amount and qty and doesn't appear to be offsetting in reporting. The cost center in the expense invoice line is ultimately the cost center used in the asset master data.

As an example:

Invoice 12345 in Company Code US01 for a Laptop: 

GL AccountAmount ($)Debit/CreditProfit CenterCost Center
Accounts Payable2000Credit100 
Asset Capitalization Clearing (Expense)2000Debit10010011

Laptop Asset 12345 in Company Code: US01, Asset Class: Computer Hardware - Acquisition posting

GL AccountAmount ($)Debit/CreditProfit CenterCost CenterFixed AssetAsset Class
Asset Capitalization Clearing (Expense)2000Credit100  Computer Hardware
Computer Hardware (Fixed Asset Acct)2000Debit100 12345Computer Hardware

When we go to report at a cost center level we have $2000 expense still appearing in reporting even though it should be offset which is a big problem for our org. How can the cost center be accurately captured to show the true expense offset which ties thru reporting? This cannot be a unique problem to us and appears primarily in acquisitions but also the master data coding gets dropped in areas like retirements with sales (on the sale piece tying it to the asset).

Thanks in advance for your help,

Ryan

Accepted Solutions (0)

Answers (2)

Answers (2)

Edna_Garcia1
Product and Topic Expert
Product and Topic Expert
0 Likes

Hi Ryan,

When a GL account of Primary Cost (Expense GL Account) is used in the Post Asset Acquisition app, the system derives the cost center and profit center of the Fixed Asset Master Data. 

The responsible cost center of the WBS Statistical project is not derived from any journal entry posted.

Example:

I created an Expense GL Account.

GL1.png

The new Expense GL account was used in the Supplier invoice with the cost center and the statistical WBS.

SI1.png

The new Expense GL account was used in the Post Asset Acquisition. The system is deriving the Cost Center and the Profit Center of the Fixed Asset Master Data.

AA1.png

Best regards

Edna

1825
Associate
Associate
0 Likes

There’s proposal that details steps are as below.

Example data:

  • Company code: 1310.
  • Supplier account: 1000122, reconciliation account is 21100000.
  • Asset Capitalization Clearing (Expense) GL Account: 61003000.
  • Cost center 13101101
  • Asset master data: 500019-0

Process steps:

  1. Create supplier invoice for Account payable with APP “Create Supplier invoice”, and the result is as below.

1825_0-1710480811575.png

2. Create new asset master data.

 

1825_1-1710480811579.png

3. Post the asset acquisition via app “Clear outgoing Payment-Manual Clearing”.1825_2-1710480811586.png

 

1825_3-1710480811593.png

 

1825_4-1710480811601.png

4. Check post asset acquisition value in asset master data.1825_5-1710480811606.png

5. Check the report for GL account “61003000” line items as below.

1825_6-1710480811612.png

6. Clear GL account “61003000” if it’s needed.

RyanMuller
Participant
0 Likes
Thanks for the response, why are we having to use a clearing application to post an asset acquisition with the cost information as opposed to the asset acquisition app. How would this work for retirements with sales and other areas where the asset posting has incomplete object postings?