Friday, June 5, 2020

NAV/BC - Copy / Paste Rows in Sales Orders, Purchase Orders, General Ledgers, and other transactions in Web Client


  • Select transaction to copy from
  • Ctrl+A to select all rows
    • If it selects the text on the screen, try selecting a different field so the cursor goes into the actual record, then press Ctrl+A
    • All records will tick
  • Ctrl+C to copy all rows
  • Go to your new transaction or excel
  • Ctrl+V to Paste Rows
    • If you select specific rows, it will try to overwrite your selection with the exact row size
    • However, if you delete all rows, and paste on the first row, it will paste all rows
  • From Excel, you can update the data
  • Select entire Row
  • Ctrl+C
  • Go to Transaction line in Web Client
    • Ensure you are in a regular field (not an option dropdown)
    • Ctrl+V to paste the rows
    • If you select the exact same number of rows in the Web Client, it will attempt to update the existing selected rows in the Web Client

No comments:

Post a Comment