Execute a quantity move programmatically - Any special Methods/SPs to be aware of?

I'm in the process of writing code to help automate/streamline our restocking of Rank 1 locations. I've combed through the QuantityMove form to see how it operates & it appears that the MvPostSp is the stored procedure that actually performs the quantity move. I can see that MvPostSetVarsSp is being called to define & populate some SQL variables but I don't believe I need this if I call the MvPostSp directly.

-Is it incorrect to call the MvPostSp directly without calling the MvPostSetVars first?

-I've done some testing with using the MvPostSp only & it does appear that the quantity moves are happening. Is there anything in the system I should be looking at for a "sanity check"? I want to be sure I'm not corrupting anything by executing the quantity move.

Find more posts tagged with

Syteline Development

Accepted answers

Legacy Contributor

I would suggest inserting quantity move transactions into the dcmove_mst table instead and allowing Data Collection to process the transactions. That way you get full validation of the data and errors can be handled in the standard error processing forms.

All comments

Legacy Contributor

Is there some way to get documentation on the stored procedures in Syteline? It would be a lot easier to customize if we had documentation on the stored procedures and methods.

Stephen Cena

This sounds much better. Is there anything that has to happen to trigger the detection, or is there something inside CSI that's basically polling that table/triggering?

I'm not too concerned about the validation, as all of the data going in will be validated already, but I'll take any extra checks I can get.

Legacy Contributor

There is not. And don't depend on them. Infor's roadmap is to replace stored procedures with .NET IDO custom assemblies within the next couple of releases of the product.

Stephen Cena

^^Documentation: I'd love this as well. I'm a good developer but not having any kind of documentation inside or on the SQL stuff slows me down. If anyone knows where to find this I'd love to know.

INFORD~1.MP4

Legacy Contributor

You just need to configure the parameters on the Data Collection Parameters form. The help file for that form tells you what you need to do. It does include a polling setting that you configure as part of the parameters.

Stephen Cena

I was wondering when/if that was going to happen!! It makes total sense to do so but that's going to be a massive effort to port all that code.

Stephen Cena

This is perfect. It looks like I could actually leverage this for some other possible automation tasks as well.

I remember coming across this form when we were looking at data collection for something else. The consultant we were working with said that Infor had abandoned this and the form was just left behind (My memory is very fuzzy but his response was something like that). Do you know of any truth to that? Otherwise, I'm definitely going to look at this. This may have just simplified my project a LOT.

Copyright © 2025 Infor. All rights reserved.