Skip to main content
Answer

ImportScenario for Business Event to add a Prepayment to a sales order yielding error when adding rows

  • August 18, 2025
  • 3 replies
  • 61 views
P
Jr Varsity II
Forum|alt.badge.img

This issue is similar to this question.  I have a business event which is triggered for certain types of orders.  When triggered, one subscriber takes the sales order data and does an import scenario to add a prepayment and assign it to the sales order.  I can get the prepayment created, but when adding the Sales Order to the prepayment I am getting an error “The system failed to commit the SOAdjustments row.” I know I am close on this - just needs a fresh eye and a tweak and I bet it will be there.  Any thoughts?

Thanks!  Patrick

 

 

 

 

 

Best answer by Missy Main

Hey there, 

Have you tried isolating the second import into it’s own business event trigger? 
I presume having two imports on the same business event may be an issue, but this would need to be tested. 

There is a way to test the import outside of the business event, by following instructions here in this video
if it works after following these instructions here, then I presume the issue is with having two imports on the same BE trigger, so do try isolating it in it’s own event. 

instructions to test the second import by itself: 

Minute 46:26 - How to troubleshoot imports related to Business events


 

    3 replies

    M
    Acumatica Employee
    Forum|alt.badge.img+3
    • Missy Main
    • Acumatica Support Team
    • Answer
    • August 18, 2025

    Hey there, 

    Have you tried isolating the second import into it’s own business event trigger? 
    I presume having two imports on the same business event may be an issue, but this would need to be tested. 

    There is a way to test the import outside of the business event, by following instructions here in this video
    if it works after following these instructions here, then I presume the issue is with having two imports on the same BE trigger, so do try isolating it in it’s own event. 

    instructions to test the second import by itself: 

    Minute 46:26 - How to troubleshoot imports related to Business events


     

    Chris Hackett
    H
    Manikanta Dhulipudi
    Captain II
    Forum|alt.badge.img+15

    Hi ​@patrickACA 

    Can you disable the below mapping once and verify this?

     

    Acumatica Functional Consultant & Customer Experience Supervisor
    Chris Hackett
    D
    Captain II
    Forum|alt.badge.img+7
    • Django
    • Captain II
    • August 19, 2025

    Another thing to try is to set the payment on hold while you’re creating it. Being on hold allows the transaction to be in various unbalanced states while it is being created.

    Chris Hackett
    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