Skip to main content
Answer

relationship between APTran and ARTran tables

  • June 29, 2021
  • 2 replies
  • 143 views
R
Freshman II

I need to create a Parent - Child relationship between APTran and ARTran tables. The artran.OrigInvoiceLineNbr field has no value (value is NULL) on the existing data. Can I populate this field with the APtran.LineNbr value for reference in the ArTran table?

Best answer by Gabriel Michaud

It is always safer to use your own fields -- this way you do not risk interfering with standard system behaviour or getting impacted if the field is removed or renamed in the future.

2 replies

Gabriel Michaud
Captain II
Forum|alt.badge.img+11

It is always safer to use your own fields -- this way you do not risk interfering with standard system behaviour or getting impacted if the field is removed or renamed in the future.

Gabriel Michaud Founder @ Velixo, Excel-based reporting for Acumatica
Chris Hackett
R
Freshman II
  • retha50
  • Author
  • Freshman II
  • July 3, 2021

Thank you for the prompt response and valuable feedback.

Terms & ConditionsCookie settingsAccessibility statement
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