Issues Copying and pasting multiple lines from excel file into general journal template

(0) Share

Report

Posted on by MandyG

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

All responses (1)

Answers (0)