Skip to main content
Solved

ACU Import AP Bills Import Scenario Only Importing 1 Transaction at a Time

  • January 4, 2024
  • 1 reply
  • 193 views
B
Freshman II

I’m using the default out-of-the-box AP bills import scenario. When I try to import more than 1 record, the first record imports successfully, but the next one fails with this error:

If i import 1 at a time, it works. I have the key fields mapped.

I have attached the import scenario. What change needs to be made to import more than 1 at a time? Thank you in advance for your help!

Best answer by Laura02

Hello,

I think you need to disable the two lines in the Import Scenario that appear in Red Text, related to the Hold Checkbox that no longer exists in AP Bills screen. 

I was able to import your file into my 2022 R2 Sales Demo with the following changes:

  1. I changed the Vendor ID’s in Column G to match Vendor ID’s that exist in the demo tenant.
  2. I changed the Account in Column U to match an Expense Account in demo tenant chart of accounts.
  3. I disabled the two lines with red text in the Import Scenario. The Hold checkbox is deprecated ( no longer exists).

Good luck!

 

Laura

View original
1 Attachments
Laura02
F
M
3 people like this
  • Laura02
    Laura02
  • F
    FrankieDC
  • M
    mlupro
Did this topic help you find an answer to your question?

1 reply

Laura02
Captain II
Forum|alt.badge.img+19
  • Laura02
  • Captain II
  • 3132 replies
  • Answer
  • January 4, 2024

Hello,

I think you need to disable the two lines in the Import Scenario that appear in Red Text, related to the Hold Checkbox that no longer exists in AP Bills screen. 

I was able to import your file into my 2022 R2 Sales Demo with the following changes:

  1. I changed the Vendor ID’s in Column G to match Vendor ID’s that exist in the demo tenant.
  2. I changed the Account in Column U to match an Expense Account in demo tenant chart of accounts.
  3. I disabled the two lines with red text in the Import Scenario. The Hold checkbox is deprecated ( no longer exists).

Good luck!

 

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
Chris Hackett
T
2 people like this
  • Chris Hackett
    Chris Hackett
  • T
    tmccormick49

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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