Error when posting to Customer/Vendor account using General Journal template

(0) Share

Report

Posted on by Ezen

I tried to upload journal that hit my Customer (130001)/Vendor (131001) & Bank account (OCBCSGDC1 & DBSSGDC1) via "General Journal".

However, below message popped up:

The field Bal. Account No. of table Gen. Journal Line contains a value (131001) that cannot be found in the related table (G/L Account).

The field Bal. Account No. of table Gen. Journal Line contains a value (130001) that cannot be found in the related table (G/L Account).

The field Bal. Account No. of table Gen. Journal Line contains a value (DBSSGDC1) that cannot be found in the related table (G/L Account).

The field Bal. Account No. of table Gen. Journal Line contains a value (OCBCSGDC1) that cannot be found in the related table (G/L Account)

Attached please find the excel file used for journal import via Table 81.SPV_5F00_01_5F00_NON-BANK_5F00_Jan20.xlsx SPV_5F00_02_5F00_Bank_5F00_Jan20.xlsx

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

John Ray Patajo 837 on at

Like (0)

Report

Hi Ezen,

Try removing the field Amount LCY on your Excel file and post the GJ.

Please click YES if this resolves your issue.

Thanks.

Regards.

Was this reply helpful? Yes No
Suggested answer

John Ray Patajo 837 on at

Like (0)

Report

Hi Ezen,

Is SGD is your LCY under General Ledger Set-up?

Just remove the Currency Code and try to post.

Also, you can remove the Amount (LCY) column on your template.

Please click Yes if it resolves your issue.

Thanks.

Was this reply helpful? Yes No
Ezen 20 on at

Like (0)

Report

Hi John

Thanks for your suggested solutions.

I tried to remove "Amount (LCY)" column, the error persists.

I even tried to leave Currency Code blank, the issue couldnt get resolved.

Would appreciate your advise.

Thank you very much.

Was this reply helpful? Yes No
Suggested answer

John Ray Patajo 837 on at

Like (0)

Report

Hi Ezen,

Try using Debit and Credit instead of AMount.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Are you using Config Package to upload the journal ? If Yes, please make sure Bal. Account Type is processed before Bal. Account No.

Was this reply helpful? Yes No
Ezen 20 on at

Like (0)

Report

Yes, i am using Config Package to upload my journals.

Noted your point, howvever the "Processing order" of the fields are pre-fixed.

May i know how to amend the order? is it a set-up thingy?

Thanks in advance

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

In the confi package go to the fields then highlight Bal. Account Type and click move up

Was this reply helpful? Yes No
Ezen 20 on at

Like (0)

Report

Thanks for your advise i managed to resolve the issue.

Was this reply helpful? Yes No