Symptom
- You verify that all expenses of customer project XYZ are assigned to a sales order item (XYZ stands for the project ID).
- But you still notice that one/some of these expenses appears unassigned on the Deferred Cost of Good sold account.
Environment
SAP Business ByDesign
Reproducing the Issue
- In the Project Management work center go to the Invoice Preparation - Not Invoiced times and expenses view.
- Find project XYZ.
- Press Edit Time and Expenses.
- Verify that all expenses are assigned to a sales order item.
Now check the Deferred CoGs account:
- In the Cost and Revenue work center go to the Sales Document Items view.
- Open the Advanced search.
- In the project ID field, enter XYZ and press Go.
- The sales order items associated with the project XYZ appear.
- Select one and press Reports and choose Sales Accruals for Project.
- In the report you notice a deferred CoGs amount.
- Add the Associated Sales Order and item attribute. You notice that the amount is not assigned, appearing as #.
- Use further attributes and filters, such as G/L account (origin), Project task, Accounting Period/Year, Associated Source Document Type to identify where the amount originates from.
- Eventually add Associated Source Document ID and filter for the document/s for which an unassigned amount appears.
- Add Journal Entry type.
- You notice that there is an expense assignment business transaction but also the expense assignment reversal reported even though the expense is assigned to a sales order item in Project Management.
Cause
The expense document has been marked as Quantity/ Expense to Be Deferred*:
- Go to the Edit Time and Expenses Screen.
- Select the respective expense document in the Time and Expense Items table.
- Underneath, in the Details section go to the Quantity and Expense Details tab.
- Here you see that the total quantity of this item appears as Quantity/ Expense to be deferred, not as Quantity to be invoiced or written off.
When an assigned expense document is marked as to be Deferred its expense assignment is reversed, so it appears as unassigned, deferred amount on the Deferred CoGs account.
Resolution
- If the expense is to be realised on the expense account as well as the revenue account, enter the quantity/amount as Quantity/Expense to Be Invoiced.
- If the expense is to be only realised on the expense account, but not invoiced to the customer, enter the quantity/amount as Quantity/Expense to Be Written Off.
In both cases another expense assignment version is generated to assign the document in accounting.
The expense is realised immediately on the expense account, if no accrual method is assigned to the sales order item. Or, if an accrual method is used, the next revenue recognition run will realise the expense.
Keywords
Revenue Recognition, Sales Accruals Report, assigned expense deferred , KBA , SRD-FIN-COR , Cost & Revenue , Problem