Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / DMF - The account typ...
Finance forum
Answered

DMF - The account type (Project) selected is not supported

(0) ShareShare
ReportReport
Posted on by FabioC 33

Hi All,

do you have any idea why when trying to import a General journal with DMF I receive this error 


The account type selected is not supported.

The account type is Project, the purpose is to import an Expense journal.

Is that related to the project category field that is not present in the entity strcture as visible field?

Best regards.

Categories:
Data Integration
  • Suggested answer
    Rich Profile Picture
    Rich 203 on at
    DMF - The account type (Project) selected is not supported
    As a follow-up to my post in February, the Project expense journals composite entity is the way forward, with two nuances (discussed with MS support, they're looking at where this can be covered in documentation) when including in a packaging zip file (particularly important for DMF REST API import)
    1. The JournalBatchNumber field must be mapped to a field present in the input data file, but then AutoGenerated (to effectively ignore the input value)
    2. The composite entity must be the only entity in the input package
  • Rich Profile Picture
    Rich 203 on at
    DMF - The account type (Project) selected is not supported
    Andre Arnaud de Calavon
    In Dynamics 365, you can use the Project expense journal header and Project expense journal lines entities for this purpose.
    Has anyone used these entities in combination whilst generating the journal numbers from the configured number sequence please? Changing the Project expense journal header field mapping for JournalBatchNumber to auto generate gets the header record in, but there's then no way of relating the lines to that newly created header that I can see. I think the answer is probably to use the composite entity Project expense journals, with just the header mappings set to auto generate the journal batch number, but that whilst that works through the UI, it doesn't seem to be supported by the packaging manifest file
  • FabioC Profile Picture
    FabioC 33 on at
    RE: DMF - The account type (Project) selected is not supported

    Thank you all,

    we found a limitation of DMF with some account types and we decide to develop a workaround. Best regards.

  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 10,873 Super User on at
    RE: DMF - The account type (Project) selected is not supported

    HI FBA,

    You cannot import project transactions via "General journal" entity in DMF.

    You can either follow Andre's suggestion or use Excel add-inn (Open lines in Excel > Project expense journal)

  • FabioC Profile Picture
    FabioC 33 on at
    RE: DMF - The account type (Project) selected is not supported

    Hi Andre,

    thank you for your reply.

    At the moment the requirement is to use the general journal since there are exceptions in the imported file and not everything in it can be manage as a proj expense. Given that, I would like to understand why the system returns this error during import with data management.

    Best regards.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,995 Super User on at
    RE: DMF - The account type (Project) selected is not supported

    Hi FBA,

    In Dynamics 365, you can use the Project expense journal header and Project expense journal lines entities for this purpose.

  • FabioC Profile Picture
    FabioC 33 on at
    RE: DMF - The account type (Project) selected is not supported

    D365 latest version

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,995 Super User on at
    RE: DMF - The account type (Project) selected is not supported

    Hi FBA,

    Can you confirm if you are using Dynamics 365 or Dynamics AX 2012?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans