3.3.7.2 Add DCA to INV01 Inventory Ordering

Add Read and Write Access Drivers to INV01 Inventory Ordering module to set up Dynamic Cell Access to perform as shown in the example below:

Week 1 & 2 (blue highlight)

Week 1 shows the result when Submit Purchase Order Request? is NOT checked.
Week 2 shows the result when Submit Purchase Order Request? is checked (however, in the example nothing is writable).

Week 3 (purple highlight)

Week 3 shows the result when Override Suggested Order Amount? is checked - Override Amount is writable.

Week 4 (green highlight)

Week 4 shows the result when Override Shipping Method? is checked - Override Method is writable.

Formula Hint

When creating the Override Shipping – Write? and Override Amount line – Write? line items in the AD02 Inventory Ordering Overrides module, make sure those Boolean-formatted line items are structured so that if the end user decides not to place the order, all relevant fields will return to hidden (as in the Week 1 example above):

Override Amount line – Write? is TRUE (checked) when Submit Purchase Order Request? and Override Suggested Order Amount? are TRUE (checked)
Override Shipping – Write? is TRUE (checked) when Submit Purchase Order Request? and Override Shipping Method? are TRUE (checked)

@Misbah @jagadishdash can you make me understand this.

Accepted answers

jagadishdash

rishavraj,

In this activity, you need to add DCA(Dynamic Cell Access) which will be restrict the access in cell level. Read access driver will able to read and write access driver will be able to write(editable) as per the condition in the driver boolean.

For applying DCA, you need to create 2 boolean line (Override Shipping – Write? and Override Amount line – Write? ) items in AD02 Inventory Ordering Overrides module.

For, Override Amount line – Write?--->> Submit Purchase Order Request? and Override Suggested Order Amount?

For, Override Shipping – Write? -->> Submit Purchase Order Request? and Override Shipping Method?

Then two boolean line item you need to add in the blueprint view write access driver column.

For more deep clarity, refer this :

https://help.anaplan.com/55ae93e6-5139-4bbf-93f9-c8cb06f68f75-Dynamic-cell-access

Hope it helps.

Thanks,

Jagadish Dash

All comments

jagadishdash

rishavraj,

For applying DCA, you need to create 2 boolean line (Override Shipping – Write? and Override Amount line – Write? ) items in AD02 Inventory Ordering Overrides module.

For, Override Amount line – Write?--->> Submit Purchase Order Request? and Override Suggested Order Amount?

For, Override Shipping – Write? -->> Submit Purchase Order Request? and Override Shipping Method?

Then two boolean line item you need to add in the blueprint view write access driver column.

For more deep clarity, refer this :

https://help.anaplan.com/55ae93e6-5139-4bbf-93f9-c8cb06f68f75-Dynamic-cell-access

Hope it helps.

Thanks,

Jagadish Dash

rishavraj

Thanks a bunch for replying back @jagadishdash. After reviewing what I had learn in DCA and your reply, I got some sort of clearance and upon reading the course material twice more I finally figured it out.

jagadishdash

Great!

If it helps, mark answer as solution so it'll help for others too.

Thanks,

Jagadish

Quick Links

Can you help?

Unanswered questions

A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385