Catalysis of the reaction: N-acetyl-L-glutamate 5-semialdehyde + NADP+ + phosphate = N-acetyl-5-glutamyl phosphate + NADPH + H+.
N-acetyl-L-glutamate gamma-semialdehyde:NADP oxidoreductase (phosphorylating)