Skip to main content
Answer

Sub Account Segments in GI

  • November 2, 2023
  • 3 replies
  • 181 views

When having to select segment 2 of a subaccount , linked to the Employee master, the logical step would be to add the default location ( For vendor) and then link that to GL.Sub. Even when using substring/ left/ right , the result is blank. 

Fortunately , there are a DAC that already has this info: Employee (EPEmployee)

And I am sure the DAC’s exist for other business accounts where this is required

Best answer by eddie stoffberg

On the PX.Objects.PM.PMProject DAC, I am trying to isolate the Value ( not Description) of the SubAccount Segment 4 : =[PMProject.DefaultAccrualSubID_Segment4] 
This renders an error  

The multi-part identifier "Contract.DefaultAccrualSubID" could not be bound

I did Manage to resolve this by joining other DACs, referencing the SubAccount (GL.Sub), and Segment Values
This post can be closed thanks
 

3 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • November 2, 2023

Hello @eddie stoffberg ,

What is your question, please?  A screen shot will help us understand and answer you.  Can you show us what you have vs. what you need?

Thank you.

Laura


  • Author
  • Freshman II
  • Answer
  • November 2, 2023

On the PX.Objects.PM.PMProject DAC, I am trying to isolate the Value ( not Description) of the SubAccount Segment 4 : =[PMProject.DefaultAccrualSubID_Segment4] 
This renders an error  

The multi-part identifier "Contract.DefaultAccrualSubID" could not be bound

I did Manage to resolve this by joining other DACs, referencing the SubAccount (GL.Sub), and Segment Values
This post can be closed thanks
 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • November 2, 2023

Thank you for sharing your solution with the community @eddie stoffberg!