Solved

How to connect RC returns to SO Orders

  • 1 November 2022
  • 5 replies
  • 161 views

Userlevel 5
Badge +1

I am trying to do reporting on the NET revenue per channel (we differentiate channels by order types). I’m using the ARTran table to obtain the SOOrderNbr, SOOrderType, and NetSalesAmount. However, returns (RC order types) are not connected to the original Sales Order other than via the invoice number and show up under their own order type (RC).

Does anyone have any suggestions regarding how to set up a GI that will reflect the negative amount generated by the RC return against the original Sales Order? Or maybe something like:

 

IIf(OrderType=’RC’, OriginalSOOrderNbr, SOOrderNbr)

 

icon

Best answer by Naveen Boga 1 November 2022, 17:42

View original

5 replies

Userlevel 7
Badge +18

Hi @mikeho  You can find the Original Sales Order Nbr from RC order.

  • For the RC order, → SOLine table, we have two OrigOrderNbr and OrigOrderType to find out the Original sales order for the RC order.

 

Userlevel 5
Badge +1

Thank you, @Naveen Boga!

Any suggestions regarding the best way to relate the ARTran table and the SOLine table? I’ve tried this but it produces duplicate results:

 

 

Userlevel 7
Badge +18

@mikeho  We can join the SOLine and ARTran table with the below fields.

 

SOLIine → OrderType, OrderNbr, LineNbr

ARTran → SOOrderType, SOOrderNbr, SOOrderLineNbr

 

Please find the screenshot for reference.

 

Userlevel 5
Badge +1

Thanks, @Naveen Boga! That worked for me.

Userlevel 7
Badge +18

@mikeho  Awesome! Thanks for sharing the update.

Reply


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