4 Replies Latest reply on May 10, 2018 7:08 AM by Sanjay Desai EBS

    Restrict Purchase Orders without HSN / SAC / GST Number

    3433948

      Is there a way to restrict / alarm the Purchase Orders for Suppliers without GST Number and Items without HSN / SAC Codes

        • 1. Re: Restrict Purchase Orders without HSN / SAC / GST Number
          Sanjay Desai EBS

          you can put restrict using personalization.

          • 2. Re: Restrict Purchase Orders without HSN / SAC / GST Number
            J Reinhart

            Sanjay's solution will give the user immediate feedback as they enter the PO, and stop it from being saved.  Another idea would be to prevent the site from being a Purchasing site unless there is tax information -- this is also a personalization but it would mean the site isn't even choosable from the LOV.  You could also modify the PO approval workflow to reject POs if the tax info isn't found.  The benefit to doing it via the approval is that you can route the comment to the Purchasing team, who can either update the tax info or possibly suggest an alternative vendor.

            • 3. Re: Restrict Purchase Orders without HSN / SAC / GST Number
              3433948

              Can you elaborate? or share any document to refer?

              • 4. Re: Restrict Purchase Orders without HSN / SAC / GST Number
                Sanjay Desai EBS

                Try with below personalization. It will be mandatory to input HSN on India Tax Details form.

                 

                Trigger Event : WHEN-NEW-BLOCK-INSTANCE

                Trigger Object : PO_APPROVE

                 

                Condition :

                (

                select 1 from po_line_locations_all x, jai_tax_det_factors y

                where y.trx_loc_line_id = x.line_location_id

                and x.org_id = fnd_global.org_id

                and y.trx_number = :po_headers.segment1

                and y.org_id = fnd_global.org_id

                and exists(select 1 from jai_tax_det_factors z where z.det_factor_id= y.det_factor_id and z.hsn_code_id is null)

                )= 1

                or

                (

                select 2 from po_line_locations_all x

                where x.po_header_id = :po_headers.po_header_id

                and not exists(select 2 from  jai_tax_det_factors y

                where y.trx_loc_line_id = x.line_location_id

                and y.org_id = fnd_global.org_id

                and y.trx_number = :po_headers.segment1)

                ) = 2

                 

                 

                Actions :

                Seq : 10

                Type : Message

                Message Type : Show

                Message Text : HSN Code is missing

                 

                Seq : 20

                Type : BuiltIn

                BuiltIn Type : GO_ITEM

                Argument : PO_LINES.ITEM_NUMBER

                 

                Seq : 30

                Type : BuiltIn

                BuiltIn Type : RAISE FORM_TRIGGER_FAILURE