[MichaelPrimeTime]

Is it possible to do an import without an internal id? Can I use the Item Name/Number?

The problem I am having is that I want to run a report (Sales Orders by Item) and then import updates based on the results. When I run this report, the internal id is not associated with each item, so I have no way to do my CSV import. Any suggestions?
This is a cached copy. Click here to see the original post.

[The Wizard of Oz]

RE: Import without Internal ID?

I agree it is stupid.

I created a custom field in item records called "Internal ID for reports" so that I can export the internal ID from report results.

I run a saved mass update with the following before I run any report where I need the internal id field to be exported. The initial run takes a few minutes, but it gets quicker each time after is it only updates any new items since the last update.

Criteria:

Formula (Numeric) {internalid} – nvl({custitem12},'0') is not 0

Mass update fields:

Internal ID for reports = {internalid}

[MichaelPrimeTime]

RE: Import without Internal ID?

Originally posted by The Wizard of Oz

View Post

I created a custom field in item records called "Internal ID for reports" so that I can export the internal ID from report results.

Sweet, thanks for the help Wiz. Greatly appreciated! This was one of those, "why didn't I think of that?" moments.

[The Wizard of Oz]

RE: Import without Internal ID?

It's a ridiculous situation that shouldn't require a workaround, but its quicker to find a workaround than contact support… Glad I could help.

[Author]

Posts