About paulnjr

Good Day! The instructions for importing DATA02 SKU Volumes module says: "The results should have none ignored and 0 errors" Well, I had a large number of ignored records, and I did not have summary data included. After some digging, I discovered the problem. The data I imported into DEM04 Demand Module, first, Misspelled Montreal. The data came in as "Montereal" Since I'm using the Names, instead of the Codes, this caused a number of records to be Ignored. The Second problem is, in the DEM04 Demand data, Mumbai is one of the Locations in India, however, in the Level 1, Model. India only has Bombay, and Bangalore. Had I used the Location Code, I wouldn't have had this problem since Bombay and Mombai both have the code G037 Just thought I'd bring that to your attention! Have an awesome Day! ... View more

Good Day, Quick question... At the end of the INV01 Export, it says: After completing the export file, the .csv file should look like this: How close should it be? Mine: Yours I just don't know how they get the List field name in the upper Left corner, and the dates on the second row..?? Thoughts? Thanks again! ... View more

First of all, I greatly appreciate this community and the help you provide. I have been wracking my brain, searching, and unable to find an answer. Perhaps I'm over thinking this? I was able to get the sum of the Final Shipping Price in with no problem. Where I'm stuck is the Code. I read that I "will want to import G3 Location by Code." Does this mean I'm supposed to import the Location into my INV05 Shipping Export Model? Or is this telling me the Exported File is supposed to be imported at the Location Code Level? Like this? Reading the requirements, I see: "There's no need to recreate." So, I created the subsidiary view by changing the Time Scale on the Code line to NA. This caused the sub view icon to appear on the line. The only thing I could think of putting in the formula for code is to grab the Code from the location list.?? However, looking at the Subsidiary lesson, that doesn't make sense to me. The grid view shows the Code in place? Why would I need a Subsidiary view then? And when I pivot the Module with Location on the Rows and Line Items in the Columns, that's not right!? I know I'm close... and I know it's something small... But, I've been looking at this so long, I can't seem to get it... Any help would be greatly appreciated! Thanks again... ... View more

关于“确认购买订单收据”field. The "Hints" suggest; IF Confirmed PO Delivery > 0 THEN OFFSET(Suggested Order Amount for the Month, -Shipping Time Weeks, 0) ELSE 0 That is working fine. However, I was thinking about using POST, as I do in the "Confirmed PO Delivery". Instead of using an IF THEN statement, Simply use POST. I used PO Submitted * Suggested Order Amount for the Month as the VALUE and offset it by the number of weeks. For the majority of the values, it will be 0 * Suggested Order Amount... which is Zero. Both work fine, I was just wondering which would be more efficient? Thanks for your time! ... View more

I'm looking at the requirements for the Line Chart. I have been able to get the numbers correct. My formulas appear to be working, however, I'm trying to match the template... Where I'm struggling is the Month Numbers at the bottom of the chart. Instead of JAN 20, FEB 20... it's 1, 2, 3...24. Since I don't have Page Builder Role, have to create this on a Page. My Line Chart view of DEM03 Demand Forecast has to contain those numbers instead of the Month Year... Any help pointing me in the right direction would be appreciated. Thanks.. ... View more