web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Import inventory posti...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Import inventory posting profile for purchase order in D365

(0) ShareShare
ReportReport
Posted on by PujariD365 80

Hi Experts,

Below is the link shared by Rahul Mohta on this subject.

https://community.dynamics.com/ax/b/happyd365fo/posts/export-import-inventory-postings-in-microsoft-dynamics-365-finance-and-operations

Same you can find in this link also which was published in 2018.

http://www.axsolution.com/?p=9383

I tried to import the inventory posting profile in D365 for purchase order using Ledger posting definition for procurement data entity through data management but not getting any clue what data to fill in the columns. Attached is the template where I marked few columns in yellow where I am not sure about which data to fill so that posting profile can be imported. This is the concern for which I have created this thread in this forum. I tried alternatively by mentioning the posting types for example; Stock variation, Purchase expenditure, un-invoiced etc. in these columns but getting data integrity issue.

Ledger-posting-definition-for-procurement.xlsx

Can anyone please put some light on this as in above links only data entities have been displayed but nothing explained about data to capture in each columns in this template.

Thanks & regards,

Pujari

I have the same question (0)
  • Daniel Weichsel Profile Picture
    Daniel Weichsel on at

    Hi Pujari,

    Start first with exporting this data entity from an environment (demo/test is fine) where some configuration already exists.  That way you can see how the data you have entered in D365 corresponds to the resulting data entity file, and you won't have to start from scratch and guess at how exactly to name each posting type.

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,671 Moderator on at

    Hi Pujari,

    Please see how the standard template looks like when exported (Note - While adding the entity to create template, just select 'Only imported fields. See setting on last field.

    pastedimage1575500385502v2.png

    Here is a quick mapping based on what you had in your excel:

    Inventory profile relation INVENTORYACCOUNTTYPE
    Purchase expenditure, un-invoiced PackingSlip
    Purchase, accrual PackingSlipPurchaseOffsetAccount
    Stock variation StockVariation
    Purchase expenditure for expenses Expense

    The template that i got is below, only first column added to give you an idea.

    pastedimage1575500283721v1.png

    The data in template is exactly same as what you see on screen. 

    If you try to export the data where no record is setup, you will get blank template. So what you can do is add one record in system and then try to export. you can delete record, this will atleast get you what value you have in AX and something in template to start with.

    Also it's typical to set up posting profiles by item group / all. See that you have it by item number. If the accounts are same for items, try to group them together into item groups (less data to manage, less data to import - See if this helps you consolidate your data). Hope this helps you import data in your environment.

  • PujariD365 Profile Picture
    PujariD365 80 on at

    Hi Satish,

    Thanks much for the information you shared.

    I have imported posting profile in UAT (for testing) and it worked.

    But only one area I have to highlight. I don't think Purchase expenditure, un-invoiced is related to "PackingSlip" as it imports the items with main account in posting type "Cost of purchased materials received" !

    Can you please re-check this one and let me know what inventory account type should be applicable for "Purchase expenditure, un-invoiced"?

    Thanks & regards,

    Pujari

  • PujariD365 Profile Picture
    PujariD365 80 on at

    Hi Satish,

    Thanks much for the information you shared.

    I have imported posting profile in UAT (for testing) and it worked.

    But only one area I have to highlight. I don't think Purchase expenditure, un-invoiced is related to "PackingSlip" as it imports the items with main account in posting type "Cost of purchased materials received" !

    Can you please re-check this one and let me know what inventory account type should be applicable for "Purchase expenditure, un-invoiced"?

    Thanks & regards,

    Pujari

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,032 on at

    Glad my blog helped earlier

    typically the account type Purchase expenditure, un-invoiced is for non-stocked items which are received

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,032 on at

    Glad my blog helped earlier

    typically the account type Purchase expenditure, un-invoiced is for non-stocked items which are received

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,032 on at

    Glad my blog helped earlier and gave a starting point

    typically the account type Purchase expenditure, un-invoiced is for non-stocked items which are received

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,671 Moderator on at

    Hi Pujari,

    Please see correct one below. I must have made mistake in typing/filtering somewhere. Hope this helps.

    pastedimage1575616188079v1.png

  • SouravDam Profile Picture
    SouravDam 11,730 on at

    Hi PujariD365,

    The explanation from Satish Panwar on this is very clear and helpful.

    Have you tested this? Kindly update in this forum.

    Best regards,
    Sourav Dam

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,032 on at

    additionally

    in the account highlighted by Satish, the cost of inventory would be credited to general ledger when goods are received and used for temporary time period untill invoice is posted

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 646 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans