Skip to main content
Solved

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

  • Jan 14, 2022 3:38 PM UTC
  • 2 replies
  • 110 views
  • Translate All
Freshman I

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

    2 replies

    Acumatica Employee
    Forum|alt.badge.img+12
    • vkumar
    • Acumatica Support Team
    • Answer
    • Jan 17, 2022 8:03 AM UTC

    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,

    Translate
    VijayKumarU
      Chris Hackett
      Community Manager
      Forum|alt.badge.img
      • Chris Hackett
      • Acumatica Community Manager
      • Jan 21, 2022 5:17 PM UTC

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

      Translate
      Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
      Terms & ConditionsAccessibility statement
      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