D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

inventory posting

  • 1.  inventory posting

    TOP CONTRIBUTOR
    Posted May 14, 2019 02:24 PM
    Hi All

    I am setting up Procurement and sourcing for multiple company in same instance. Is there a way to upload Posting profile using ATLAS or DIEF or Script  under instead of copying and pasting over 300 lines

    Inventory Management -> Set up -> Posting -> Posting -> Purchase order - Purchase expenditure for expense

    Thanks 

    ------------------------------
    Nazim Lalji
    Dynamics AX Analyst

    ------------------------------


  • 2.  RE: inventory posting

    Posted May 15, 2019 04:39 AM
    Hi Nazim,

    In AX2012 I don't believe Microsoft have released an entity to cover off the Inventory postings (SalesOrder,PurchaserOrder,Inventory). However if you have atlas you can set up an upload template to do this for you (Note: It would be worth checking GlobalSoftware support site as they may have a template configured already)
    If not the AX table you need to populate is "InventPosting".
    For the main account you will need to reference the RecId in that table so you may have to get the data from the DimensionAttributeValueCombination table.  Relationship: InventPosting.LedgerDimension== DimensionAttributeValueCombination.RecId.
    Atlas should already have this relationship configured on the table as it is a defined relationship in the AOT so you should be able to add the "DisplayValue" field to the template without too much trouble.

    Hope this helps

    KR
    Mark

    ------------------------------
    Mark Bailey
    Application Consultant
    Annata
    Portsmouth
    ------------------------------



  • 3.  RE: inventory posting

    D365UG/AXUG ALL STAR
    Posted May 15, 2019 09:03 AM
    Atlas uses the tables still in AX2012, so yes you could use Atlas to do this. When you upgrade to D365, then you have to use the entities in OData. If the entities you need are not public, then you can create an extension and make it public and then you could use Atlas in D65 as well.

    ------------------------------
    Paul Martin
    Production Program Manager
    Elite Comfort Solutions, LLC
    Rutherfordton NC
    ------------------------------



  • 4.  RE: inventory posting

    TOP CONTRIBUTOR
    Posted May 29, 2019 11:52 PM
    Hi Paul

    Would you mind sharing ATLAS template to upload. I tried didnt worked may be missing some thing

    Thanks and kind regards


  • 5.  RE: inventory posting

    D365UG/AXUG ALL STAR
    Posted May 30, 2019 10:02 AM
    Check on the Atlas website, they have a good number of templates available for you to download, the template I use is for D365.

    ------------------------------
    Paul Martin
    Production Program Manager
    Elite Comfort Solutions, LLC
    Rutherfordton NC
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role