3.3.5.2 Inventory Ordering Module Formulas

SupriyaH
Contributor

3.3.5.2 Inventory Ordering Module Formulas

Hi,

 

From 3.3.5.2 Inventory Ordering Module Formulas I am not getting correct output for 2 line items - Beginning inventory and shipping time weeks.

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

Shipping Time Weeks - 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product]

Please refer below screenshots and let me know the correction needed.

SupriyaH_0-1657964378678.pngSupriyaH_1-1657964415827.png

 

thanks.

2 REPLIES 2
JaredDolich
Moderator

@SupriyaH 

Syntax looks good. Check your DAT01 to make sure the data is loaded. It looks like your first week isn't showing up. Also, make sure INV01 is dimensioned with SKU and DC. Looks like you only have SKU.

JaredDolich_0-1658000562149.png

JaredDolich_1-1658000654842.png

 


Jared Dolich
SupriyaH
Contributor

Hi @JaredDolich

I am having data in Beginning inventory. also dimensions are same as you mentioned.

SupriyaH_0-1658025755757.png

SupriyaH_1-1658025822563.png

It is not showing any weeks data. Currently the negative data is populated because of ending inventory. Please check below screenshot once and help me resolve the same.

SupriyaH_2-1658026138531.png

 

Thank you