Skip to main content
Answer

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

  • January 14, 2022
  • 2 replies
  • 67 views
S
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,

    2 replies

    V
    Acumatica Employee
    Forum|alt.badge.img+12
    • vkumar
    • Acumatica Support Team
    • 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,

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

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

    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 & ConditionsCookie settingsAccessibility 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