Hi expert,
I'm facing difficulty while uploading FA balance in general ledger entry in DIEF, I have 2 lines journal, but only 1 row succeed with account type = Ledger, the other one failed with account type = Fixed asset.
error fail as follows:
Preview Job ID Stage Created date and time Log text
No GL-15 Target 11/7/2015 06:37:20 am Results. Record ('FA1-FA02-1.00') . Financial dimension value 180100 does not exist.Results. Record ('FA1-FA02-1.00') . Error found when validating record.Results. Record ('FA1-FA02-2.00') . Field 'Project' must be filled in.Results. Record ('FA1-FA02-2.00') . Field 'Category' must be filled in.Results. Record ('FA1-FA02-2.00') . Field 'Project date' must be filled in.Results. Record ('FA1-FA02-2.00') . Category must be specified.Data written to target 'Opening balance' ('0' records created, '1' records updated)
No GL-15 Source 11/7/2015 06:37:07 am '2' 'Opening balance' record(s) inserted in staging
No GL-15 Target 7/21/2015 07:42:51 pm Data written to target 'GLJOURNAL' ('2' records created, '0' records updated)
No GL-15 Source 7/21/2015 07:42:33 pm '2' 'GLJOURNAL' record(s) inserted in staging
if I enter manually, it success. the template as below :
| JournalName |
JournalNum |
Voucher |
LineNum |
CurrencyCode |
TransDate |
AccountType |
Asset_AssetId |
Asset_BookId |
Asset_TransType |
LedgerDimension |
AmountCurDebit |
AmountCurCredit |
| GenJrn |
FA1 |
FA02 |
1.00 |
USD |
30/09/2015 |
Fixed assets |
BB |
SLRL |
Acquisition |
180100 |
10,000.00 |
|
| GenJrn |
FA1 |
FA02 |
2.00 |
USD |
30/09/2015 |
Ledger |
|
|
|
800100-002-022- |
|
10,000.00 |
I need your experience to give me an advice.
thanks before.
*This post is locked for comments
I have the same question (0)
