Questions [Solved] Cannot link SOLine to InventoryItem using left join where SOLine.InventoryID and InventoryItem.InventoryCD

Acumatica Report Designer

Last Post by Jerwin Alimuin 8 years ago

4 Posts

3 Users

4 Reactions

2,542 Views

RSS

Posts: 17

Jerwin Alimuin

Topic starter

March 20, 2018 7:26 am

(@jalimuin)

Member

Joined: 8 years ago

Hi have created a custom form in sales order because i want to include the class of every item in the report detail so I tried to link the SOLine.InventoryID to InventoryItem.InventoryCD using left join relationship but it returns an error caused by conversion of InventoryCD to Integer.

3 Replies

Posts: 149

MichaelHansen

March 20, 2018 11:45 am

(@michaelhansen)

Estimable Member

Joined: 6 years ago

Use InventoryItem.InventoryID, which is an integer value for your items.

Posts: 3193

Tim Rodman

Admin

March 20, 2018 9:35 pm

(@timrodman)

Famed Member

Joined: 10 years ago

I agree with Michael 👍

Posts: 17

Jerwin Alimuin

Topic starter

March 20, 2018 10:08 pm

(@jalimuin)

Member

Joined: 8 years ago

Now it works fine. Thanks.

12 Forums
2,526 Topics
10.9 K Posts
19 Online
2,389 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Questions [Solved] Cannot link SOLine to InventoryItem using left join where SOLine.InventoryID and InventoryItem.InventoryCD

Online Members