Dynamics Community Forum Thread Details

Transaction Import with Multi-Company

Hi,

I'm trying to perform a transaction import in a multi-company environment. I'm trying to perform the transaction import on the voucher and adjustment entry screen 0301000. Both companies have have different chart of accounts. The transaction import works fine when one company is in the data file. however when both companies are in the file i get this error message.

'System Message 9: Item not found, please reenter.

'System Message 8002: Error In Field: cacct Value:

'System Message 8004: Data File Record/Line Number: 4 Column: 51
'Transaction,SIS,N,0741100010,004,376.15,,DCUMMINGS,

When i enter the transaction manually, and switch companies i get the same alert message "Item not found, please reenter" because the company i switched to has a diffrent chart of account, but it still lets me proceed to select a chart of account and enter the line item, however in the TI import it doesn't.

Document,,VO,REUTER,01/27/2010,SF2045369,1/1/2010,,20215.727,A,1/31/2010,1/28/2010,Reuters 3000 Xtra,US00292-001,CPIERCE,0
Transaction,SIS,N,0741100010,004,397.93,,MYALLOP,
Transaction,SIS,N,0741100010,004,376.15,,DCUMMINGS,
Transaction,SIS,N,0741100010,005,188.08,,SLYNCH,
Transaction,BSNY,N,80200,105,376.15,,COLATE,
Transaction,BSNY,N,80200,124,376.15,,JYANES,
Transaction,BSNY,N,80200,127,3193.66,,JTHOMAS,
Transaction,BSNY,N,80200,136,376.15,,ASCHWARTZ,
Transaction,BSNY,N,80200,136,376.15,,ASCHWARTZ,
Transaction,BSNY,N,80200,136,376.15,,ASCHWARTZ,
Transaction,BSNY,N,80200,136,228.2,,RGRIMSBY,
Transaction,BSNY,N,80200,136,228.2,,JALONSO,
Transaction,BSNY,N,80200,242,24.32,,JCRUZ,
Transaction,BSNY,N,80200,242,24.32,,RSOLER,

Quick Links