Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

Transaction Import for 40.380 (Sales Price) - Problem performing a "Change" operation

(0) ShareShare
ReportReport
Posted on by

Greetings.

I have been able to import new Sales Price records, using Intelligent Form Control and this data file  -

Selection,IC,07700100000,02MBA,,,,,,IC,
SlsPrc,CS20151021,S,F,GLOBAL,0,0
SlsPrcDet,EACH,,,,19.95,,11/1/2015,,,

Having created the record, I cannot figure out how to update the price, for example.

I have tried endless variations, but none are too distant from merely using the same data file, but with these changes -

"Selection,Change",IC,07700100000,02MBA,,,,,,IC,
"SlsPrc,Change",CS20151021,S,F,GLOBAL,0,0
"SlsPrcDet,Change",EACH,,,,21.95,,11/1/2015,,,

I am using the machine-generated Intelligent Control File - except I have enhanced it with the Refresh Button Press as apparently required. For both insert and update, I'm using the same Control file.

Thank you!

CSeelig

Error log -

'System Message 8000: Start Processing 14:36:40

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

'System Message 8040: Database Name TESTOMNI             

'System Message 8011: ========Begin Processing of a Selection,Change Data Line========
'"Selection,Change",IC,07700100000,02MBA,,,,,,IC,
'System Message 8006: Change Existing Records

'System Message 8002: Error In Field: citemclassid Value:

'System Message 8004: Data File Record/Line Number: 1 Column: 40
'"Selection,Change",IC,07700100000,02MBA,,,,,,IC,

'System Message 8002: Error In Field: ccustclassid Value:

'System Message 8004: Data File Record/Line Number: 1 Column: 41
'"Selection,Change",IC,07700100000,02MBA,,,,,,IC,

'System Message 8029: Screen has been refreshed.

'System Message 8055: ========Error Processing Selection,Change Data Line========
"SlsPrc,Change",CS20151021,S,F,GLOBAL,0,0
"SlsPrcDet,Change",EACH,,,,21.95,,11/1/2015,,,
"Selection,Change",IC,07700100000,02MBA,,,,,,IC,

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

'System Message 8001: Completed Processing 14:37:14


*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: Transaction Import for 40.380 (Sales Price) - Problem performing a "Change" operation

    Hi Mark,

    I am also experiencing the same issues with the TI. You mentioned you created an SDK for this, would you mind sharing what you created as I have several clients needing to do the same thing.

  • Community Member Profile Picture
    on at
    RE: Transaction Import for 40.380 (Sales Price) - Problem performing a "Change" operation

    Well, it does help - in that it weights on the decision to stop beating head against the wall and move on to Plan B. In my case, Plan B is direct updates against the tables (shudder!).

    Thank you for taking the time to comment.

    cs

  • Mark E Profile Picture
    6,445 on at
    RE: Transaction Import for 40.380 (Sales Price) - Problem performing a "Change" operation

    Not that this comment will help, but I have had the same experiences where attempting to update existing prices in that screen does not work with TI, but importing new prices was successful.

    I wound up writing a custom SDK screen to allow clients to import both new and updated prices.  I believe the TI problem is related to having multiple grid objects in the screen.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March 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... 294,069 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,858 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans