The core issue here is to decide where to store these values. They need to be put in a table somewhere. The decision on this in my opinion boils down to the process doing one of two things. Either it is a persistent process, where the user can start now and come back tomorrow to finish it. Or it is a one off transaction that begins when the form opens, and ends when the form closes. I would go for the first option.
The next step is to decide which table. You can use an existing table or create a new one, but this case, I would use table 83. The reason being that you are eventually going to need the data in there anyway, so why not do it that way from the start.
Now create a copy of Form 393 as Item Transfer Journal and
- add Transfer option to the Entry Type Field.
- Add the field :New Location"
- And remove the code that disallows transfers.
New create your Matrix form, and design it so that it opens from your new Item Transfer Journal form and passes the Template and batch names across.
Now add code so that calculates the qty to transfer from the journal into the matrix and then code that if the user modifies the value,t hen it deletes, modifies or inserts the appropriate record in table 83.
That’s basically it, and now you just post the journal.
One thing you need to consider is the Source table for the Matrix box, there are two options ;27-Item and 83 journal Line.
Using Item table has the advantage “that you see all items even if you don’t need to” , the disadvantage is “that you see all items even if you don’t need to”.
Using the Journal has the disadvantage “that you only see items in the matrix if you first enter them into the Journal”, but has the advantage “that you only see items in the matrix if you first enter them into the Journal” you need to decide.
Oh and using the Journal makes the code a very little bit easier but not much. Be careful though, since once you decide, its hard to change later.