Skip to main content
Solved

FSM - Import/Export


Forum|alt.badge.img+9

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?

Best answer by Rwjgoedhart

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

 

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+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


Forum|alt.badge.img+8
  • Hero
  • 30 replies
  • Answer
  • March 19, 2020

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings