Skip to main content
Solved

Export scenario fetching duplicate data

  • Aug 14, 2024 9:24 AM UTC
  • 1 reply
  • 102 views
  • Translate All
Freshman I

Hi,

I am trying to export the formula which has 2 revisions created.

When I perform prepare action on export by scenario it fetches records multiple time for both the revision.

Is there any solution for not getting duplicate record on export scenario.

See the attached screenshot for more clarification on issue: -

 

Best answer by lauraj46

Hi @Dhruv ,

In the GI that is the source for your data provider, make sure that the joins are correct.  The revision is part of the primary key, so you should include it on all of the joins, for example to AMBomMatl.

Hope this helps!

Laura 

View original

1 reply

lauraj46
Captain II
Forum|alt.badge.img+9
  • lauraj46
  • Captain II
  • Answer
  • Aug 14, 2024 11:27 AM UTC

Hi @Dhruv ,

In the GI that is the source for your data provider, make sure that the joins are correct.  The revision is part of the primary key, so you should include it on all of the joins, for example to AMBomMatl.

Hope this helps!

Laura 

Translate
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    Terms & ConditionsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved