Accounting structure segment count is different on some voucher transactions. Especially if this is regarding vendor balance, vendor settlements, customer balance,...

If the general accounting structure contains 11 segments, some voucher transactions only contain 8-10 segments. This is defined by the accounting structure delimiter, in this case (~).

This was being handled by Microsoft and they acknowledged it was a current bug. But since a fix is impacting the dimension framework they recommended that we raise this scenario with their product group via your idea’s portal.

Detailed scenario delivered by Microsoft:

In our investigation internally we were able to conclude that the issue is a bug but will not be consider now but for future fix, due to the impact on the dimension framework.

We are able to reproduce the issue on foreign currency revaluation voucher.

1.  Two vendor invoices through the general journal were posted. I used vendor 1001, and entered both with EUR currency so they would be revalued. When these invoices were entered, the P&L account structure had 5 dimensions, and the BS account structure had 3 dimensions.

Go to Currency exchange rates and add two new exchange rates for the USD - EUR currency pair. One rate on 3/31/23 and the second for 4/30. Make sure they are different rates. 

1. Run the AP FCR on 3/31/23 (considered date and date of rate). For dimensions, I set that to Posting. 

The following accounting entries were created in Picture #1 (below). 

1. I went to the account structures and added a new dimension to both the BS and P&L account structure. So now the P&L should have 6 dimensions and BS should have 4 dimensions. 
2. Goto the general journal and posted two more invoices for vendor 1001. Again, both were entered for EUR currency. I overrode the default exchange rate to be sure that they would be revalued. 

Run the AP FCR on 4/30/23 (considered date and date of rate). For dimensions, I set that to Posting.

The following accounting entries were created.

Note that we are inconsistent in the reversal of the FCR from the first two invoices. Also the reversal of the gain/loss shows the NEW account structure and has 6 dimensions. But the reversal of the AP ledger account is using the OLD account structure of only 3 dimensions. Another thing to note is that the NEW FCR gain/loss amount (11.99) continues to use the OLD account structure for the BS account, but uses the NEW account structure for the P&L account