And when you drill down on this transaction in the Chart of Accounts, the Dept Code field is blank. Yet when you filter on the dimension code that appeared in the line dimensions of the recurring journal, the transaction was posted to this dimension.
Basically, when you look at the transaction in the general ledger, the dept code field appears blank, but when you drill down on the line dimension, there is a value. So somewhere there is a 'disconnect' between these fields.
I checked tables 17 & 355, and for the transactions I tested, a dept code appears in table 355, but not in table 17.
|Solution||This issue is a result of the confusion in Navision between having dimension codes on the actual transaction entry line, in this case the recurring journal entry line, and the attached dimension table that includes all dimensions to be posted with the transaction.
The inconsistent structure between the treatment of the two global dimensions, which are always attached to all unposted and posted transaction lines, and the additional dimensions creates this problem. The additional dimensions can be entered through shortcut codes available on unposted transaction lines but they are then posted only to the underlying dimension detail table attached to each posted transaction line. The global dimensions will show on both the posted transaction line and the underlying dimension detail.|
Modified on: Mon, Dec 12, 2016 at 2:52 PM
Did you find it helpful?Send feedback