Skip to main content
Solved

Missing rows from Generic Inquiry based on line items from Invoice


bigred1022
Jr Varsity II
Forum|alt.badge.img

Hello everyone,

Hoping to get some clarification on the configuration of a GI (file attached), that will allow me to show each line item of an invoice and not group them together.  Also attaching screenshots to show.  Everything on the line items in the Invoice matches exactly for the Item in question.  Customer bought 2 of the same thing twice instead of just buying 4 for whatever reason.  I’m just hoping to get this GI to be able to show that, when this occurs.

Invoice:

 

GI Result:

 

Best answer by aiwan

HI @bigred1022 

 

Have you got any sort of grouping on the GI? This could be causing the issue.

the UnitPrice/Cost would be the cause of the issue.

It sees the same Ref Nbr, Same Unit Cost, Same Unit Price and assumes you want to group it.

 

Please unmark those groupings and have another look, alternatively if you are getting duplication, you should investigate as to why, or to negate the effect, group by Key Fields e.g., DocType, RefNbr & LineNbr for ARTran.

 

Hope this helps.

Aleks

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

Naveen Boga
Captain II
Forum|alt.badge.img+19

@bigred1022 Can you please export your GI and share it here.


bigred1022
Jr Varsity II
Forum|alt.badge.img
  • Jr Varsity II
  • July 12, 2024

I’m sorry, I thought it saved.  Here it is.  


Naveen Boga
Captain II
Forum|alt.badge.img+19

@bigred1022  I’m not able to import this GI and getting below error.

Which version you are working on ?

 

 


bigred1022
Jr Varsity II
Forum|alt.badge.img
  • Jr Varsity II
  • July 12, 2024

@Naveen Boga 

 

Acumatica Cloud ERP 2023 R2
Build 23.208.0026 +


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • August 19, 2024

Hi @bigred1022 were you able to find a solution? Thank you!


bigred1022
Jr Varsity II
Forum|alt.badge.img
  • Jr Varsity II
  • August 20, 2024

Hi @Chris Hackett, unfortunately not yet.


Forum|alt.badge.img+8
  • Captain II
  • August 30, 2024

HI @bigred1022 

 

Have you got any sort of grouping on the GI? This could be causing the issue.

the UnitPrice/Cost would be the cause of the issue.

It sees the same Ref Nbr, Same Unit Cost, Same Unit Price and assumes you want to group it.

 

Please unmark those groupings and have another look, alternatively if you are getting duplication, you should investigate as to why, or to negate the effect, group by Key Fields e.g., DocType, RefNbr & LineNbr for ARTran.

 

Hope this helps.

Aleks


Reply


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