Skip to main content
Solved

Insertion 'AR transaction' record raised at least one error. please review the errors. One or more lines have unassigned location and/or lot/serial number unit price has been set to zero because no effective unit price was found

  • Jun 26, 2024 8:00 AM UTC
  • 10 replies
  • 458 views
  • Translate All
Jr Varsity III
Forum|alt.badge.img

Hi All,

 

I have this error. What is the problem and how do I rectify it

thx

Dries

Best answer by driesdeklerk50

Acumatica Support created a workaround script

 

View original

    10 replies

    Manikanta Dhulipudi
    Captain II
    Forum|alt.badge.img+16

    Hi @driesdeklerk50 

    Can you check below suggestions

     

    Translate
    Acumatica Functional Consultant & Customer Experience Supervisor
      Jr Varsity III
      Forum|alt.badge.img
      • driesdeklerk50
      • Author
      • Jr Varsity III
      • Jun 26, 2024 8:20 AM UTC

      thx Manikanta Dhulipudi

       

      This is on a service order. The inventory item is a non stock item

      Translate
      Jr Varsity II
      Forum|alt.badge.img
      • steph23
      • Jr Varsity II
      • Jun 26, 2024 10:11 AM UTC

      Can’t see it in your screenshot but do you have a location entered for that detail line?

      Translate
      Jr Varsity III
      Forum|alt.badge.img
      • driesdeklerk50
      • Author
      • Jr Varsity III
      • Jun 26, 2024 10:22 AM UTC

      Hi Steph23,

      see below. Location shows <SPLIT>

       

      Translate
        Jr Varsity II
        Forum|alt.badge.img
        • steph23
        • Jr Varsity II
        • Jun 26, 2024 10:23 AM UTC

        Hi Steph23,

        see below. Location shows <SPLIT>

         

        Can you overwrite the <SPLIT> with a location that is valid for that warehouse?

        Translate
          vdiaz
          Acumatica Moderator
          Forum|alt.badge.img+2
          • vdiaz
          • Acumatica Moderator
          • Jun 28, 2024 7:34 PM UTC

          I agree with @steph23, even if the item is a non-stock item, the Location column needs to have a value.

          Translate
          Valentina
            Jr Varsity III
            Forum|alt.badge.img
            • driesdeklerk50
            • Author
            • Jr Varsity III
            • Jun 29, 2024 5:05 AM UTC

            Thank you...I will change it.

            Translate
            Jr Varsity III
            Forum|alt.badge.img
            • driesdeklerk50
            • Author
            • Jr Varsity III
            • Jun 29, 2024 5:14 AM UTC

            I unclosed the service order and tried to change the location but cannot change the location 

            Translate
            vdiaz
            Acumatica Moderator
            Forum|alt.badge.img+2
            • vdiaz
            • Acumatica Moderator
            • Jul 27, 2024 10:13 PM UTC

            I unclosed the service order and tried to change the location but cannot change the location 

            Were you able to solve this? 

            Translate
            Valentina
              Jr Varsity III
              Forum|alt.badge.img
              • driesdeklerk50
              • Author
              • Jr Varsity III
              • Answer
              • Jul 29, 2024 7:01 AM UTC

              Acumatica Support created a workaround script

               

              Translate
                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