web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

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

I have the same question (0)
  • Mark E Profile Picture
    6,451 on at

    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.

  • Community Member Profile Picture
    on at

    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

  • Community Member Profile Picture
    on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans