Transaction import - error importing Inventory Item using CTL

(0) Share

Report

Posted on by Community Member

Hello All,

Trying to use transaction import with a .CSV and .CTL to setup new Inventory Item in SL 2011... but I get an error and i believe my issue in the Macro dealing with Level1 (the button "Site Details..." that is clicked to set the site details..)

Sample of the Log
'System Message 8026: Insertion of new records on this level are NOT allowed
'System Message 2: Data must be entered in this field
'System Message 8002: Error In Field: cdfltsiteid Value:
'System Message 8004: Data File Record/Line Number: 24 Column: 0

sample of my CSV:
Level0,BB100001,4 HOLE DOCK BUMPER,BUMPER,F,P,F,NN,EXEMPT,AC,1,N,EA,EA,EA,4.95,1300,000000,5200,000000,4200,000000,000000,000000
Level1,GHCWHS,,,,

Below is my .CTL:

'$include: "bsl.dh"
'10250 Control Macro
Sub ProcessImportLine( LevelNumber%, Retval% )
select Case LevelNumber
    case TI_Start

      call AliasConstant( "Level0", "InventoryItem" )

      call AliasConstant( "Level1", "CompanyDefaults" )

    case 0 ' 0 of 1

    'Level 0 if of Type N
      ' cinvtid is a key field for level 0
      ' Field mask is UUUUUUUUUUUUUUUUUUUU
      ' NOTE -- This field is a required field
      serr = SetObjectValue( "cinvtid", ImportField(1) )

      ' Field mask is XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
      serr = SetObjectValue( "cdescr", ImportField(2) )

      ' Field mask is UUUUUU
      ' NOTE -- This field is a required field
      serr = SetObjectValue( "cclassid", ImportField(3) )

'Currently Disabled cMfgClassID

      ' cinvttype is an Combo Box
      ' Values are C;Component Part,L;Labor,F;Finished Good,M;Machine Overhead,D;Other Direct Costs,O;Other type of Item,R;Raw Material,S;Subassembly
      ' NOTE -- This field is a required field
      serr = SetObjectValue( "cinvttype", ImportField(4) )

      ' csource is an Combo Box
      ' Values are M;Manufactured,O;Outsourced,P;Purchased
      ' NOTE -- This field is a required field
      serr = SetObjectValue( "csource", ImportField(5) )

      ' cvalmthd is an Combo Box
      ' Values are F;FIFO ,L;LIFO ,A;Average Cost ,S;Specific Identification ,T;Standard Cost ,U;User-Specified Cost
      ' NOTE -- This field is a required field
      serr = SetObjectValue( "cvalmthd", ImportField(6) )

      ' clotsertrack is an Combo Box
      ' Values are NN;None,LI;Lot Numbered,SI;Serial Numbered
      serr = SetObjectValue( "clotsertrack", ImportField(7) )

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

      ' ctransstatus is an Combo Box
      ' Values are AC;Active,NP;No Purchase,NU;No Usage,OH;On Hold,IN;Inactive,DE;Delete
      serr = SetObjectValue( "ctransstatus", ImportField(9) )

'Currently Disabled cKitType

      ' cstkitem 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( "cstkitem", ImportField(10) )

      ' cchkordqty is an Check Box
      ' Values are Y for ON and N for OFF
      ' Values are CHECKED for ON and UNCHECKED for OFF
      ' NOTE -- This field is a required field
      serr = SetObjectValue( "cchkordqty", ImportField(11) )

      ' Field mask is UUUUUU
      ' NOTE -- This field is a required field
      serr = SetObjectValue( "cstkunit", ImportField(12) )

      ' Field mask is UUUUUU
      ' NOTE -- This field is a required field
      serr = SetObjectValue( "cpounit", ImportField(13) )

      ' Field mask is UUUUUU
      ' NOTE -- This field is a required field
      serr = SetObjectValue( "csounit", ImportField(14) )

      ' NOTE -- This field is a required field
      serr = SetObjectValue( "cstkbaseprc", ImportField(15) )

'Currently Disabled cpstdcost04

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

      ' Field mask is UUUUUU
      ' NOTE -- This field is a required field
      serr = SetObjectValue( "cinvtsub", ImportField(17) )

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

      ' Field mask is UUUUUU
      ' NOTE -- This field is a required field
      serr = SetObjectValue( "ccogssub", ImportField(19) )

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

      ' Field mask is UUUUUU
      ' NOTE -- This field is a required field
      serr = SetObjectValue( "cDfltSalesSub", ImportField(21) )

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

      ' Field mask is UUUUUU
      ' NOTE -- This field is a required field
      serr = SetObjectValue( "cPPVSub", ImportField(23) )

    case 1 ' 1 of 1

    'Level 1 if of Type C
      ' cDfltInvtID is a key field for level 1
      ' cDfltCpnyID is a key field for level 1
      ' Field mask is UUUUUUUUUU
      ' NOTE -- This field is a required field
      serr = SetObjectValue( "cdfltsiteid", ImportField(1) )

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

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

      ' Field mask is 9999-9999
      serr = SetObjectValue( "cpjt_entity", ImportField(4) )

    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 Button05OK, Caption &OK
'      serr = SetObjectValue( "Button05OK", "PRESS" )

'      Button object name ButtonXRef, Caption Item &XRef...
'      serr = SetObjectValue( "ButtonXRef", "PRESS" )

'      Button object name ButtonHistory, Caption Item &History...
'      serr = SetObjectValue( "ButtonHistory", "PRESS" )

'      Button object name ButtonSiteDetail, Caption &Site Detail...
'      serr = SetObjectValue( "ButtonSiteDetail", "PRESS" )

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

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Community Member on at

Like (0)

Report

On my screen I just let these default and don't set them. These are the item defaults tab. The error message "Error In Field: cdfltsiteid Value:" suggests you are trying to set a blank warehouse or an invalid warehouse on your level 1 import at line 24.

Was this reply helpful? Yes No
Erich Strelow F 16 on at

Like (0)

Report
Actually Level1 refers to the "Item Defaults" tab, not the "Site Details".

You should provide a default Warehouse and default bins for the article. For some reason, this data is mandatory, but it's used only as default in the inventory screens.

If GHCWHS is your warehouse code, and let's say you have a "00 initial bin for all articles" created, then you should include the following line for each new item:

Level1,GHCWHS,00,00,,

If you do need to populate the Site Details screen, you must create a second TI file for the 01255 screen.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for your response Rob.... So, how should the new macro look like excluding Level1 ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for your response Erich. I will try what you recommended for the Site Details

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

You don't need to modify the control file. If your inventory screen already takes default site and bins then just leave the Level1 lines out of your data file.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

'Below is the new error after i took level1 out

System Message 8042: Transaction Import Processing Combine Edit and Update mode

'System Message 8040: Database Name TESTLAN

'System Message 8031: The object names in the simple control file are not sorted correctly.

'System Message 8031: The object names in the simple control file are not sorted correctly.

'System Message 8031: The object names in the simple control file are not sorted correctly.

'System Message 8001: Completed Processing 16:40:07

Level0,BB100001,4 HOLE DOCK BUMPER,BUMPER,F,P,F,NN,EXEMPT,AC,1,N,EA,EA,EA,4.95,1300,000000,5200,000000,4200,000000,000000,000000
Level0,BB100002,2 HOLE DOCK BUMPER ,BUMPER,F,P,F,NN,EXEMPT,AC,1,N,EA,EA,EA,3.58,1300,000000,5200,000000,4200,000000,000000,000000
Level0,FL100005,T-FLOOR STABILIZER END CAP PROTECTOR,FLOOR,F,P,F,NN,EXEMPT,AC,1,N,EA,EA,EA,15,1300,000000,5200,000000,4200,000000,000000,000000
Level0,DO100066,St Hinge, Maersk MCIQ type, br insert bushing 1 2 pin,DOOR,F,P,F,NN,EXEMPT,AC,1,N,EA,EA,EA,20.39,1300,000000,5200,000000,4200,000000,000000,000000
Level0,DE100001,2 LETTER NUMBER VINYL DECAl,DECALS,F,P,F,NN,EXEMPT,AC,1,N,EA,EA,EA,0.23,1300,000000,5200,000000,4200,000000,000000,000000
Level0,BB100012,MUD FLAP RETAINING STRAP SLOTTED,BUMPER,F,P,F,NN,EXEMPT,AC,1,N,EA,EA,EA,2.95,1300,000000,5200,000000,4200,000000,000000,000000

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

'System Message 8042: Transaction Import Processing Combine Edit and Update mode

'System Message 8040: Database Name TESTLAN

'System Message 8031: The object names in the simple control file are not sorted correctly.

'System Message 8031: The object names in the simple control file are not sorted correctly.

'System Message 8031: The object names in the simple control file are not sorted correctly.

'System Message 8001: Completed Processing 16:40:07

Level0,BB100001,4 HOLE DOCK BUMPER,BUMPER,F,P,F,NN,EXEMPT,AC,1,N,EA,EA,EA,4.95,1300,000000,5200,000000,4200,000000,000000,000000

Level0,BB100002,2 HOLE DOCK BUMPER ,BUMPER,F,P,F,NN,EXEMPT,AC,1,N,EA,EA,EA,3.58,1300,000000,5200,000000,4200,000000,000000,000000

Level0,FL100005,T-FLOOR STABILIZER END CAP PROTECTOR,FLOOR,F,P,F,NN,EXEMPT,AC,1,N,EA,EA,EA,15,1300,000000,5200,000000,4200,000000,000000,000000

Level0,DO100066,St Hinge, Maersk MCIQ type, br insert bushing 1 2 pin,DOOR,F,P,F,NN,EXEMPT,AC,1,N,EA,EA,EA,20.39,1300,000000,5200,000000,4200,000000,000000,000000

Level0,DE100001,2 LETTER NUMBER VINYL DECAl,DECALS,F,P,F,NN,EXEMPT,AC,1,N,EA,EA,EA,0.23,1300,000000,5200,000000,4200,000000,000000,000000

Level0,BB100012,MUD FLAP RETAINING STRAP SLOTTED,BUMPER,F,P,F,NN,EXEMPT,AC,1,N,EA,EA,EA,2.95,1300,000000,5200,000000,4200,000000,000000,000000

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The previously posted CTL file was an intelligent control file and the data list is for an intelligent control file but the error message "'System Message 8031: The object names in the simple control file are not sorted correctly." suggests that you are using a simple control file. Try it with the CTL file you had previously posted.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Eben, first thing you need to do is figure out what is required. On my system I can enter just an invtid and hit save, everything defaults. Everyone's system can be customized and maybe you have more requirement or need to set the default site bin and location then you will need level1.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We import into this screen frequently and the site details are included

Control macro has Level0 and Level1. The Level1 is treated as a change to an existing record of the Level0 line.

Our data file is similar to this:

Level0,invit,.....

"Level1,change",invtid,site details,....

Was this reply helpful? Yes No

Community site session details

Transaction import - error importing Inventory Item using CTL

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Featured topics

Product updates

Community site session details

Transaction import - error importing Inventory Item using CTL

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Featured topics

Product updates