AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
Problem when i have...
 
Notifications
Clear all

Questions Problem when i have more then one Alternate ID

 
Acumatica Report Designer
Last Post by Fosse 5 years ago
4 Posts
3 Users
1 Reactions
1,396 Views
RSS
Fosse
Posts: 16
 Fosse
Topic starter
January 15, 2021 10:07 am
(@fosse)
Eminent Member
Joined: 5 years ago

Hi,ย 

I have Stock Items that includes more than one Alternate ID.ย 

2021 01 15 15 03 12 Stock Items

ย I want to point out on a Shipment Confirmation wich of these Alternate ID's i want to show. In the report designer i can't seem to find the Initem Xref-field. Only SO.Line or SoShipline

2021 01 15 15 07 51 Visma BI   Report Designer

ย Does anyone have any idea?

ย 

Thanks!


3 Replies
lesliealt0502
Posts: 1
 lesliealt0502
January 18, 2021 5:37 pm
(@lesliealt0502)
New Member
Joined: 6 years ago

The xref is actually its own report table. You'll need to update your schema accordingly.

image

Reply
Carl Brooks
Posts: 121
 Carl Brooks
January 18, 2021 6:42 pm
(@kingcarlos)
Estimable Member
Joined: 6 years ago

This article I wrote explains how to work with barcodes but it explains where the alternate ID's are stored and the linking required.

http://myobexo.custhelp.com/app/answers/detail/a_id/38236/kw/alternate/session/L3RpbWUvMTYxMTAwOTYzMS9zaWQvbmZRb2ZwMXA%3D

Hope it helps, all the best,

Carl


Reply
Fosse
Posts: 16
 Fosse
Topic starter
January 19, 2021 8:13 am
(@fosse)
Eminent Member
Joined: 5 years ago

Thanks for the answers!ย 

Unfortunately I don't think I can get acess to the Schema Builder. I work as a consultant and don't have acess to do so much changes in the ERP.

By googling I can see that schema builder is in the Report Designer. The problem is that the report designer I have doesn't look the same ๐Ÿ™ย 

I do have managed to make a workaround for this.ย 


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,532 Topics
  • 11 K Posts
  • 45 Online
  • 2,418 Members
Our newest member: Chad Treadwell
Latest Post: Limited or no support from Acumatica?
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright ยฉ 2026 ยท AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

โ€นโ€บร—

    โ€นโ€บร—