Adjust Cost Report Blocked Dance

Savatage

Hey All here's my question..

3.10B
On my Adjust cost - Item Entries report it only gives you a place for a date. No filtering possibilites.

So Before I run this report I run another report I created that goes thru all the items and UNBLOCKS everything. Because nothing is more annoying than this Adjust Cost report running for 30 min to an hour & then stopping on a blocked item (& you never know if it's the only one it will stop at so It's best to uncheck them all).

Anyway once the report completes I re-run my report putting back all the Checkmarks for the blocked items.

I was wondering if anyone knew off the top of their head where the block testing was happening..
Ie/
Adjust Cost Report or
Inventory Adjustment Codeunit or
ItemCostManagement Codeunit or
Cost Calculation Management Codeunit or
Item Ledger Entries Table

I would like to have the report either ignore that an item is blocked or skip it.

ara3n

there is a thread on this on how to ignore the blocked field. Let me find it.

Savatage

I see in CU22 also Phsy Inventory Journal Posting
(Different Question - but I need to do similar block/unblock operation for this too)

Item.TESTFIELD(Blocked,FALSE);

I was thinking of adding a boolean to the Inventory Setup
Called "Allow Blocked Posting"

then change the CU22 code to

InvSetup.GET;
If NOT InvSetup."Allow Blocked Posting"
 THEN Item.TESTFIELD(Blocked,FALSE);

This way I can turn it on when I need it once a month and then turn it back for daily stuff.

That code is also in Table 83 - Item Journal Line

ara3n

yes, you could do it also that way. Or make is user specific. Add the field to the use r table.

kine

Or you can do it Adjust cost sensitive. In most cases the process is setting the flag that the process is called from Adjustment...