Sage 300 - Import items to populate quote

SOLVED

I want to import items into an O/E quotation. 

I have attempted to export an existing "QTxxxxx" to use as a template, but I get an error message "Can't Append Table. Error: Too many fields defined." even when I limit the requested fields to those in "Orders" and "Order_Details" (deselecting everything related to serial numbers, lot numbers, payments, comments, optional fields).

Background:
Quotes at my company can be iterative, with lots of line items to form a complicated system with inter-related components where one change will often cascade into multiple changes. So, it would be much easier if we could prepare quotes in Excel and import them.

Can you provide a template, suggest tips for the export-as-template approach, or provide an alternative method for importing?

Thank you for your attention and help in advance!

Parents Reply
  • 0 in reply to wheumann

    Thank you again wheumann. I seem to be inching closer to the goal...

    The latest error message reads: Description: Please mark all required fields. Source: 14:08:06 - 1041.0.503.198

    There is no apparent means of marking fields. The only option I can find is by right-clicking on tables listed in the Table column of the import window and that doesn't seem to be a useful option.

    Any suggestions are very welcome.

Children