Skip to main content
Answer

All transactions with reason codes

  • October 9, 2024
  • 2 replies
  • 85 views

maheshc73
Freshman II

can we generate a GI that includes all transactions with reason codes? We need to see all inventory adjustments and their associated reason codes, as well as write-offs and the reason codes used for them. Thank you!

Best answer by nhatnghetinh

Hi @maheshc73 

You need to create a new DAC to aggregate the ReasonCode into 1 table by creating a SQL view and combining it with Customization.

A simple way that can be used immediately is to create 2 GIs by using INTran and ARTran on each different GI.

 

 

 

Best Regards,

NNT

2 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • Answer
  • October 9, 2024

Hi @maheshc73 

You need to create a new DAC to aggregate the ReasonCode into 1 table by creating a SQL view and combining it with Customization.

A simple way that can be used immediately is to create 2 GIs by using INTran and ARTran on each different GI.

 

 

 

Best Regards,

NNT


maheshc73
Freshman II
  • Author
  • Freshman II
  • October 9, 2024

Hi @nhatnghetinh 

Thanks this was helpful.

Best Regards,

Mahesh C