- 3 Posts
- 293 Views
We submitted this idea on MOSC - Ability to move the Alt Account column in the new Journal Spreadsheet Import. The URL is https://community.oracle.com/ideas/16622 (you will be prompted for your Oracle login).Per Doc ID 1612189.1 (PeopleSoft Financials 9.2 Image 20) In Spreadsheet upload templates(both JRNL1.xlsm & JRNL1_WS.xlsm), it is allowed to shift only those columns that appear in between 'Alt Account' & 'Open Item key'. Unable to Move/Shift Columns "Unit","Ledger","Account","Alt Account" and "Open Item Key". We do not use Alt Account and would like to shift the column to the far right to be out of the way. We were able to do this in the last version of the Spreadsheet Journal Import. This is going to confuse our non-Finance Office users that create journal entries.
Thank you Miriam! That works. I was thinking too hard on this one and missed the obvious!
Can you just hide the Alt Account column? I think that's what we did in our 9.1 spreadsheet, but I'm not sure what version you are on.