Hello
I'd really appreciate your insight how to achieve in power auotmate.
I am trying to create an automated flow to move away from manual work for the business. I encountered three problems. If you could refer below current practice steps:
1. Automate flow works to write item batches, this has no problem.
2. Couldn't figure out the way to reset those dates using cloud flow. The logic is to simply override with null values for those dates from "Item batches" data entity when update a record in cloud flow. It does not accept null value. Error msg attached.
3. To create a header record, I have to ensure the next number of the journal number sequence. "Number sequence code V2" data entity has the information, but it is not found in power automate. I can only find it in DMF.
4. "InvenotryMovementJournlaEntriesV4" does not accept null value
In power automate, it seems following fields are required: Configuration, Color, Size, Version, License plate, GTD number, Owner, Inventory profile, Line number (I would hope it would auto increment)
We enter nothing in "Inventory movement journal headers and lines V4" data entity template if were to import via DMF.
Current practice
1. Import "Item batches" data entity via DMF
2. Manually Reset shelf-life dates (for particular items)
*Understand Mfg. date is a required field in Item batches and Expiration date auto-calculated in the back end by adding "Shelf-life period in days" from Released product.
Case 1) Manufacturing date not needed: remove Manufacturing date
Case 2) Expiration date not needed: Removed Best before date and Expiration date
Case 3) Both Manufacturing date and Expiration date not needed: Remove all
3. Manually create Inventory movement journal header to generate next Journal number e.g. INJ#
4. Import "Inventory movement journal headers and lines V4" data entity for the line details
Thanks,
Seu
