unable to create the new model in level 1,please provide the solution. ... View more

Hi All,    I am working on a stock rationalization logic where I have Orders as dimension and have to see how the SKUs will get distributed as per the requirements. Attached is a case representing the logic.    For the first 3 days, the supply is pooled and then allocation happens for the SKU. However, for Day 4, the closing inventory after day 3 has to be used, causing the logic to break due to circular references. Note that while I have done random allocations, the logic uses the inventory left after each allocation to decide what is to be allocated next.    Even if I use time as a dimension, I am not able to get the logic working straight because when I use Previous function, it looks at the previous date of the same order id. so for #87, it looks at 08/03/2021 of #87 whereas the actual data it needs to reference is in 08/03/2021 of #54.    I think i have spent too long getting confused so thought I would open it to the wider group for some ideas. Thanks!   ... View more

It seems I am missing the "s G3 Location: Distribution Center" column after I did my import. How do I get that included when importing?   ... View more

So I am playing catch up and I cant figure out the correct mapping for the list. I am on 4.6.5 Activity Import Data into G3 Location List. It doesn't outline the file mapping and sources like it did in the previous activity so Im just wondering what the correct data is for that. I import the list but then I get stuck on verifying the file options and mapping  ... View more

Hi All, Can Someone help as to how can we Identify number within a Text Formatted Line item and move those numbers to a new line item with number as a format using some formula.   E.g. Line item 1: Text Format :  VV123BO Line Item 2: Number Format :  123    ( the line item 2 should automatically identify number in Line item 1 and bring it in line item 2)     Regards, Ronak ... View more