Solved

FSM - Import/Export

  • 13 March 2020
  • 2 replies
  • 631 views

Userlevel 3
Badge +8

In FSM 6, under Import/Export menu there is a option called “Perform FSM MPM”. Can anyone suggest me how to execute this process, so that we can do import/export as per our requirement.

Means how to import MPM data from a file?

icon

Best answer by Rwjgoedhart 19 March 2020, 03:16

View original

2 replies

Userlevel 1
Badge +5

Dear kaustav, 

unfortunately I haven’t used the MPM but I know that we used it in a button/Bussines Rule to import data to the system. Mostly I am using the Import/Export via Mapping or T-Tables. I would recommend using T-Tables. 

Best regard

Userlevel 3
Badge +8

Kaustav,

 

the Import MPM feature is quite amazing.  It practically executes the MPM’s available within/throughout the application, through Import/Export.

 

When we want to import into an MPM we first need to identify the required elements.

We use the following Query; although I’m sure there are other ways

select * from metrix_perform_param where perform_name = 'perform_stock_adjustment'

In case of “perform_stock_adjustment” you will see the following: 

 

To import; we basically build an Excel document to match the required (or desired) elements: 

 

This document you then use to “Import MPM”

 

VERY useful when you want to, for example, mass-transfer, mass-update inventory, mass-post shipments or receipts, etc. etc.     

 

If you need additional information, please do not hesitate to reach out.

 

Sincerely,

-Rudy

 

Reply