By using this website, you agree to our Terms of Use (click here)
This client I have has a customer who has multiple locations on the customer - when creating the invoice they select the correct location and the default attention name comes into the invoice then they select override to place a new name in the attention. When they go to print the invoice it is not showing the overridden attention field name - I have checked the form in the report designer the ship to the area of the invoice is stock acumatica no changes have been made they were just upgraded to 2019R2 I am unsure what to check next.
any guidance would be much appreciated
this is fields from the report I see the attention field, i dont see any were where it has a override clause.
=IIf([ShippingContact.FullName]<>null, [ShippingContact.FullName]+'{br}','')
+IIf([ShippingAddress.AddressLine1]<>null,[ShippingAddress.AddressLine1]+'{br}','')
+IIf([ShippingAddress.AddressLine2]<>null,[ShippingAddress.AddressLine2]+'{br}','')
+IIf([ShippingAddress.AddressLine3]<>null,[ShippingAddress.AddressLine3]+'{br}','')
+IIf([ShippingAddress.City]<>null, [ShippingAddress.City]+' ','')
+IIf([ShippingAddress.State]<>null, [ShippingAddress.State]+' ','')
+IIf([ShippingAddress.PostalCode]<>null, [ShippingAddress.PostalCode],'')
+IIf([ShippingAddress.City]<>null OR [ShippingAddress.State]<>null OR [ShippingAddress.PostalCode]<>null,'{br}','')
+IIf([ShippingAddress.CountryID]<>null, [ShippingAddress.CountryID_Country_Description]+'{br}','')
+IIf([ShippingContact.Attention]<>null, 'Attn: ' + [ShippingContact.Attention],'')
Maybe it's a bug in the build that you are using?
I just tried this in Acumatica 2020 R1 (20.100.0095) and it seemed to work.
1. Overrode the ADDRESS DETAILS -> SHIP-TO CONTACT -> Attention field on the Invoices (SO303000) screen:
2. Clicked REPORTS -> Print Invoice and it seemed to work:
The override is handled by the objects in Acumatica. That’s one of the benefits of using them versus SQL.
Check your ShippingContact object on your report. Make sure it points to ARContact. There was a change where shipping used to come from the SO and you may still be pointing to the SO Contact.
@richard Absolutely. The Schema Builder is where you should start.
Your code is referencing ShippingContact, which is shown as an alias in the schema builder for SOContact. If @ryanxbyte is correct and the table is incorrect, you need to swap SOContact for ARContact. Of course you'll need to jump down to your relations below too and set whatever links are necessary to bring in the ARContact module instead of the SOContact module.
I HIGHLY SUGGEST you save a copy or a revision before trying to swap tables in and out, it can get dirty really fast (speaking from my own poor decisions).
@michaelhansen thank you. I ended up just using the new report and making the changes from the old report. It was easier that way.
@richard Fair enough my friend, it's almost like our employers want it now or something right? I find it hard to troubleshoot sometimes because of the short deadlines I am given.