I'm currently making use of SharePoint Foundation, due to this I have needed to create my own Approval Workflow for requisitions, for the most part this works fine, but I have a strange issue where sometimes items aren't correctly copied to another list.
Again due to limitations with the Foundation version, instead of being able to give different users permissions surrounding one list, I've needed to create three separate lists.
The flow is as follow: So User A creates an Item in My Requisitions, this then needs copied across to Manager Approval and Finance Approval.
The requisition will first need to be approved by a Manager, then it can be actioned upon by Finance, this works fine for the most part, but sometimes when copying the list item the Manager Field isn't populated.
This is a problem as it means that when a Manager is going to their Pending List, they can't see the item as they should only see items Where Manager = [Me]
My question is: Is there something quirky about the Copy List Item action that may stop this from happening correctly, such as updates elsewhere for example and is there a way to stop this, or should I try and manage it some other way, such as updating the item after the copy to ensure parity.