Item cross reference - Purchase Price (Excel)

(0) Share

Report

Posted on by Community Member

Hello everyone,

I've come across a question when I was adding items to the cross reference list from the vendors. Given that I have tons of items, is it possible to add the purchase price to each item also through excel? Or somehow import the excel file into dynamics?

Thank you

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

RE: Item cross reference - Purchase Price (Excel)

Hi

As far as I know

Item Cross Reference and Purchase Price are separate tables. But you can work with them through Configuration Package.

Search for Configuration Package. Then click New and create a new code

You need to select Table 7102 for purchase price and 5717 for Cross Reference. Then you can select both and use Excel and Export to Excel. Then add the data and upload back. Do not select "Delete Table Records Before Processing"

See this: stoneridgesoftware.com/.../

Was this reply helpful? Yes No