Upload GL Journal from Excel file ?

(0) Share

Report

Posted on by Ashraf Kamal

165

Hi All ,

i do a job to import GL Journal from Excel every thing is uploaded successfully but

when validate or press on line the journal the ledger dimension or (Segment controle value ) disappear

and get errors ( Account structure General Expense, for the combination 610201009-Western-DPT-008-None-None-Western-Retail Showroom-00000108, is not valid for ledger )

but when i enter the same line manually with the same value no errors show

any help ?

All responses (4)

Answers (2)

Verified answer

Ashraf Kamal 165 on at

Like (0)

Report

RE: Upload GL Journal from Excel file ?

Hi Andre

Thanks for our reply

i solve it by ... DimensionDefaultingService ::serviceCreateLedgerDimension .

Thanks
Verified answer

André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

RE: Upload GL Journal from Excel file ?

Hi Ashraf,

If you did custom coding, can you share the coding where you filled the default dimension field?
Ashraf Kamal 165 on at

Like (0)

Report

RE: Upload GL Journal from Excel file ?

by Custom X++ coding ?
André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

RE: Upload GL Journal from Excel file ?

Hi Ashraf,

Can you tell how you import the lines from Excel? Are you using the Data Import Export Framework, Excel add-in or custom x++ coding? Please provide some more details.