on 2024 Feb 21 10:59 PM
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 Account | Amount ($) | Debit/Credit | Profit Center | Cost Center |
| Accounts Payable | 2000 | Credit | 100 | |
| Asset Capitalization Clearing (Expense) | 2000 | Debit | 100 | 10011 |
Laptop Asset 12345 in Company Code: US01, Asset Class: Computer Hardware - Acquisition posting
| GL Account | Amount ($) | Debit/Credit | Profit Center | Cost Center | Fixed Asset | Asset Class |
| Asset Capitalization Clearing (Expense) | 2000 | Credit | 100 | Computer Hardware | ||
| Computer Hardware (Fixed Asset Acct) | 2000 | Debit | 100 | 12345 | Computer 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
Request clarification before answering.
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.
The new Expense GL account was used in the Supplier invoice with the cost center and the statistical WBS.
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.
Best regards
Edna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There’s proposal that details steps are as below.
Example data:
Process steps:
2. Create new asset master data.
3. Post the asset acquisition via app “Clear outgoing Payment-Manual Clearing”.
4. Check post asset acquisition value in asset master data.
5. Check the report for GL account “61003000” line items as below.
6. Clear GL account “61003000” if it’s needed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 29 | |
| 26 | |
| 18 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.