topic Re: Excise Material Type validation while MIGO in Application Development and Automation Discussions

Excise Material Type validation while MIGO

Former Member — Thu, 29 Oct 2015 05:46:05 GMT

Hello Expert,

My client wants me to develop validation while MIGO. I need to validate the Excise Material type based on Purchase order doc type and Account assignment.

If Purchasing document type is ZXY and Account assignment category is "A" then system should check about the Excise material type in Excise tab.

Please suggest suitable validation or user exit.

Regards,

Pranav

Re: Excise Material Type validation while MIGO

former_member192897 — Thu, 29 Oct 2015 06:28:18 GMT

Irrespective of the PO document type system defaults the Excise Material type in MIGO Item details under Excise tab based on J1ID settings (Material & Chapter Id Combination).

In Standard, if there is already defaulted Excise Material type and if you change it, system gives you a Warning Message. This is not a Configurable Message.

You may check with ABAP team if you can populate the same message as an Error message using User exit.

For your requirement check User exit J_1I7_USEREXIT_MAT_IND serves your requirement.

Re: Excise Material Type validation while MIGO

Former Member — Thu, 29 Oct 2015 06:31:40 GMT

maintain tax code as required entry for the PO document type than automatically it will ask while posting GR entry than we can update to the particular material in J1ID

Re: Excise Material Type validation while MIGO

Former Member — Thu, 29 Oct 2015 07:35:56 GMT

Hi Ashok,

Let me narrate the problem which we are facing.

We are creating capital PO without material code and with account assignment as"A". Now during goods receipt, the user has to select "Assets or Raw material" in excise table as no data will be available in J1ID. here end-user is making mistake by selecting raw material, which is leading to incorrect posting of excise entry.

So we worked out logic that the system should check based on PO doc type + account assignment "A" in PO with excise table in MIGO for material type.

Regards,

Pranav

Re: Excise Material Type validation while MIGO

former_member192897 — Thu, 29 Oct 2015 08:41:01 GMT

You can maintain only Plant combination in J1ID for Account assigned procurement. Leave the Material field blank.

Maintain Only Plant and Chapter id Combination.

For Account assigned procurements,system will pick the Chapter ID from J1ID where Material code is blank for the selected Plant.

Check this and let me know if this solves your requirement.

Re: Excise Material Type validation while MIGO

Former Member — Thu, 29 Oct 2015 08:59:44 GMT

Hi,

You mean to say that if PO type is Capital and Account assignment type is 'A' then material type should be 'Asset' only in Excise duty tab.

To validate the same you can search user exit for CIN in function group j1i7 in se37.

Regards

Ajay

Re: Excise Material Type validation while MIGO

jagdeepsingh83 — Wed, 04 Nov 2015 03:20:02 GMT

Use MIGO BADI-MB_DOCUMENT_BADI