Is it possible to export OE comments? We have been storing serial numbers in the comments filed until we get an optional field set up and I am unable to find where in the script I can get the comments.
Sage 300 ERP 2014
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.
INVUNIQ | UNIQUIFIER | DETAILNUM | COINTYPE | COIN |
What is a "view ofn export file"?
Sorry, it was "view of an export file"
INVUNIQ UNIQUIFIER DETAILNUM COINTYPE COIN
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.
*Community Hub is the new name for Sage City