Hello,
We are looking to import counting journal data using the DIEF. The goal is to import up to 800 records for posting a Physical Inventory adjustment. I have successfully:
- Created a Group Name
- Setup the Entity (Inventory Journal)
- Generated the Source Mapping
- Validated OK in AX
- Staged, and Imported the Data to AX into a Journal
I have used these fields in the mapping:
- JOURNALID
- TRANSDATE
- JOURNALNAMEID
- LINENUM
- ITEMID
- COUNTED
- INVENTSITEID
- INVENTLOCATIONID
- WMSLOCATIONID
The issue I'm having is even though the data imports successfully, AX does not appear to be updating certain fields appropriately.
The Site, Warehouse, and Location are all populated in the journal, and the quantity I want populated in "Counted" is present. The "On Hand" column seems to be automatically populated with the same quantity as "Counted" instead of what is actually on hand in the inventory dimension combination:
Then, if I "update" the location on the line (retype 00), the "On Hand" updated to the appropriate quantity in that dimension, and the "Counted" field has been populated with the adjustment quantity. Now, even though the "Quantity" has updated, the "Cost Price" has not pulled in, and the "Cost Amount" has not adjusted
If I "update" the "Counted" field to 0, it will update the cost price and cost amount. I set the counted back to "3" and now the line looks appropriate:
Obviously having to do all this more or less defeats the purpose of using the DIEF. Am I doing something wrong, missing a step, other?
Thank you!
