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

 


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

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