Question

Adding Shipped Qty to ARInvoice

  • 11 June 2024
  • 6 replies
  • 48 views

Hello, 

Working on report designer SO643000.rpx

I have been looking through a few solutions on the discussion boards about adding the Shipped Qty as well as the Open Order Qty onto the Invoice without duplicating lines or having the whole report error out. None of these solutions have worked for me so far. 

I have tried the following connections:

ARTran-SOOrder  & ARTran-SOLine 

\\\\

SOOrder-SOLine 

\\\\

ARInvoice-SOOrderShipment & SOOrderShipment-SOOrderLine

 

None of these three solutions has worked out. I either get duplicated values or the whole report errors out. Does anyone have more suggestions?

 

Thanks,

Megan


6 replies

Userlevel 6
Badge +3

Hi @mcanavan 

Please refer to the screenshots below.

 

 

 

Best Regards,

NNT

Thank you. This worked. 

 

An additional question: do you know what logic to use to specify which, of multiple, global cross references to pull onto the report? Currently, our stock items have 2 Global cross reference numbers that have different descriptions. I have tried using iif( logic to pull based on the description value with no luck. 


Thank you,

Megan 

Userlevel 6
Badge +3

Hi @mcanavan 

Please attach the .rpx report file you want to edit and describe your requirements in more detail with screenshots so I can clearly understand and help you.

 

Best Regards,

NNT

My Stock product has two Global references. An ASIN and ISBN

I want to include the ISBN on my reports

 

I have tried the iif logic to pull the Global reference with the Description ‘ISBN’ with no luck. 

I have also tried to change the ISBN number from Global to GTIN/EAN/UPC/ISBN and use the logic of iff([INItemXRef.AlternateType]=GTIN/EAN/UPC/ISBN, [INItemXRef.AlternateID], ‘ ‘ ,) with no luck

I am working with the out of the box SO643000.rpx

 

Userlevel 6
Badge +3

Hi @mcanavan 

Please refer to the screenshots below.

 

 

 

Report Designer > Click “detailSection1” > “VisibleExpr” = [INItemXRef.AlternateID] = 456 OR [INItemXRef.AlternateID] = NULL

 

 

 

Best Regards,

NNT

Hello, 

Thank you for this. However, the ISBN is a unique identifier for each product so the value cannot be written in like that. 

Would it help solve the problem if the ISBN was changed from a global cross reference type to GTIN/EAN/UPS/ISBN type? If so, what would be the logical expression to pull the Alternate ID value if the cross reference type was equal to GTIN/EAN/UPS/ISBN?

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