Material Transaction Wizard includes a custom package (M4APS_MATTXNWIZARDCUSTOM) that you can modify to meet your unique requirements. Modifying the custom package is optional, by default it will do nothing.
Material Transaction Wizard custom package can be modified to default any of the following fields on the transaction line:
•Account
•Subinventory
•Subinventory To
•Locator
•Locator To
You can return values and/or error messages to the worksheet. The values will then be available for upload.
Modify the Custom Package
Modifying the custom package will require technical knowledge of PL/SQL (i.e. a developer or DBA resource), as well as functional knowledge to determine how the value should be generated.
Material Transaction Wizard uses a custom package for generating these values i.e. M4APS_MATTXNWIZARDCUSTOM. There are five procedures within this package, one for each of the fields listed above e.g. get_default_subinventory.
You will have received the files (M4APS_MATTXNWIZARDCUSTOM.pkb and M4APS_MATTXNWIZARDCUSTOM.pks) within the MTW_install.zip file. Make the necessary changes to the procedures. Compile the package into the test database and test thoroughly before compiling it into production.
The header Transaction Source will pass only the first 30 characters to the custom package.
The field XML_DOCUMENT_ID is being used for the default Account code ID (GL_CODE_COMBINATION_ID) if the user has entered in the default account.
Use the Custom Package
Material Transaction Wizard will call the custom package to default the fields in the following situations:
•When you use the Transaction Lines form to select an item.
•When you upload a Transaction Line(s) in ‘Validate Only’ mode and any of the fields (listed above) are blank.
•When you upload a Transaction Line(s) in ‘Validate and Upload’ mode and any of the fields are blank.
The new values and/or error message(s) will be returned to the worksheet.
