Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing Comment Lines into AR.INVOICE

Status
Not open for further replies.

baldi1970

Programmer
Jan 5, 2007
2
US
I left this task for last because it SEEMED easy enough. Sigh ;-)

I have 3 VI jobs. First 2 work fine - importing AR.INVOICE header data, and importing AR.INVOICE Line data.

The last job is for importing Line data only for Comments. You know, like when you manually enter /C in the SALES CODE field during Invoice Data Entry. I'm using ASCII file, sample below

1000009IN/C This is a comment

The Job has 4 data elements, and only the Comment record type:
INVOICE_NO
INVOICE_TYPE
SALES_CODE
COMMENT_DESCRIP

There are no errors in the import log - and no data either.:(

I've tried with/without the SALES_CODE, to no avail. I'm betting I'm missing some buried checkbox somewhere. Any ideas? Thanks in advance

-David

 
Never mind... I figured it out. I had not checked the all-important "Header information included in Detail Line" check box in the Job Configuration tab.

-David
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top