Skip to main content
Solved

Export Scenario - Export same row twice (Conditionnal)

  • February 4, 2023
  • 1 reply
  • 350 views
R
Semi-Pro III
Forum|alt.badge.img+1

Hi, 

I'm a beginner and we are in integration phase of Acu in our company.

I created a GI and an Export Scenario for this GI.

I would like for specific line of my GI (EG: Lines IF InventoryID contain 'ABC2'), to export the row twice time(duplicate this GI ROW into my excel export).

I think i should try it with "Service Command" , may be <LineNumber>?

How to do that? Do you have an advice or examples?

 

 

Thank you in advance and sorry for my english!

Best answer by yhartman

Hi,

You can utilize a trick by @wyattERP and @lauraj46 to duplicate rows by using a join to the DateInfo table on you GI. See screenshot below. Changing the DateAdd range will determine how many duplicate rows you will get (I have set to -5 for 5 rows).

 

@TimRodman 

Source:

https://www.augforums.com/forums/acumatica-generic-inquiries/gi-with-2-or-more-different-values/

https://www.augforums.com/forums/acumatica-generic-inquiries/joining-to-dateinfo-table/

 

I hope this helps!

View original
Raphael
Did this topic help you find an answer to your question?

1 reply

Y
Jr Varsity I
Forum|alt.badge.img+3
  • yhartman
  • Jr Varsity I
  • 61 replies
  • Answer
  • February 12, 2023

Hi,

You can utilize a trick by @wyattERP and @lauraj46 to duplicate rows by using a join to the DateInfo table on you GI. See screenshot below. Changing the DateAdd range will determine how many duplicate rows you will get (I have set to -5 for 5 rows).

 

@TimRodman 

Source:

https://www.augforums.com/forums/acumatica-generic-inquiries/gi-with-2-or-more-different-values/

https://www.augforums.com/forums/acumatica-generic-inquiries/joining-to-dateinfo-table/

 

I hope this helps!

Yisroel Hartman • https://www.linkedin.com/in/yisroelhartman/
lauraj46
aaghaei
Chris Hackett
3 people like this
  • lauraj46
    lauraj46
  • aaghaei
    aaghaei
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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