Dynamics Community Forum Thread Details

D365F&O | Ledger account for Service item.

Dear Experts,

I have received a requirement from my client, and I would like to seek your confirmation regarding the system's capability to fulfill it.

Scenario:

The client uses an item service called "Training Service", which belongs to the "Service" item group.
Business users or requesters are not familiar with the specific ledger accounts applicable to this service.
The Finance team has requested that:
- Business users select the item service "Training Service".
- Based on the user's cost center, the system should automatically assign the appropriate ledger account.
  - According to Vietnam Accounting Standards (VAS):
    - Expenses related to store staff training should be posted to 641X – Selling Expenses (SE).
    - Expenses related to office staff training should be posted to 642X – Administrative Expenses (AE).

Current system capabilities:

1. Ledger Account Setup by Procurement Category (PO Posting):

2. Item Service Setup per Procurement Category with Ledger Account Assignment:

Requires creating multiple item services for each category.
Example:
- Item: "Store Training Service" → Procurement Category: "Store Training Service" → Ledger Account: 641X
- Item: "Office Training Service" → Procurement Category: "Office Training Service" → Ledger Account: 642X
This approach may lead to an excessive number of items.

3. Single Item Service with Manual Ledger Account Override:

Business users would need to manually override the main account during PR creation.
This is not ideal, as users typically lack financial expertise and would need to consult the Finance team.

Request for Input:

Do you have any suggestions or alternative approaches to better address this requirement?
Personally, I find Option 2 to be the most feasible, followed by Option 1, and lastly Option 3.

Regards,

Categories:

Hello,

I would prefer Option 2 in general, however, I do have questions.

You said for Option 2 it would lead to excessive number of items. As I understood you differentiate between office and store stuff training, therefore, you would have 2 main accounts to post on. What is another differentiation that would cause more items?
Why do you need items and not stick only to procurement categories?
Although the business users may not be fully aware what proc. category to use. However, the accountants should create the "pending vendor invoice" from the PO, so they are aware which procurement category to use or at least they can check on which ledger account it will be posted.

Kind regards, Adis

If this helped, please mark it as "Verified" for others facing the same issue

Keep in mind that it is possible to mark more than one answer as verified

Quick Links