Function in macro
In APO snp planning book under stock balance macro i've added one customized step to handle multiplant scenario. Case is i've two manufacturing units A and B and ATD receipts of A should be stock of A plus stock of B.
For this i've created on auxillary row to read physical stock of B using function physical stock and then ATD receipts of location A is ATD receipts plus auxillary row. The issue in this is while reading physical stock of B im using category CC but is any open sto with caategory BI is there then that much quantity has to be reduced from physical stock and for this i need to reduce category BI from physical stock so correct available stock of B will get added to A.
Currenlty macro step for auxillary row is ,
Stock clubbing auxillay = physical stock ( act_product ; 'A' ; '000' ; 'cc') - physical stock ( act_product ; 'A' ; '000' ; 'BI')
But above syntax is nt gving correct result. Can u pls tell which function i can use to read category BI for particular location .