Is it possible to move response documents to refer to a different parent document?
You can lookup DocumentIDs and put them into $REF. The trick is not using any intermediaries or holding places (i.e. temporary variables, environmental variables, view columns). You have to set it directly equal to the results of @DbLookup. You are right, $REF is a special data type, called ‘Response Reference List’. Let’s say that you want to reassign the $REF field of a series of response documents, based on some key that the new parents share with the documents that will be their new children (let’s call this field ‘keyValue’ which exists in both potential parent and response). Create a view, call it ‘Parents by keyValue’. The selection formula should select only the potential parents, and the first sorted column should be the keyValue field (you don’t need to add any other columns).
Related Questions
- When printing SAP Business One documents, the text "Printed by SAP Business One" appears in the document footer. Is it possible to prevent it from being printed?
- What are the possible legal repercussions if parent/guardians or students that I refer are prosecuted for truancy?
- Is it possible to move response documents to refer to a different parent document?
