Hi All,
I have been trying to use the General Journal template to import bulk journal records. Our client requires to select / populate minimum 3 Financial Dimensions in the same field on the form when the Account type field and the Offset Account type fields are Ledger. When I download the template using the Add ins option, the Main Account and Offset Main account cells appear in the template structure however the Account.Customer, Account.Operator, Offset.account.Customer and Offset.account.Operator cells do not appear, hence I use the design option and select these fields manually each time. While filling the template, I can see and select the values for these cells from the right-hand panel.
The values from 3 cells in the template (Account.Customer - Main Account - Account.Operator) need to be populated in a single field named 'Account' & values from 3 offset cells in the template (Offset.account.Customer - Offset.Main.Account - Offset.account.Operator) need to populate in the 'Offset account' field on the Journal Voucher form.
When I fill these cells in the template and click Publish, the values from Account.Customer, Account.Operator, Offset.account.Customer and Offset.account.Operator cells do not populate on the Journal voucher form and are overwritten with messages like Customer does not exist or Operator does not exist in the template.
Please help to understand how to populate these values along with Main Account value in the same field.
Appreciate an immediate support.
Thank you,
Kind regards,
Neeta
