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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Feasibility creating d...
Finance forum

Feasibility creating data entity to import 'Product receipts' and post same for purchase orders

(0) ShareShare
ReportReport
Posted on by Sangram Shinde 2,108

Hi Techies,

I am looking into product receipts creation and posting process, can we create a data entity for this, I am looking for any functional/ technical insights if anyone has worked on similar kind of requirement.

Any response is appreciated.

Thanks,

Sangram

Categories:
Development / Customization / SDK
I have the same question (0)
  • Verified answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,699 Moderator on at
    RE: Feasibility creating data entity to import 'Product receipts' and post same for purchase orders

    You can load data in the staging  table with entity and write a separate batch to post product receipt by reading staging table from entity .   It's possible to do the same thing while moving data  to Target but that would be little complex.

  • Sangram Shinde Profile Picture
    Sangram Shinde 2,108 on at
    RE: Feasibility creating data entity to import 'Product receipts' and post same for purchase orders

    Thank you Sukrut, Nikolaos for the directions, so I tested a code by which product receipts are creating and posting. Now, can I create a flat table and create entity for same to get data in it and then write a logic in entity. OR shall I write some different approach to load the file and process the records.

    Please suggest.

    Thanks,

    Sangram

  • Suggested answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,699 Moderator on at
    RE: Feasibility creating data entity to import 'Product receipts' and post same for purchase orders

    I agree with Nikolaos . Its makes more sense to post product  receipt with in application  than through entity. Entity can help you to bring data to staging after that its up to you, how do you want to process it .

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at
    RE: Feasibility creating data entity to import 'Product receipts' and post same for purchase orders

    Product receipts are something that you should post inside the system, you can't just import directly into the product receipt tables.

    But you can definetely develop a solution where you import sufficient information that can then be used to create and post product receipts inside D365FO. For example you could develop a new intermediary table where you import this data, and then run some batch process that creates and posts product receipts based on the data in this table.

    That information that you need is some unique identifier of the purchase line to be received (InventTransId or PO nr + Line nr, and of course quantity). And maybe some additional information such as inventory location.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans