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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Price list integration
Microsoft Dynamics GP (Archived)

Price list integration

(0) ShareShare
ReportReport
Posted on by Romryan

Hi Everyone,

I am trying to integrate the pricelist to an already set item called Test.Below is my file.

ItemNumber, Duom, dpl price, CID
TEST, EACH RETAIL, 99.99, Z-US$

Opening source query...

Establishing source record count...
Beginning integration...
DOC 1 WARNING: Field 'Pricing.Default Price Level' truncated at 10
DOC 1 WARNING: Field 'Pricing.Items.Price Level' truncated at 10
DOC 1 ERROR: Object 'TEST' already exists -- cannot Insert.
Integration Failed
Integration Results
1 documents were read from the source query.
1 documents were attempted:
0 integrated without warnings.
0 integrated with warnings.
1 failed to integrate.

Now my question....where am I going wrong or how can I integrate price list to an already existing item.

Romryan

*This post is locked for comments

I have the same question (0)
  • Verified answer
    soma Profile Picture
    soma 24,410 on at

    The price list for the item TEST is already available. If you want to update the price list for the same item TEST, go integration manager and then right click the price list integration to choose the "Destination Edit Mode" as "Update Only" or "Insert and Update".

    Hope this helps!!!

  • Verified answer
    Romryan Profile Picture
    Romryan on at

    Thanks Soma for your suggestion as it did update the price list and no more errors but if I have an item test that has the different prices lets say 5 units at 40,10 units at 80,do we have the file or interface to pull this.I have seen the default setting are from starting quantity 1 and ending quantity 999999999999.Is it possible to pull a file that have different ranges in between  1 and 999999999999 of quantity prices  of the same item through integration manager.

  • Verified answer
    soma Profile Picture
    soma 24,410 on at

    I think no option available for passing the value for start/end quantity in the Integration Manager.

  • Verified answer
    Romryan Profile Picture
    Romryan on at

    Thanks so much Soma for your time and contribution.

    RomRyan

  • Verified answer
    soma Profile Picture
    soma 24,410 on at

    You are welcome.

    If my suggestion solved your problem, mark this as a verified. Because this will helps to some others who having the same problem.

  • Romryan Profile Picture
    Romryan on at

    Soma,

    where do we indicate an answer is verified....

  • soma Profile Picture
    soma 24,410 on at

    Click  "Yes" (Did this answer the question?) below the solved suggestion.

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

News and Announcements

Season of Giving Solutions is Here!

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans