Transfer from forecast to sales order
Respondida
I am trying to write some usability to create a sales order from a forecast screen based on a tick box selection but I am experiencing the following issues:
The SO screen opens twice. the first line item selected does not copy over to the SO screen (though subsequent items do) and the date does not copy over at all on any of the lines. The error message I receive is as follows:
Macro error in UF-127: System.Exception: Error setting Matrix '38' - Column '1' - Row '0' with value 'K10016421' [Check that it is visible and active] (Item - Form item is not editable)
[Macro Command: Transfer($[$BOY_1.ItemCode.0]|$[$38.1.0])]
To complete this, I have written SQL to translate the data from the forecast screen in to a more readable format and then added this as UF onto a button on the forecast screen:
This opens up the forecast lines SQL window:
I have then created a further button on this window with a validation config attached.
This config executes a line loop function with a condition which reads whether the selection box column has been selected. Based on this being yes I then have a first pass UF which is a macro and reads as follows:
Activate(2050);
Transfer($[$BOY_1.FcstCode.0]|$[$4.0.0]);
and then a line UF which is also a macro which reads as follows:
Transfer($[$BOY_1.ItemCode.0]|$[$38.1.0]);
Transfer($[$BOY_1.RndQtyForSO.0]|$[$38.11.NUMBER]);
Transfer($[$BOY_1.FcstDate.0]|$[$38.25.DATE]);
Can anyone tell me where I am going wrong please?
-
Comentario oficial
Hello Emily,
The case about this is that the Line Loop transfers the same line information from one document to another, for example, to transfer from a marketing document to another it will start with line 1 (the first line of the document) to line 1. In this report and window, the first line is line number 0 and in a marketing document this line does not exist, they start on line 1.
A workaround for this is to use a combination of conditional commands like @STORE variables to set a different line number to be affected in the line loop.
These 2 links can help you to learn about these 2 features.
https://support.boyum-it.com/hc/en-us/articles/204284188-Guide-Understanding-Dynamic-Syntax
For more information please contact your local partner.
-
UPDATE: I have managed to remove on of the issues (2 SO screens appearing) but I am still having issues with the first line selection not being transferred and the date not transferring at all. I now have a new error for the date as follows:
'String was not recognized as a valid DateTime [Macro Command: Transfer($[$BOY_1.FcstDate.0]$[38.25.DATE])]
Iniciar sesión para dejar un comentario.
Comentarios
2 comentarios