Skip to main content
Answer

Create a GI to show Freight Costs linked to a Sales Order

  • January 14, 2025
  • 3 replies
  • 71 views

Forum|alt.badge.img

I cloned and modified the Purchases GI. I need to modify this GI to pull only non-stock freight items that equal freight, the costs for that PO line and the Sales Order number linked to that PO Line. I attempted it but not having luck. Here is my GI attached. Any guidance would be appreciated.

 

Thanks,

Frances 

 

Best answer by nhatnghetinh

Hi ​@fpantelidakis07 

Please refer to the CONDITIONS Tab on GI as shown in the screenshot below, you can edit the conditions to suit your requirements.

 

I have added some lines on the RESULTS GRID Tab.

 

 

Best Regards,

NNT

3 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • January 14, 2025

Hi ​@fpantelidakis07 

What are your conditions for "the costs for that PO line and the Sales Order number linked to that PO Line"? I haven't seen this condition on your GI yet.

 

Best Regards,

NNT


nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • Answer
  • January 14, 2025

Hi ​@fpantelidakis07 

Please refer to the CONDITIONS Tab on GI as shown in the screenshot below, you can edit the conditions to suit your requirements.

 

I have added some lines on the RESULTS GRID Tab.

 

 

Best Regards,

NNT


Forum|alt.badge.img

Hi ​@nhatnghetinh,

 

Thank you so much. This will work. Thanks.