Skip to main content
Solved

Import scenario to retrieve unique records based on Order Nbr. field


I need to import the unique sales Order records from Database table to Prepare Invoices.

How to use “SOURCE RESTRICTION” in this case.?

Best answer by vkumar

Hi @sysuser113 

Can you elaborate the requirement. The source file does not have any unique identification number for each Sales order? If orders are already been imported, then one can use Process Orders > Prepare Invoice option to prepare invoices. It does list unique orders. Could not determine your exact require and need to use import scenario. 

Regards,

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

2 replies

Forum|alt.badge.img+11
  • Acumatica Support Team
  • 785 replies
  • Answer
  • January 17, 2022

Hi @sysuser113 

Can you elaborate the requirement. The source file does not have any unique identification number for each Sales order? If orders are already been imported, then one can use Process Orders > Prepare Invoice option to prepare invoices. It does list unique orders. Could not determine your exact require and need to use import scenario. 

Regards,


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • January 21, 2022

Hi @sysuser113 did response from @vkumar help you resolve? Thanks!


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