Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
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

  • soma Profile Picture
    soma 24,410 on at
    RE: Price list integration

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

  • Romryan Profile Picture
    Romryan on at
    RE: Price list integration

    Soma,

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

  • Verified answer
    soma Profile Picture
    soma 24,410 on at
    RE: Price list integration

    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.

  • Verified answer
    Romryan Profile Picture
    Romryan on at
    RE: Price list integration

    Thanks so much Soma for your time and contribution.

    RomRyan

  • Verified answer
    soma Profile Picture
    soma 24,410 on at
    RE: Price list integration

    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
    RE: Price list integration

    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
    RE: Price list integration

    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!!!

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

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans