Level2 Sprint 3 3.3.5.4 Update INV01 to Allow Override of Order Amount

Options

Hi

 

I have got struck up with the activity attached the same,  below  is the formula which i have done. please correct me if i am wrong.

 

IF NOT Submit Purchase Order Request? THEN 0 ELSE IF NOT Override Suggested Order Amount? THEN Suggested Order Amount for the Month ELSE Override Amount

Comments

  • Humay
    Options

    Hi,

     

    I would suggest to keep 'Submit Purchase Order Request?' and 'Override Suggested Order Amount?' line items as one IF condition and update the formula accordingly.

     

    'Final Shipment'  amount can be equal either 'Suggested Order Amount for the Month' or 'Override Amount' and in order to be equal to 'Suggested Order Amount for the Month' there should not be override on suggested order amount. For 'Override Amount' it is opposite.

     

    Hope this helps!

  • Humay
    Options
    Hi there,

    If this solution is helpful, please mark the question as 'solved'.

    Thanks!
  • Thanks @Humay  - Will your answer follow the suggestion given by the training module? Below is the screenshot of the training module requirement:

    Saket2022_0-1655704578469.png