I have a database with three companies including a master blank database a test system and live one. When I post a revaluation journal in the test company and if the dimension code 1 is left left blank it will not let me post the journal give me a error on code unit 11 at this point.
IF NOT DimMgt.CheckJnlLineDimValuePosting(JnlLineDim,TableID,No) THEN
IF "Line No." <> 0 THEN
ERROR(
Text012,
TABLECAPTION,"Journal Template Name","Journal Batch Name","Line No.",
DimMgt.GetDimValuePostingErr)
ELSE
ERROR(DimMgt.GetDimValuePostingErr);
END;
Yet in the live company it goes past the validation in code unit 11 and posts the revaluation journal without giving me this error and my question is why does it allow this.
I have checked table 349 dimension values and there are no blank or extra records there.
This is very urgent as we go live in six weeks and I desperatly need some
help.
0
Answers
There is a couple of things you can check:
On Table 348:
Check if the Dimension exist
Check if the Dimension is blocked
On Table 349:
Check if the Dimension Value exist
Check if the Dimension Value is blocked
Check if the Dimension Value Type is either "Standard" or "Begin-Total"
On Table 352:
Check for the specific entry if fails on, what is the value of the "Value Posting" field, i.e. "Code Mandatory", "Same Code", etc.
Remember, the settings on the test database is not necesarily the same as on the Live database...