Skip to main content
Answer

Business Account Owner invalid due to employee deactivate, cannot query in GI

  • April 26, 2022
  • 3 replies
  • 52 views
variuxDavidE
Varsity I
Forum|alt.badge.img

I found a series of Business Accounts that were assigned to an Owner (employee) Lisa Short. This employee is now deactivated and these accounts throw an error when trying to generate sales orders via an Import Scenario or API call. However, I cannot figure out how to pull a GI of Business accounts associated to this Employee because the values do not pull any filtered results;

 

 

Best answer by ChandraM

Hi @variuxdavid @tsmith19 Here is the generic inquiry to answer the below question.

Please find the attached generic inquiry with the solution to your problem, and the below screenshot showing the results.

“However, I cannot figure out how to pull a GI of Business accounts associated to this Employee because the values do not pull any filtered results;”

 

Thanks

- David Edmonson, Variux.com, Acumatica and Ecommerce Project Management and Turnarounds

    3 replies

    T
    Freshman I
    Forum|alt.badge.img
    • tsmith19
    • Freshman I
    • October 10, 2023

    @variuxdavid Did you have any luck resolving this? I have the same exact request and haven’t been able to figure this out. 

    C
    Semi-Pro I
    Forum|alt.badge.img+8
    • ChandraM
    • Semi-Pro I
    • October 10, 2023

    Hi @variuxdavid and @tsmith19 This is a generic inquiry with the joins of BAccount and the Contacts(Owner) tables.
    Creating the Generic Inquiry. Will keep you posted.

    Chandra M
    T
    C
    Semi-Pro I
    Forum|alt.badge.img+8
    • ChandraM
    • Semi-Pro I
    • Answer
    • October 10, 2023

    Hi @variuxdavid @tsmith19 Here is the generic inquiry to answer the below question.

    Please find the attached generic inquiry with the solution to your problem, and the below screenshot showing the results.

    “However, I cannot figure out how to pull a GI of Business accounts associated to this Employee because the values do not pull any filtered results;”

     

    Thanks

    1 Attachments
    Chandra M
    Chris Hackett
    T
    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