Skip to main content
Solved

Get Alternate ID of the parent customer

  • May 15, 2026
  • 1 reply
  • 24 views
M
Varsity I
Forum|alt.badge.img

Hi, I have a customized report (attached) and added the stock item’s Alternate ID of the parent customer. The column I’ve added this into the report is called ‘Customer Code’. However, quantities are multiplied.

Can you please help me correct my joins or if joins are correct, the conditional statement is wrong.

I ran this report for Account C013554. Product code is 4005 and customer code is 1909830
C000916 is the parent customer of C013554
As you know, C00916 is the parent customer of C013554. I want to pull the Alternate ID of this parent customer

 

Best answer by bwhite49

Hi Mark,

Something like this should work. You don’t need to do the ISNULL join. It could just be ParentBaccountID = BAccountID

 

1 reply

bwhite49
Captain II
Forum|alt.badge.img+12
  • bwhite49
  • Captain II
  • Answer
  • May 15, 2026

Hi Mark,

Something like this should work. You don’t need to do the ISNULL join. It could just be ParentBaccountID = BAccountID

 

    Terms & ConditionsAccessibility 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