Hi ,
I am trying to past an excel journal file into BC general Journal template and am having issues. It was working yesterday!
I have tried a new journal template. Made sure my excel file format is the same as the BC file.
I can paste one line at a time just not the whole lot.
The error is that it is not recognising the next row in the excel file and is pasting the information in the last cell of row 1 .
when i paste it in i get the following message.
Validation Results
The field Costcentre Code of table Gen. Journal Line contains a value (80 31/12/2022) that cannot be found in the related table (Dimension Value).
this is what the journal in BC looks like when i paste
this is the excel I am trying to paste
Any help would be appreciated
thanks