Question

Recording material usage via migration script - is it possible??

  • 14 July 2020
  • 1 reply
  • 101 views

Userlevel 6
Badge +11

We are not currently using the MRP for one of our companies and are looking for a simple way to move our stock balances from manual spreadsheets into IFS.

We are purchasing and receipting stock using IFS PO’s which will of course increase the stock balance. However, we would like to perhaps use a migration script to reduce stock balances (That would be our usage of this stock).

Does anyone know the best way to achieve this??

Can we import material usage?

 


1 reply

Userlevel 7
Badge +24

hi,

you can use the FNDMIG migration tool to consume stock.   Note that - in terms of IFS transactions - you have multiple choices, like “Issue Inventory Part” or “Count (out)”.  I would suggest Issue Inventory Part is the simplest (inventory transaction = NISS).

Anyway, to set this up requires some familiarity with the migration tool, but basically you are replicating a oracle script like the following.

Using it - you can run it manually or scheduled, and you could feed in a spreadsheet of data.


DECLARE

   -- p0 -> i_hWndFrame.frmIssue.tblPartLoc_colsContract

   p0_ VARCHAR2(32000) := '1';

   -- p1 -> i_hWndFrame.frmIssue.tblPartLoc_colsPartNo

   p1_ VARCHAR2(32000) := '10501';

   -- p2 -> i_hWndFrame.frmIssue.tblPartLoc_colsConfigurationId

   p2_ VARCHAR2(32000) := '*';

   -- p3 -> i_hWndFrame.frmIssue.tblPartLoc_colsLocationNo

   p3_ VARCHAR2(32000) := '01-10-18-02';

   -- p4 -> i_hWndFrame.frmIssue.tblPartLoc_colsLotBatchNo

   p4_ VARCHAR2(32000) := '*';

   -- p5 -> i_hWndFrame.frmIssue.tblPartLoc_colsSerialNo

   p5_ VARCHAR2(32000) := '*';

   -- p6 -> i_hWndFrame.frmIssue.tblPartLoc_colsEngChgLevel

   p6_ VARCHAR2(32000) := '1';

   -- p7 -> i_hWndFrame.frmIssue.tblPartLoc_colsWaivDevRejNo

   p7_ VARCHAR2(32000) := '*';

   -- p8 -> i_hWndFrame.frmIssue.tblPartLoc_colnQtyIssued

   p8_ FLOAT := 1;

   -- p9 -> i_hWndFrame.frmIssue.tblPartLoc_colnQtyCatchIssued

   p9_ FLOAT := NULL;

   -- p10 -> i_hWndFrame.frmIssue.tblPartLoc_colsAccountNo

   p10_ VARCHAR2(32000) := '';

   -- p11 -> i_hWndFrame.frmIssue.tblPartLoc_colsCostCenter

   p11_ VARCHAR2(32000) := '';

   -- p12 -> i_hWndFrame.frmIssue.tblPartLoc_colsCodeC

   p12_ VARCHAR2(32000) := '';

   -- p13 -> i_hWndFrame.frmIssue.tblPartLoc_colsCodeD

   p13_ VARCHAR2(32000) := '';

   -- p14 -> i_hWndFrame.frmIssue.tblPartLoc_colsObjectNo

   p14_ VARCHAR2(32000) := '';

   -- p15 -> i_hWndFrame.frmIssue.tblPartLoc_colsProjectNo

   p15_ VARCHAR2(32000) := '';

   -- p16 -> i_hWndFrame.frmIssue.tblPartLoc_colsCodeG

   p16_ VARCHAR2(32000) := '';

   -- p17 -> i_hWndFrame.frmIssue.tblPartLoc_colsCodeH

   p17_ VARCHAR2(32000) := '';

   -- p18 -> i_hWndFrame.frmIssue.tblPartLoc_colsCodeI

   p18_ VARCHAR2(32000) := '';

   -- p19 -> i_hWndFrame.frmIssue.tblPartLoc_colsCodeJ

   p19_ VARCHAR2(32000) := '';

   -- p20 -> i_hWndFrame.frmIssue.tblPartLoc_colsInvtranSource

   p20_ VARCHAR2(32000) := '';

   -- p21 -> i_hWndFrame.frmIssue.nPartTrackSessionId

   p21_ FLOAT := NULL;

BEGIN

    

Inventory_Part_In_Stock_API.Issue_Part_With_Posting(p0_ , p1_ , p2_ , p3_ , p4_ , p5_ , p6_ , p7_ , 0, 

'NISS', p8_ , p9_ , p10_ , p11_ , p12_ , p13_ , p14_ , p15_ , p16_ , p17_ , p18_ , p19_ , p20_ , p21_ );

Reply