Skip to main content
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.

  • July 19, 2023
  • 6 replies
  • 1045 views

Forum|alt.badge.img

Please check and Fix my AP Bills Import scenario.

 

 

6 replies

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

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


Forum|alt.badge.img
  • Author
  • Freshman I
  • July 19, 2023

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.


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

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 

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • July 20, 2023

Hi @manikantad18 

 

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


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • August 9, 2023

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


Forum|alt.badge.img
  • Author
  • Freshman I
  • August 9, 2023

Hi @Chris Hackett , unfortunately not yet.