Level 2 INV01 Begging inventory and Confirmed PO line item

ankitaga2000
Frequent Contributor

Level 2 INV01 Begging inventory and Confirmed PO line item

Hi All,

 

Please help me with the formula for Beginning Inventory 

 

My formula is - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

 

I don't know why I am getting everything negative in Beginning Inventory 

ankitaga2000_0-1616125569102.png

 

Also let me know If i am correct in using the correct formula for Confirmed PO Delivery

OFFSET(PO submitted, -Shipping Time Weeks, 0)

 

 

 

Regards,

Ankita

2 ACCEPTED SOLUTIONS

Accepted Solutions
Misbah
Moderator

Re: Level 2 INV01 Begging inventory and Confirmed PO line item

ankitaga2000
Frequent Contributor

Re: Level 2 INV01 Begging inventory and Confirmed PO line item

10 REPLIES 10
Misbah
Moderator

Re: Level 2 INV01 Begging inventory and Confirmed PO line item

@ankitaga2000 

 

Your Formulae looks perfect. However I see Reorder Flag checked every week which must be throwing your numbers off. And I also see Shipping Time Weeks populated as 0. For Shipping Method as "Road" it needs to show "2" in Shipping Time Weeks

 

Hope that helps

Misbah

ankitaga2000
Frequent Contributor

Re: Level 2 INV01 Begging inventory and Confirmed PO line item

@Misbah 

I have corrected my Shipping time Weeks line item. But why my reorder flag is checked for all. I am not able to understand .Also the beginning inventory ?

ankitaga2000_0-1616151630890.png

The formula for REdorder flag -- IF OFFSET(Ending Inventory, Shipping Time Weeks, 0) <= 0 THEN TRUE ELSE FALSE

 

Regards,

Ankita

Misbah
Moderator

Re: Level 2 INV01 Begging inventory and Confirmed PO line item

@ankitaga2000 

 

Formula looks ok to me not as per best practice though - You don't need to write IF else statement here

 

OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0

 

Now to your query: Can you please share how your DAT Beginning Inventory module looks like, I mean are the numbers populated correctly

Also can you check if your SYS Time Module is working fine. Snapshot here would help

ankitaga2000
Frequent Contributor

Re: Level 2 INV01 Begging inventory and Confirmed PO line item

I am attaching the screen shots for DAT01 and SYS01 modules. Please verify as they are populated correctly.

@Misbah 

ankitaga2000_0-1616167671224.png

ankitaga2000_1-1616167683665.png

 

Misbah
Moderator

Re: Level 2 INV01 Begging inventory and Confirmed PO line item

@ankitaga2000 

 

Not First Week of Timescale looks wrong. First Week should be Unchecked. 

 

Verify the formula: It should be like this

 

NOT (OFFSET(1, -1, 0) = 0)

ankitaga2000
Frequent Contributor

Re: Level 2 INV01 Begging inventory and Confirmed PO line item

Wait . I am confused. @Misbah 

This is formula for First Week of scale ===     NOT (OFFSET(1, -1, 0) = 0)

 

Correct ?

 

Regards,

Ankita

Misbah
Moderator

Re: Level 2 INV01 Begging inventory and Confirmed PO line item

Nope. 

This is for the line item which is titled as NOT FIRST WEEK OF TIMESCALE

 

OFFSET(1,-1,0) = 0 This will be for First week of timescale

NOT(OFFSET(1,-1,0) = 0 will be for Not First Week of timescale

ankitaga2000
Frequent Contributor

Re: Level 2 INV01 Begging inventory and Confirmed PO line item

Can you please explain me these formulas . I am not very clear

Misbah
Moderator

Re: Level 2 INV01 Begging inventory and Confirmed PO line item