Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Got error message when...
Microsoft Dynamics SL (Archived)

Got error message when import GL data to Journal Transactions (0101000) screen

(0) ShareShare
ReportReport
Posted on by Ginny Liao 4

Tried to import a revised file to 0101000 screen, all the error message indicates the fields are disabled field when each of field not listed as a disabled field in the template. I was able to import a original file with no problem, but having an issue after adding 5 more fields to the file.

How do I fix the problem? 

Error log: 

'System Message 8005: New Record Requested

'System Message 8012: ========Successful Processing of a Level0 Data Line========

'System Message 8011: ========Begin Processing of a Level1,INSERT Data Line========
'"Level1,INSERT",100,2150,NP,,10000000,,2/4/2017 0:00,FLORESFLOR,,Yes,67.75,0,1138.91,,,C,2/4/2017 0:00
'System Message 8005: New Record Requested

'System Message 8036: Invalid attempt to populate a disabled field: cemployeeid with value: FLORESFLOR

'System Message 8036: Invalid attempt to populate a disabled field: cbillable with value: Yes

'System Message 8036: Invalid attempt to populate a disabled field: creconstatus with value: C

'System Message 8036: Invalid attempt to populate a disabled field: ccleardate with value: 2/4/2017 0:00

'System Message 8012: ========Successful Processing of a Level1,INSERT Data Line========

'System Message 8011: ========Begin Processing of a Level1,INSERT Data Line========
'"Level1,INSERT",100,5010,TC800 ,80800PR10 - REG PREX ,30383000,51747,2/4/2017 0:00,FLORESFLOR,U15E,Yes,5.5,138.05,0,Krnos Import File,test,C,2/4/2017 0:00
'System Message 8005: New Record Requested

'System Message 8020: Invalid possible value for a ComboBox. Control: cbillable Value:

'System Message 8016: Possible values for the control cbillable are ;Yes ,N;No

'System Message 8036: Invalid attempt to populate a disabled field: creconstatus with value: C

'System Message 8036: Invalid attempt to populate a disabled field: ccleardate with value: 2/4/2017 0:00

'System Message 8055: ========Error Processing Level1,INSERT Data Line========

'System Message 8011: ========Begin Processing of a Level1,INSERT Data Line========
'"Level1,INSERT",100,5010,TC800 ,80800PR10 - REG PREX ,20290000,51747,2/4/2017 0:00,FLORESFLOR,U15E,Yes,24,602.4,0,,,C,2/4/2017 0:00
'System Message 8005: New Record Requested

'System Message 8020: Invalid possible value for a ComboBox. Control: cbillable Value:

'System Message 8016: Possible values for the control cbillable are ;Yes ,N;No

'System Message 8036: Invalid attempt to populate a disabled field: creconstatus with value: C

'System Message 8036: Invalid attempt to populate a disabled field: ccleardate with value: 2/4/2017 0:00

'System Message 8055: ========Error Processing Level1,INSERT Data Line========

'System Message 8011: ========Begin Processing of a Level1,INSERT Data Line========
'"Level1,INSERT",100,5040,TC800 ,80800PR12 - OT PREX ,30383000,51747,2/4/2017 0:00,FLORESFLOR,U15E,Yes,4,150.6,0,,,C,2/4/2017 0:00
'System Message 8005: New Record Requested

'System Message 8020: Invalid possible value for a ComboBox. Control: cbillable Value:

'System Message 8016: Possible values for the control cbillable are ;Yes ,N;No

'System Message 8036: Invalid attempt to populate a disabled field: creconstatus with value: C

'System Message 8036: Invalid attempt to populate a disabled field: ccleardate with value: 2/4/2017 0:00

'System Message 8055: ========Error Processing Level1,INSERT Data Line========

'System Message 8011: ========Begin Processing of a Level1,INSERT Data Line========
'"Level1,INSERT",100,5090,TC800 ,80800PR14 - ONCALL PREX ,20290000,51747,2/4/2017 0:00,FLORESFLOR,U15E,Yes,8,200.8,0,Krnos Import File,,C,2/4/2017 0:00
'System Message 8005: New Record Requested

'System Message 8020: Invalid possible value for a ComboBox. Control: cbillable Value:

'System Message 8016: Possible values for the control cbillable are ;Yes ,N;No

'System Message 8036: Invalid attempt to populate a disabled field: creconstatus with value: C

'System Message 8036: Invalid attempt to populate a disabled field: ccleardate with value: 2/4/2017 0:00

'System Message 8055: ========Error Processing Level1,INSERT Data Line========

'System Message 8011: ========Begin Processing of a Level1,INSERT Data Line========
'"Level1,INSERT",100,5092,TC800 ,80800PR16 - CALLIN PREX ,20290000,51747,2/4/2017 0:00,FLORESFLOR,U15E,Yes,1.25,47.06,0,Krnos Import File,test,C,2/4/2017 0:00
'System Message 8005: New Record Requested

'System Message 8020: Invalid possible value for a ComboBox. Control: cbillable Value:

'System Message 8016: Possible values for the control cbillable are ;Yes ,N;No

'System Message 8036: Invalid attempt to populate a disabled field: creconstatus with value: C

'System Message 8036: Invalid attempt to populate a disabled field: ccleardate with value: 2/4/2017 0:00

'System Message 8055: ========Error Processing Level1,INSERT Data Line========

'System Message 8011: ========Begin Processing of a Level1,INSERT Data Line========
'"Level1,INSERT",100,2150,NP,,10000000, ,2/4/2017 0:00,GIBSONJACO, ,Yes,40,0,1223.08,,,C,2/4/2017 0:00
'System Message 8005: New Record Requested

'System Message 8036: Invalid attempt to populate a disabled field: cemployeeid with value: GIBSONJACO

'System Message 8036: Invalid attempt to populate a disabled field: cbillable with value: Yes

'System Message 8036: Invalid attempt to populate a disabled field: creconstatus with value: C

'System Message 8036: Invalid attempt to populate a disabled field: ccleardate with value: 2/4/2017 0:00

'System Message 8012: ========Successful Processing of a Level1,INSERT Data Line========

'System Message 8011: ========Begin Processing of a Level1,INSERT Data Line========
'"Level1,INSERT",100,5010,F17055 ,50230K6REG HRS CNIN ,50230000,51841,2/4/2017 0:00,GIBSONJACO,BPC4,Yes,2,61.15,0,Krnos Import File,test,C,2/4/2017 0:00
'System Message 8005: New Record Requested

'System Message 8020: Invalid possible value for a ComboBox. Control: cbillable Value:

'System Message 8016: Possible values for the control cbillable are ;Yes ,N;No

'System Message 8036: Invalid attempt to populate a disabled field: creconstatus with value: C

'System Message 8036: Invalid attempt to populate a disabled field: ccleardate with value: 2/4/2017 0:00

'System Message 8055: ========Error Processing Level1,INSERT Data Line========

'System Message 8011: ========Begin Processing of a Level1,INSERT Data Line========
'"Level1,INSERT",100,5010,F17050 ,50230K7REG HRS CNIN ,50230000,51841,2/4/2017 0:00,GIBSONJACO,BPC4,Yes,7,214.04,0,,,C,2/4/2017 0:00
'System Message 8005: New Record Requested

'System Message 8020: Invalid possible value for a ComboBox. Control: cbillable Value:

'System Message 8016: Possible values for the control cbillable are ;Yes ,N;No

'System Message 8036: Invalid attempt to populate a disabled field: creconstatus with value: C

'System Message 8036: Invalid attempt to populate a disabled field: ccleardate with value: 2/4/2017 0:00

'System Message 8055: ========Error Processing Level1,INSERT Data Line========

'System Message 8011: ========Begin Processing of a Level1,INSERT Data Line========
'"Level1,INSERT",100,5010,TC700 ,80700PR10 - REG PREX ,50230000,51841,2/4/2017 0:00,GIBSONJACO,BPC4,Yes,23,703.27,0,,,C,2/4/2017 0:00
'System Message 8005: New Record Requested

'System Message 8020: Invalid possible value for a ComboBox. Control: cbillable Value:

'System Message 8016: Possible values for the control cbillable are ;Yes ,N;No

'System Message 8036: Invalid attempt to populate a disabled field: creconstatus with value: C

'System Message 8036: Invalid attempt to populate a disabled field: ccleardate with value: 2/4/2017 0:00

'System Message 8055: ========Error Processing Level1,INSERT Data Line========

'System Message 8011: ========Begin Processing of a Level1,INSERT Data Line========
'"Level1,INSERT",100,2115,TC700 ,80700PR30 - PTO PREX ,50230000,51841,2/4/2017 0:00,GIBSONJACO,BPC4,Yes,8,244.62,0,Krnos Import File,test,C,2/4/2017 0:00
'System Message 8005: New Record Requested

'System Message 8020: Invalid possible value for a ComboBox. Control: cbillable Value:

'System Message 8016: Possible values for the control cbillable are ;Yes ,N;No

'System Message 8036: Invalid attempt to populate a disabled field: creconstatus with value: C

'System Message 8036: Invalid attempt to populate a disabled field: ccleardate with value: 2/4/2017 0:00

'System Message 8055: ========Error Processing Level1,INSERT Data Line========
Level0,,KRO,N,201707,H,ACTUAL ,0,0,,,2361.99,,,,,,
"Level1,INSERT",100,2150,NP,,10000000,,2/4/2017 0:00,FLORESFLOR,,Yes,67.75,0,1138.91,,,C,2/4/2017 0:00
"Level1,INSERT",100,5010,TC800 ,80800PR10 - REG PREX ,30383000,51747,2/4/2017 0:00,FLORESFLOR,U15E,Yes,5.5,138.05,0,Krnos Import File,test,C,2/4/2017 0:00
"Level1,INSERT",100,5010,TC800 ,80800PR10 - REG PREX ,20290000,51747,2/4/2017 0:00,FLORESFLOR,U15E,Yes,24,602.4,0,,,C,2/4/2017 0:00
"Level1,INSERT",100,5040,TC800 ,80800PR12 - OT PREX ,30383000,51747,2/4/2017 0:00,FLORESFLOR,U15E,Yes,4,150.6,0,,,C,2/4/2017 0:00
"Level1,INSERT",100,5090,TC800 ,80800PR14 - ONCALL PREX ,20290000,51747,2/4/2017 0:00,FLORESFLOR,U15E,Yes,8,200.8,0,Krnos Import File,,C,2/4/2017 0:00
"Level1,INSERT",100,5092,TC800 ,80800PR16 - CALLIN PREX ,20290000,51747,2/4/2017 0:00,FLORESFLOR,U15E,Yes,1.25,47.06,0,Krnos Import File,test,C,2/4/2017 0:00
"Level1,INSERT",100,2150,NP,,10000000, ,2/4/2017 0:00,GIBSONJACO, ,Yes,40,0,1223.08,,,C,2/4/2017 0:00
"Level1,INSERT",100,5010,F17055 ,50230K6REG HRS CNIN ,50230000,51841,2/4/2017 0:00,GIBSONJACO,BPC4,Yes,2,61.15,0,Krnos Import File,test,C,2/4/2017 0:00
"Level1,INSERT",100,5010,F17050 ,50230K7REG HRS CNIN ,50230000,51841,2/4/2017 0:00,GIBSONJACO,BPC4,Yes,7,214.04,0,,,C,2/4/2017 0:00
"Level1,INSERT",100,5010,TC700 ,80700PR10 - REG PREX ,50230000,51841,2/4/2017 0:00,GIBSONJACO,BPC4,Yes,23,703.27,0,,,C,2/4/2017 0:00
"Level1,INSERT",100,2115,TC700 ,80700PR30 - PTO PREX ,50230000,51841,2/4/2017 0:00,GIBSONJACO,BPC4,Yes,8,244.62,0,Krnos Import File,test,C,2/4/2017 0:00

'System Message 8030: The Number of Errors detected was 9

'System Message 8001: Completed Processing 16:38:27

Template:

'ControlMacroType: VBAComplete
' VBComponent: ThisScreen, ComponentType: 100 **********************************************************
'01010 Control Macro
Sub ProcessImportLine( LevelNumber%, Retval% )
select Case LevelNumber
case TI_Start

call AliasConstant( "Level0", "Batch" )

call AliasConstant( "Level1", "Detail" )

case 0 ' 0 of 1

'Level 0 if of Type N
' cmodule is a key field for level 0
'Currently Disabled cmodule

' cbatnbrH is a key field for level 0
' Field mask is UUUUUUUUUU
serr = SetObjectValue( "cbatnbrH", ImportField(1) )

' Field mask is UUU
' NOTE -- This field is a required field
serr = SetObjectValue( "cjrnltypeH", ImportField(2) )

' cbattype is an Combo Box
' Values are J;Adjustment ,A;Allocation ,C;Consolidation ,M;Manual ,N;Nonrecurring ,R;Recurring
' NOTE -- This field is a required field
serr = SetObjectValue( "cbattype", ImportField(3) )

' cperpostH is a Period Field
' NOTE -- This field is a required field
serr = SetObjectValue( "cperpostH", ImportField(4) )

'Currently Disabled cstatus

' cBatchHandling is an Combo Box
' Values are H;Hold,B;Release Later,R;Release Now,N;No Action
' NOTE -- This field is a required field
serr = SetObjectValue( "cBatchHandling", ImportField(5) )

' Field mask is UUUUUUUUUU
' NOTE -- This field is a required field
serr = SetObjectValue( "cledgerid", ImportField(6) )

' cAutoRefNbr is an Check Box
' Values are -1 for ON and 0 for OFF
' Values are CHECKED for ON and UNCHECKED for OFF
serr = SetObjectValue( "cAutoRefNbr", ImportField(7) )

' cautorev is an Check Box
' Values are 1 for ON and 0 for OFF
' Values are CHECKED for ON and UNCHECKED for OFF
' NOTE -- This field is a required field
serr = SetObjectValue( "cautorev", ImportField(8) )

serr = SetObjectValue( "ccycle", ImportField(9) )

serr = SetObjectValue( "cnbrcycle", ImportField(10) )

'Currently Disabled corigbatnbr

serr = SetObjectValue( "cctrltot", ImportField(11) )

'Currently Disabled cdrtot

'Currently Disabled ccrtot


case 1 ' 1 of 1

'Level 1 if of Type D
' Field mask is UUUUUUUUUU
serr = SetObjectValue( "ctcompany", ImportField(1) )

' Field mask is UUUUUUUUUU
' NOTE -- This field is a required field
serr = SetObjectValue( "cacct", ImportField(2) )

' Field mask is WWWWWWWWWW
serr = SetObjectValue( "cprojectid", ImportField(3) )

' Field mask is UU-UUU-UU-UUUUUUUUUUUUU-UU-UU
serr = SetObjectValue( "ctaskid", ImportField(4) )

' Field mask is 99-999-999
' NOTE -- This field is a required field
serr = SetObjectValue( "csub", ImportField(5) )

' Field mask is UUUUUUUUUU
serr = SetObjectValue( "crefnbr", ImportField(6) )

' ctrandate is a Date Field Type
serr = SetObjectValue( "ctrandate", ImportField(7) )

' Field mask is UUUUUUUUUU
serr = SetObjectValue( "cEmployeeID", ImportField(8) )

' Field mask is UUUU
serr = SetObjectValue( "claborclass", ImportField(9) )

' cBillable is an Combo Box
' Values are ;Yes ,N;No
serr = SetObjectValue( "cBillable", ImportField(10) )

serr = SetObjectValue( "cQty", ImportField(11) )

serr = SetObjectValue( "cdramt", ImportField(12) )

serr = SetObjectValue( "ccramt", ImportField(13) )

' Field mask is XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
serr = SetObjectValue( "ctrandesc", ImportField(14) )

' Field mask is XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
serr = SetObjectValue( "xuser1", ImportField(15) )

' creconstatus is an Combo Box
' Values are C;Cleared,O;Outstanding
' NOTE -- This field is a required field
serr = SetObjectValue( "creconstatus", ImportField(16) )

' ccleardate is a Date Field Type
' NOTE -- This field is a required field
serr = SetObjectValue( "ccleardate", ImportField(17) )


case TI_Finish

End Select
End Sub
' The following shows the correct syntax to
' PRESS a button
' These object names are specific to this screen.
' Button object name TemplateFormBtnPaste, Caption Paste
' serr = SetObjectValue( "TemplateFormBtnPaste", "PRESS" )

' Button object name TemplateFormBtnSave, Caption Save
' serr = SetObjectValue( "TemplateFormBtnSave", "PRESS" )

' Button object name TemplateFormBtnDelete, Caption Delete
' serr = SetObjectValue( "TemplateFormBtnDelete", "PRESS" )

' Button object name TemplateFormBtnClose, Caption Close
' serr = SetObjectValue( "TemplateFormBtnClose", "PRESS" )

' End VBComponent **********************************************************

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Got error message when import GL data to Journal Transactions (0101000) screen

    Ginny, I believe those fields are not available for user entry on the 0101000 screen.  They are fields populated by actions such as check update (for the employee field during a PR check update) or during bank reconciliation / cash manager when the GLTran records are being created.  I am curious as to why you would be trying to populate these fields during a JE entry (either manually or via Transaction Import.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans