Skip to main content
Solved

Inventory receipts (IN301000) upload issue


Sagar Greytrix
Captain II
Forum|alt.badge.img+3

Hello Experts,

I have encountered a scenario where I need to export stock items from one tenant to another. To achieve this, I have successfully created export and import scenarios for stock items, and they work well. However, I now have an additional requirement to add a fixed quantity to each exported stock item.

To address this requirement, I created a new import scenario to add quantities to the exported stock items. However, when I attempted to upload a file containing 200+ records, the process took an excessive amount of time and ultimately resulted in an error.

I also tried using the upload file feature (Excel file) on the Receipts (IN301000) screen, but I encountered the same issue of extended processing time and failure to proceed. I have attached the file which I am using for uploading quantity.

If anyone has insights or ideas on how to overcome this issue and improve the efficiency of the import process, I would greatly appreciate your assistance.

Thank you in advance!

Best regards,

Sagar 

Best answer by akatzkomori

@Chris Hackett I just ran into this issue, trying to import 11,000 lines into an inventory receipt via Excel in the receipt object. It took forever to process and then wouldn’t save or Release. Vague error message, but saw in the Trace that the “file size was exceeded.” Another forum post suggested to check License Monitoring Console to see how many lines per transaction are allowed in our license. For me, it says 2,500 so guessing I’m either going to have to break this into five separate loads or start looking into finding an import scenario that can do the same thing. I’m a new end-user, could ask my implementation partner to build one, but trying to do this over the weekend and am also cheap :-)

 

View original
Did this topic help you find an answer to your question?

4 replies

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

Hi @sagar07 

I am able to upload the sheet provided, could you please upload with out customization package and verify,

 


Sagar Greytrix
Captain II
Forum|alt.badge.img+3

Hi @manikantad18 ,

Thank you for the reply.

Yes, I am also able to upload the file but after this I could not be able to save or perform any action, screen stopping to respond.

Are there any limitations on receipts screen to upload the file?

I want to add quantities to each stock item. So, is there another workaround anyone have?

Regards,

Sagar


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2757 replies
  • December 13, 2023

Hi @sagar07 were you able to find a solution? Thank you!


  • Freshman II
  • 10 replies
  • Answer
  • December 8, 2024

@Chris Hackett I just ran into this issue, trying to import 11,000 lines into an inventory receipt via Excel in the receipt object. It took forever to process and then wouldn’t save or Release. Vague error message, but saw in the Trace that the “file size was exceeded.” Another forum post suggested to check License Monitoring Console to see how many lines per transaction are allowed in our license. For me, it says 2,500 so guessing I’m either going to have to break this into five separate loads or start looking into finding an import scenario that can do the same thing. I’m a new end-user, could ask my implementation partner to build one, but trying to do this over the weekend and am also cheap :-)

 


Reply


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