Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Mark Schurmann]

We have made limited use of the inventory module.  I just discovered that the inventory module has its own set of journal names separate from the general ledger journal names and there is not an option to associate a workflow with the journal names.  Is there a way to have an approval process around inventory adjustments?

——————————
Mark Schurmann
Accounting Systems Manager
Automobile Protection Corp
Norcross GA
——————————

[Kerstin Newman]

This is not really answering your question as we don’t use workflow either, however, we only gave specific roles permissions through security to even create/post inventory adjustment journals, so are mitigating it that way. Not sure that’s an option if the answer to your question really is a “no, there are no inventory adjustment approval workflows”.

——————————
Kerstin Newman
Business Analyst
StarTech.com
London ON
——————————
——————————————-

[Calvin Eddings]

I am trying to set up and test security roles to accomplish the split, but I am having trouble – my first attempt was to use the OOTB role ‘warehouse worker’ as the role to create an inventory adjustment, and then have a second role ‘warehouse manager’ assigned to a second person to finish out the journal, but in my test, the journal does not seem to be able to be posted by the warehouse manager role.  If I give a user both roles, then it works to create and post by a single user.  Anyone have suggestions?

——————————
Calvin Eddings
The Church of Jesus Christ of Latter-Day Saints
Salt Lake City UT
——————————
——————————————-

[Kerstin Newman]

Hi Calvin,
We are not using OOB security roles, all of them are customized to some extent to fit the needs of our business. There is however an OOB duty called “Approve inventory adjustment journal” that has a privilege underneath it “Post inventory adjustment journal”. I haven’t tested it but would assume that someone who doesn’t have that privilege should not be able to post a journal. 
I hope this helps!

——————————
Kerstin Newman
Business Analyst
StarTech.com
London ON
——————————
——————————————-

[Calvin Eddings]

Thanks Kerstin.  I was aware of that duty.  If I combine it with an out of box role (warehouse worker) than it will allow the user to create and post an inventory adjustment journal.  So that is helpful if I allow a user to create and post.

I am still interested to try and segregate the ability create the journal and post the journal.  I would still welcome input on that topic.

——————————
Calvin Eddings
The Church of Jesus Christ of Latter-Day Saints
Salt Lake City UT
——————————
——————————————-

[Kerstin Newman]

There are a few more options – again I haven’t tested it, just looking through our roles and what they contain..

Privilege: Create new inventory journals doesn’t seem to allow posting but only creation. 
Privilege: Maintain inventory adjustment journals/Maintain inventory adjustment journal lines probably doesn’t allow posting either. 

If you were to use these privileges in your worker, and assign the “Approve inventory adjustment journal” duty to a supervisor role, you’d have the responsibilities separated.

——————————
Kerstin Newman
Business Analyst
StarTech.com
London ON
——————————
——————————————-

[Calvin Eddings]

Actually, I think I have tested that indirectly, by using the warehouse worker OOTB role and the warehouse manager OOTB role.  Warehouse worker has the duty: Maintain inventory adjustment journal entries, which contains the privileges:

Create new inventory journals
Maintain inventory adjustment journals
Maintain inventory adjustment journal lines

Then I was having the approver have the out of box role warehouse manager which contains:

Duty: Approve inventory adjustment journal
Privilege:
Post inventory adjustment journal (among others)

However, the result was that the warehouse worker could create and validate, but the warehouse manager could not post for some reason.

——————————
Calvin Eddings
The Church of Jesus Christ of Latter-Day Saints
Salt Lake City UT
——————————
——————————————-

[Ian Gorman]

Kerstin is correct. There is no native functionality around this. I’ve leaned on enabling the ‘post’ button for only supervisors in the past.

——————————
Ian Gorman, PMP, MCSE
Senior Consultant
——————————
——————————————-

[Paul Martin]

There is not a native workflow for inventory journals. typically the security roles are used to allow some to create, but ot post, and then it takes an additional role to be able to post. This is the easiest way to maintain considering the usually high number of inventory journals you will have

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

[Sean Gilbert]

Workflow approvals are now available for all inventory journals. (Adjustment, Movement, Cycle count, etc..)
They need to be activated in feature management and were introduced in February 2020.  I believe with 10.0.8 or .9

If you need all journals to be approved then this will wok great.  However, if you want approvals based on dollar amounts there are certain restrictions.  I haven’t done any in depth testing but it looks like adding a condition based on dollar amount applies at the line level and not the journal total.  Example:  if my condition says approve if > 1000$

– if any one of the lines in the journal exceeds 1000$ it will be sent for approval.
– if all the lines are for 200$ but the total of all lines exceeds 1000$ it will NOT be sent for approval

——————————
Sean Gilbert
Thinkmax Consulting
Montreal QC
——————————
——————————————-

[Ian Gorman]

Hi all,

I posted a blog about the new inventory workflows.

https://www.axug.com/blogs/ian-gorman1/2020/04/25/10010-first-release-of-workflows-for-inventory-man?CommunityKey=af0dadbe-c222-4660-9d1e-a9e3416c837a&tab=

——————————
Ian Gorman, PMP, MCSE
Senior Consultant
——————————
——————————————-

[Calvin Eddings]

This is great to see that workflow is available!  I will be sharing this with my organization and looking at this very closely.

#Workflow?

——————————
Calvin Eddings
The Church of Jesus Christ of Latter-Day Saints
Salt Lake City UT
——————————
——————————————-