İçereği Atla
Menü
Bu soru işaretlendi
1 Cevapla
4143 Görünümler

I'm trying to import some GL journals using v14, through the "journal entries, import a file" option, and receiving a bunch of errors. There is no clear guideline I can see as to which fields I need to be importing into. I only have a limited number of fields in my spreadsheet:

- external transaction ID

- account name

- date

- transaction reference

- debit amount

- credit amount

Can someone advise which of the many fields available these should be mapped to please? The biggest issue I seem to be having is the "account" field - I tried Journal Items/Account (message saying this was ambiguous); /Journal Items/Account/Database ID (no matching record found message for all lines); /Journal Items/Account/External ID (same message).


Update - I have now edited the value in the account column of my spreadsheet to include both the code AND the description. Now, however, when I try to do a test import I get the following message for each line:


Unknown error during import: : Cannot create unbalanced journal entry.

I have debits and credits on separate lines, and the ID for the debit and credit lines are the same.


Avatar
Vazgeç
En İyi Yanıt

Make sure the Total of Debit amounts and Credit amounts are the same


Updated for the last comment : 

see the video https://www.youtube.com/watch?v=PCNXUUi-R1U

Avatar
Vazgeç
Üretici

Can you clarify this some more? If I have a figure in the debit and the credit fields on a single line, then I also need two accounts.... What I have are two lines, with the same external ID, and the first line is a debit and the second line a credit (each with a different account)

Yes, you can keep it as two lines with one for Debit and one for Credit. For example, I have some receivables,

Account Partner Debit Credit

Acc. Receivable Partner1 500 0

Acc. Receivable Partner2 700 0

Opening Bal. 0 1200

Like above you can enter.

Üretici

Hi Balagopal, this is exactly what doesn't work. If I have the debit on one line and the credit on the next line, I get the error for both lines.

İlgili Gönderiler Cevaplar Görünümler Aktivite
1
Mar 25
117
4
May 24
6878
2
Oca 23
5708
2
Tem 22
4354
2
Mar 21
2873