Is it Possible to Import Stock Assignments?

Question

Here's the background here: We have Sales Order lines tied to a finished good produced by a work order (link is via MFGITM.VCRNUMORI / MFGITM.VCRLINORI) Not all our sales orders and work orders are linked this way. Say it's 50/50 linked and not linked. 
 We would like to start running assignments in our system to assign the rest of the work orders that aren't directly linked to a sales order, but we've found that assignments do not respect this existing link on the MFGITM table as we assumed it would. 
 As a result we have work orders linked to one sales order via the MFGITM table, but the assignments table (MTOLINK) has the work order assigned to completely different sales order. 
 The only thought I had was that if I could run some sort of process that would first perform assignments for these linked work orders/sales orders, then I run the batch assignments for everything else then I would be able to force the assignments I know should be there and let the system do what it will with everything else. 
 Has anyone ever had this issue? How did you deal with it? And, per the subject of this discussion, can a stock assignment be created via an import? I've not found any existing template to do this, but I think an import of manual assignments could fix this issue for me.

Julien Patureau · Answer

Hi Brett. I understand your situation. There is no standard way to import assignment. In the criteria considered in the automatic assignment process (See function GESPTO), you can see that priority factors considered to find the best match between ressources and supplies are projects, unit, quantities and dates. 
 So a possible work around would be to use the project field (if you don't use it) and to mass update the current sales order lines with concatenation of VCRNUM + VCRLIN and work orders header with concatenation of VCRNUMORI + VCRLINORI. Starting this situation, you should be able to create a rule with a priority on project as sole criteria and then you can manage in the next line the other priority factors you wish to apply. I suggest you to to do a PoC in a test environment: just do the update manually on 20 sales order lines - work orders and run the mass assignment to ensure this is working as expected. If you are not familiar with the ways to mass update sales and work orders, please contact your Sage partner for assistance.

Sage X3

Is it Possible to Import Stock Assignments?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING