7 Replies Latest reply on Nov 11, 2016 6:11 AM by SCM_Specialist

    How PO Distribution Account ID populates

    User492028

      How PO Distribution Account ID populates

        • 1. Re: How PO Distribution Account ID populates
          J Reinhart

          The PO Account Generator does that.   You can modify this workflow to match your business requirements.

          1 person found this helpful
          • 2. Re: How PO Distribution Account ID populates
            User492028

            Could you please share the process to modify the PO Account Generator workflow.

            • 3. Re: How PO Distribution Account ID populates
              SCM_Specialist

              Hello,

              Are you referring PO_DISTRIBUTION_ID in PO_DISTRIBUTIONS_ALL table or want to know how PO Distribution account String/ID populate on Purchase order distribution tab ?

               

              Regards

              Sunil

              1 person found this helpful
              • 4. Re: How PO Distribution Account ID populates
                User492028

                Hi Sunil,

                 

                I would like to know both .

                • 5. Re: How PO Distribution Account ID populates
                  J Reinhart

                  po_distribution_id comes from a sequence that simply counts up by 1 and ensures the values aren't duplicated.

                   

                  The po distribution account comes from the account generator workflow.  There is a tool called Workflow Builder that is used for this.  You build the pieces then connect them like a flow diagram.  E.g. create a piece to check a condition and that box arrows to a decision box that determines which other piece to go to next, etc.  

                   

                  If you haven't modified workflows before, I strongly suggest that you find the default one and start by making two copies of it.  One will be your original_save copy.  The other will be your working_copy.   Make your changes to the working_copy.  Go into Oracle and select your working_copy as the active workflow ant test.  Note what you want to change, then select the original_copy as the active one again and go modify the working_copy.  Repeat this cycle until your working_copy is exactly how you want it, then select that working_copy as the active one and leave it as the active one.   The original_save_copy is there in case you accidentally modify the original one -- you can just make a copy of the original_save_copy to get back to the starting point.

                   

                  Regards,

                   

                  J

                  1 person found this helpful
                  • 6. Re: How PO Distribution Account ID populates
                    User492028

                    For Distribution account  generally what is the code combination .

                    • 7. Re: How PO Distribution Account ID populates
                      SCM_Specialist

                      Hello Dear,

                       

                      -- : PO_DISTRIBUTION_ID comes by sequence on table.

                       

                      --: PO charge account default based on your Item on purchase order

                       

                      a. In case item is expense item , you can directly enter charge account and it is updatable.

                      b. If Item is Inv. Item and Inventory asset Value flag is checked in
                      Costing tab then PO Charge account default from Organization Parameter of
                      INV Org.

                      c. If Item is Inv. Item and Inventory asset Value flag is unchecked (Costing is not enabled) in
                      Costing tab then PO Charge account default from Expense Account field from
                      Purchasing tab of item set up

                       

                      Please let me know if this clear!

                       

                      Regards

                      Sunil Singh