3.3.7.2 Add DCA to INV01 Inventory Ordering

Add Read and Write Access Drivers to INV01 Inventory Ordering module to set up Dynamic Cell Access to perform as shown in the example below:

Week 1 & 2 (blue highlight)

  • Week 1 shows the result when Submit Purchase Order Request is NOT checked.
  • Week 2 shows the result when Submit Purchase Order Request is checked (however, in the example nothing is writable).

Week 3 (pink highlight)

  • Week 3 shows the result when Override Suggested Order Amount is checked - Override Amount is writable.

Week 4 (green highlight)

  • Week 4 shows the result when Override Shipping Method is checked - Override Method is writable.

 

How do I get forward with this?

Tagged:

Comments

  • jagadishdash
    edited November 2022

    @Yogitha 

    In the override amount :-In the blueprint view under write access driver you need to select the Override Suggested Order Amount?

    So DCA will applicable whenever Override Suggested Order Amount? Boolean checked.

     

    Thanks,

     

    Jagadish Dash  

  • Yogitha
    edited November 2022

    That's it?

     

    • Week 4 shows the result when Override Shipping Method is checked - Override Method is writable.

    What to do for the above?

  • jagadishdash
    edited November 2022

    yes,

    Now you can check .. when Override Shipping Method is checked then only the amount column is writable.

     

    If this worked, then you did correct.

     

    thanks,

  • Yogitha
    edited November 2022

    @jagadishdash 

    I still see discrepancy.

     

     2022-10-31 (7).png2022-10-31 (8).png2022-10-31 (9).png

  • Yogitha
    edited November 2022

    @Misbah 

     

    Need guidance!!

    Attached in the thread my query

  • Misbah
    edited November 2022

    @Yogitha 

     

    In your DCA columns of INV01 module,  you will have to use the line items that you may have created in AD02 module and not the line item that you have used currently which is from the same module. 

     

    Hope that helps

    Misbah

    Miz Logix

  • Yogitha
    edited November 2022

    Should I remove this?

    should I remove this?should I remove this?

  • Yogitha
    edited November 2022

    @Misbah 

     

    Which one should I delete from the drop down and can you explain why?2022-10-31 (10).png

  • Misbah
    edited November 2022

    @Yogitha 

     

    There are three lines 

    AD02 Inventory Ordering Overrides.Submit Purchase Order,

    AD02 Inventory Ordering Overrides.Override shipping and

    AD02 Inventory Ordering Overrides.Override Amount.

    Use these lines for Submit Purchase Order, Override Suggested Order amount, Override Shipping and Override Amount

     

    Thanks,

    Misbah

    Miz Logix

  • Yogitha
    edited November 2022

    @Misbah 

     

    Nope, values not matching.

    2022-10-31 (11).png2022-10-31 (8).png

  • Misbah
    edited November 2022

    @Yogitha 

    Share the screenshot of AD02 module - both module view as well as blueprint view

  • Yogitha
    edited November 2022

    @Misbah 

     

    Should I remove the "Submit Purchase order" write access as you striked it off?

     

    Yeah attaching AD02

     

  • Yogitha
    edited November 2022

    @Misbah 

    Screenshot of AD02 Module 

     

    2022-10-31 (13).png2022-10-31 (14).png

  • Misbah
    edited November 2022

    @Yogitha 

     

    Yes, please place that in Override Suggested amount line item and not Submit Purchase Order Request Line.

     

  • Misbah
    edited November 2022

    @Yogitha 

     

    Also, on the DCA Issue -  place the same three AD lines in Read Access driver as well.

    That should fix it

     

    Misbah

    Miz Logix

  • Yogitha
    edited November 2022

    @Misbah 

     

    correct?correct?

  • Yogitha
    edited November 2022

    @Misbah 

     

    I don't see any difference , still the discrepancy exists. sharing below the snapshots of them

     

    2022-10-31 (17).png2022-10-31 (16).png2022-10-31 (7).png 

  • Yogitha
    edited November 2022

    @Misbah 

    Not able to figure out what's going wrong

  • Misbah
    edited November 2022

    @Yogitha 

     

    This is working. I see week 1 override suggested order amount hidden now. based on the selections that you make in booleans DCA will apply accordingly

     

    Thanks,

    Misbah

    Miz Logix

  • Yogitha
    edited November 2022

    @Misbah 

     

    But the values are not same right when compared to the Expected and my result?

  • @Misbah 

     

    Is this right?

    2022-11-03 (9).png

  • @Yogitha 

     

    Looks ok to me