Question

Error: Inserting 'AP document' record raised at least one error. Please review the errors. 'Terms' cannot be empty. 'Due Date' cannot be empty. 'Cash Discount Date' cannot be empty.

  • 19 July 2023
  • 6 replies
  • 384 views

Please check and Fix my AP Bills Import scenario.

 

 


6 replies

Userlevel 7
Badge +12

Hi @retros 

Based on the vendor selection the Credit terms, cash account will be populated automatically, can you uncheck the mapping and verify once.

Vendor ID mapping should be in the top 

Thanks

Hi @manikantad18 

 

IT WORKED! BUT, I got this new errors. The First Line is successfully processed but the preceding lines i got these errors.

 

 

Error: Inserting 'AP document' record raised at least one error. Please review the errors. Error: The 07-2023 financial period is inactive in the XDE company. Error: 'Vendor' cannot be empty. Error: 'AP Account' cannot be empty. Error: 'AP Subaccount' cannot be empty. Error: 'Location' cannot be empty. Error: 'Supplied-by Vendor' cannot be empty. Error: 'Supplied-by Vendor Location' cannot be empty. 'Terms' cannot be empty. 'Due Date' cannot be empty. 'Cash Discount Date' cannot be empty. 'Vendor Ref.' cannot be empty. Error: 'Pay Separately' cannot be empty. Error: 'Payment Location' cannot be empty. The AP Account (subaccount) and the Reclassification Account (subaccount) boxes should not have the same account-subaccount pairs specified. The AP Account (subaccount) and the Reclassification Account (subaccount) boxes should not have the same account-subaccount pairs specified.

Userlevel 7
Badge +12

Hi @manikantad18 

 

IT WORKED! BUT, I got this new errors. The First Line is successfully processed but the preceding lines i got these errors.

 

 

Error: Inserting 'AP document' record raised at least one error. Please review the errors. Error: The 07-2023 financial period is inactive in the XDE company. Error: 'Vendor' cannot be empty. Error: 'AP Account' cannot be empty. Error: 'AP Subaccount' cannot be empty. Error: 'Location' cannot be empty. Error: 'Supplied-by Vendor' cannot be empty. Error: 'Supplied-by Vendor Location' cannot be empty. 'Terms' cannot be empty. 'Due Date' cannot be empty. 'Cash Discount Date' cannot be empty. 'Vendor Ref.' cannot be empty. Error: 'Pay Separately' cannot be empty. Error: 'Payment Location' cannot be empty. The AP Account (subaccount) and the Reclassification Account (subaccount) boxes should not have the same account-subaccount pairs specified. The AP Account (subaccount) and the Reclassification Account (subaccount) boxes should not have the same account-subaccount pairs specified.

I have attached sample import scenario please review 

 

Hi @manikantad18 

 

I’m still receiving the same error. Can you please check my import scenario?

Userlevel 7
Badge

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

Hi @Chris Hackett , unfortunately not yet.

Reply


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