Skip to main content

In the SOShipLine table, there is a field used on the Shipments screen called OrigOrderQty.

 

 

I want to use that field on a pick-list report that can be printed for each shipment.  When I try to add this field, it’s not available.  The SOShipLine DAC shows the field as being available, but it’s not found on the table in REPORT DESIGNER.  Why is that?

 

 

@steveruss  Please find the below steps to reload the fields

  1. Open the Report Designer
  2. Click on File → Build Schema
  3. And enter the Logins and click on the Refresh All to reload the fields.

 

Hi @steveruss ,

As above mentioned by @Naveen Boga , I have followed that steps and simply do the

  • Refresh All → Apply → Ok .
  • Refresh the report.
  • In the expression editor. under SOShipLine table, OrigOrderQty field getting displayed as below screenshot.

 

Regards,

Sweta

Hi @steveruss , maybe you can try to reload the table by click refactor because from my report, this field still show as normal

 

Thanks.  I attempted the Refresh All yesterday and I wasn’t getting the missing data field.  Today, after opening the Report Builder, I entered my login credentials and then selected Refresh and the missing fields appeared!

I got this to work.  For some reason the schema was not reloading. I added another “dummy” attribute in the system, added it to a item class and then refreshed the Schema and magically all of my attributes showed up in the report designer.  I have since deleted the “Dummy” attribute and everything appears to be fine.

Hi @steveruss , maybe you can try to reload the table by click refactor because from my report, this field still show as normal

 

Hi @steveruss t was the refresh all that was need. 

Please try and let me know.

Thanks

 Hello,

I am having difficulties with the report designer finding attributes I created for stock items.   I have successfully completed the below steps of Building The Schema and then Refresh All to load the records but the Attributes do not show up.     I actually completed the same process in our Test Tennant last week with no issues,  but today I am trying to implement in our production tennant and it is not working.  Is there something else I should be looking at?

 

 

@steveruss  Please find the below steps to reload the fields

  1. Open the Report Designer
  2. Click on File → Build Schema
  3. And enter the Logins and click on the Refresh All to reload the fields.

 

 

 

 

Reply


Terms & ConditionsCookie settings
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