For customers that use more than two dimensions:
When the Gen. Journal has "Show More Columns" set, all the (shortcut) dimensions are shown.
But the Edit in Excel feature only shows the first two "Shortcut" (read, global dimensions). The issue is a technical background, the first two dimensions are the only ones that exists as real fields in the table. The other dimensions (3 to 8) are an array that is calculated and displayed only on the page. But it would be really helpfull to be able to adjust all visible dimensions in Excel instead of only the first two.
Comments
I think this also needs to be included anywhere Edit in Excel is present on transactions, such as Sales Orders, Purchase Orders, Sales Invoices, etc. Users are forced to enter this in manually and if they have transactions with lots of lines this creates a lot of work. Uploading via Edit in Excel would be so much simpler.
Category: Financial Management