Yes, you just do it.

Yes it is possible to export OE comments.

I can export Comment at Invoice level, but not line item.   I do not see that field available for export on the script. for Invoice_Details. And the Invoice_Comments_Instructions tab, although I selected all for export, is blank.

I don't know what "script" you're referring to, but comments definitely export.

This is a list of the fields that I can select to export.  There is no box to select to export the line item Comment.

I can only export the Invoice level comment, which is not what I need.

Invoice_Details

Field Name Type

*Invoice Uniquifier Decimal(10,0)

*Line Uniquifier Integer

Line Type Integer

Item String(24)

Miscellaneous Charges Code String(6)

Description String(60)

Item Account Set String(6)

User-Specified Costing Method Boolean

Price List String(6)

Category String(6)

Location String(6)

Picking Sequence String(10)

Shipment Date Date

Stock Item Boolean

Current Quantity Outstanding Decimal(10,4)

Quantity Shipped Decimal(10,4)

Quantity Backordered Decimal(10,4)

Invoice Unit of Measure String(10)

Unit Conversion Decimal(10,6)

Unit Price Decimal(10,6)

Price Override Boolean

Unit Cost Decimal(10,6)

Most Recent Unit Cost Decimal(10,6)

Standard Unit Cost Decimal(10,6)

Alternate Unit Cost 1 Decimal(10,6)

Alternate Unit Cost 2 Decimal(10,6)

Unit Price No. of Decimals Integer

Pricing Unit String(10)

Pricing Unit Price Decimal(10,6)

Pricing Unit Conversion Decimal(10,6)

Price Discount Percentage Decimal(5,5)

Price Discount Amount Decimal(10,3)

Pricing Base Unit String(10)

Pricing Base Unit Price Decimal(10,6)

Pricing Base Unit Conversion Decimal(10,6)

Costing Unit String(10)

Costing Unit Cost Decimal(10,6)

Costing Unit Conversion Decimal(10,6)

+Extended Detail Cost Decimal(10,3)

Extended Shipped Price/Misc. Cha Decimal(10,3)

Invoice Discount Amount Decimal(10,3)

Extended Amount Override Boolean

Unit Weight Decimal(10,4)

Extended Weight Decimal(10,4)

Tax Authority 1 String(12)

Tax Authority 2 String(12)

Tax Authority 3 String(12)

Tax Authority 4 String(12)

Tax Authority 5 String(12)

Tax Class 1 Integer

Tax Class 2 Integer

Tax Class 3 Integer

Tax Class 4 Integer

Tax Class 5 Integer

Tax Included 1 Boolean

Tax Included 2 Boolean

Tax Included 3 Boolean

Tax Included 4 Boolean

Tax Included 5 Boolean

Tax Base 1 Decimal(10,3)

Tax Base 2 Decimal(10,3)

Tax Base 3 Decimal(10,3)

Tax Base 4 Decimal(10,3)

Tax Base 5 Decimal(10,3)

Tax Amount 1 Decimal(10,3)

Tax Amount 2 Decimal(10,3)

Tax Amount 3 Decimal(10,3)

Tax Amount 4 Decimal(10,3)

Tax Amount 5 Decimal(10,3)

Tax Rate 1 Decimal(8,5)

Tax Rate 2 Decimal(8,5)

Tax Rate 3 Decimal(8,5)

Tax Rate 4 Decimal(8,5)

Tax Rate 5 Decimal(8,5)

Detail Number Integer

Have Comments/Instructions Boolean

Price List Description String(60)

Category Description String(60)

Location Description String(60)

+Tax Authority 1 Description String(60)

+Tax Authority 2 Description String(60)

+Tax Authority 3 Description String(60)

+Tax Authority 4 Description String(60)

+Tax Authority 5 Description String(60)

+Tax Class 1 Description String(60)

+Tax Class 2 Description String(60)

+Tax Class 3 Description String(60)

+Tax Class 4 Description String(60)

+Tax Class 5 Description String(60)

Non-stock Clearing Account String(45)

Non-stock Clearing Acct. Desc. String(60)

+Average Unit Cost Decimal(10,6)

+Last Unit Cost Decimal(10,6)

Shipment Number String(22)

Shipment Detail Line Number Integer

+Total Most Recent Cost Decimal(10,3)

+Total Standard Cost Decimal(10,3)

+Total Alternate Cost 1 Decimal(10,3)

+Total Alternate Cost 2 Decimal(10,3)

+Total Average Cost Decimal(10,3)

+Total Last Cost Decimal(10,3)

Shipment Tracking Number String(36)

Ship-Via Code String(6)

Ship-Via Code Description String(60)

Discount Percent Decimal(5,5)

+Extended Discounted Price Decimal(10,3)

+Order Quantity Ordered Decimal(10,4)

+Order Quantity Backordered Decimal(10,4)

+Order Quantity Committed Decimal(10,4)

+Order Quantity True Committed Decimal(10,4)

+Order Quantity Shipped-to-date Decimal(10,4)

+Order Unit of Measure String(10)

+Order Unit Conversion Decimal(10,6)

Manufacturer's Item Number String(24)

Customer Item Number String(24)

+Quantity Committed Decimal(10,4)

Quantity True Committed Decimal(10,4)

Order Number String(22)

Order Detail Number Integer

+Refresh Order Qty. at Update Boolean

Original Quantity shipped Decimal(10,4)

Driven by UI Boolean

Found Negative Inventory Boolean

Action Integer

Shipment Uniquifier Decimal(10,0)

Order Date Date

Shipment Date Date

+Optional Fields Long

+Kitting/BOM Integer

Kit/BOM Number String(6)

+BOM Build Qty. Decimal(10,4)

+BOM Build Unit String(10)

+BOM Build Unit Conversion Decimal(10,6)

Unformatted Item Number String(24)

Shipment Line Number Integer

+Process Command Integer

ePOS Promotion ID Integer

Subject to Payment Discount Integer

Payment Discount Base With Tax Decimal(10,3)

Payment Discount Base Without Ta Decimal(10,3)

+Pricing Base Weight Unit String(10)

Weight Unit of Measure String(10)

+Weight Conversion Factor Decimal(10,6)

Pricing Weight UOM String(10)

+Pricing Weight Conversion Factor Decimal(10,6)

+Pricing Base Weight Conv. Factor Decimal(10,6)

+Def. Weight UOM Unit Weight Decimal(10,4)

+Def. Weight UOM Ext. Unit Weight Decimal(10,4)

+Price By Integer

Price Check Pending Boolean

Price Approved By String(8)

Approving User's Password String(64)

+Price Approval Needed Boolean

+Weight UOM Description String(60)

Header Discount Decimal(10,3)

TR Tax Amount 1 Decimal(10,3)

TR Tax Amount 2 Decimal(10,3)

TR Tax Amount 3 Decimal(10,3)

TR Tax Amount 4 Decimal(10,3)

TR Tax Amount 5 Decimal(10,3)

+Extended Amount Net of Tax Decimal(10,3)

+Discounted Extended Amount Decimal(10,3)

+Tax Total Decimal(10,3)

+TR Tax Total Decimal(10,3)

+Cost of Goods Decimal(10,3)

+Record Costed Boolean

+Job Related Boolean

Contract Code String(16)

Project Code String(16)

Category Code String(16)

+Cost Class Integer

Project Style Integer

Project Type Integer

Accounting Method Integer

Billing Type Integer

Revenue/Billing Account String(45)

COGS/WIP Account String(45)

+Retainage Amount Decimal(10,3)

Retainage Percent Decimal(5,5)

Retainage Days Integer

Retainage Due Date Date

+Retainage Due Date Override Boolean

+Retainage Amount Override Boolean

Retainage Tax Base 1 Decimal(10,3)

Retainage Tax Base 2 Decimal(10,3)

Retainage Tax Base 3 Decimal(10,3)

Retainage Tax Base 4 Decimal(10,3)

Retainage Tax Base 5 Decimal(10,3)

Retainage Tax Amount 1 Decimal(10,3)

Retainage Tax Amount 2 Decimal(10,3)

Retainage Tax Amount 3 Decimal(10,3)

Retainage Tax Amount 4 Decimal(10,3)

Retainage Tax Amount 5 Decimal(10,3)

Default O/E Price Integer

+Level 1 Name String(30)

+Level 2 Name String(30)

+Level 3 Name String(30)

+Unformatted Contract Code String(16)

Prepayment Distributed Decimal(10,3)

+Ext. Price Net of Disc. Inc. Tax Decimal(10,3)

+Detail Amount Due Decimal(10,3)

+Serial Quantity Long

+Lot Quantity Decimal(10,4)

+Serial/Lot Quantity to Process Decimal(10,4)

+Number of Lots to Generate Decimal(10,4)

+Quantity per Lot Decimal(10,4)

+Allocate from Serial String(40)

+Allocate from Lot String(40)

+Item Serialized/Lotted? Integer

+Serial/Lot Window Handle Long

Sage CRM Company ID Long

Sage CRM Opportunity ID Long

I have no idea what you just pasted and posted, but I repeat, line comments (and instructions) export.

I'm sorry if I am being unclear, but I still would appreciate some guidance on exactly where I choose to export those comments, because I have tried unsuccessfully many times.  Can you please be a bit more specific?

O/E Transactions

Order Entry

File

Export

Invoice_Comments_Instructions

If you are not getting anything in the export file then there are not any detail line comments.

I am providing a screenshot of an invoice entry where 3 of 4 lines all have comments.  Also below is a view ofn export file for this particular invoice entry and you will see that everything is blank for comment export fields.

What is a "view ofn export file"?

Sorry, it was "view of an export file"

INVUNIQ UNIQUIFIER DETAILNUM COINTYPE COIN

if you have comments in your order before you invoice it, then they will be there.  Comments = line type 1 and instructions are line type 2.

you could also just use crystal to export using the table OECOINI linked with OEINVH and OEINVD.

Probably a hell of a lot easier/faster than using the Export function.

I don't know what to say, it always works for me, and always has.

Did you drill down into the comments field to see if there was actually some comments or instructions?  Just because the field says 'Yes' does not mean there's definitely a written comment.

Yes I have done that.  I see the comments when I click on the column heading.

Call Sage tech support.