Hi Warren,
I just gave it a try and everything worked. Here was my job:
I integrated transactions in current and one future year.
I integrated transactions in current yr, one future year, and one previous (but still open year).
I integrated transactions in current yr, one future year, one previous but still open year, and one history year.
Make sure you do not have any filters or restrictions on your sources. If you right click on the source and then select 'Preview', does your source data appear as expected? Check how you have related the hdr and detail and make sure your line items are properly lining up with your header.
The preview will be the most telling. A GL trx is the most straight forward entry around - you'll probably die when you find out what it was! :)
Kind regards,
Leslie
Here is a copy of the integration setup:
Integration:
Name:
GL Trx One Source File
Description:
GL Transaction using one source file
Integration Type:
imIntTypeInsert
Max Errors:
10
Max Warnings:
10
Require Full:
False
Source Queries:
Name:
GL Header One Source
Description:
GL Transaction using the GLtrx.txt file
Columns:
Column Name Data Type Show IsKey
Account String True False
Amount String True False
Reference String True False
Date String True False
Rows:
Order By:
Date Asc
Group By:
Date
Scripts:
BeforeQuery
AfterQuery
Name:
GL Line One Source
Description:
GL Transaction using GLtrx.txt file
Columns:
Column Name Data Type Show IsKey
Account String True False
Amount String True False
Reference String True False
Date String True False
Rows:
Order By:
Date Asc
Group By:
Scripts:
BeforeQuery
AfterQuery
Relationships:
Master Query Column Child Query Column Child Cardinality
Date Date Many Children
Destination:
Name:
General Journal
Mapping:
Entries
Analysis Code ID
Use Source Field
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Posting Description
Use Default
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Quantity
Use Default
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Amount
Use Default
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Options:
Record Source Use Default
Analysis Posting Detail
Analysis Group ID
Use Source Field
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Options:
Record Source Use Default
Entries
Account Description
Use Source Field
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Intercompany ID
Use Default
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Account Number String
Use Source Field
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Account Number
Use Source Field
GL Line One Source.Account
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Debit Amount
ositive Source Field
GL Line One Source.Amount
Shift Decimal Point 0
Rounding Round with Warning
If Null Use Zero
Credit Amount
egative Source Field
GL Line One Source.Amount
Shift Decimal Point 0
Rounding Round with Warning
If Null Use Zero
Distribution Reference
Use Source Field
GL Line One Source.Reference
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Exchange Rate
Use Default
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Options:
Record Source Use Source Recordset
Entries
Exchange Rate
Rate Type ID
Use Default
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Exchange Rate
Use Source Field
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Exchange Rate Date
Use Source Field
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Exchange Rate Time
Use Source Field
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Options:
Override Rate Variance Cancel Document
Record Source Use Default
Override Exchange Rate Cancel Document
Use New Exchange Rate Cancel Document
Tax Entry
Transaction Type
Use Default
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Account
Use Source Field
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Amount
Use Source Field
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Tax Detail
Use Source Field
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Tax Amount
Use Default
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Distribution Reference
Use Default
Translation No
Case Conversion No Conversion
Leading Spaces Remove
Trailing Spaces Leave
String Truncation Truncate at Max Length
If Null Cancel Document
Options:
Record Source Use Default
General Journal
Journal Entry
Use Default
Intercompany
Use Default
Batch ID
Use Constant
GL TRX ONE
Constant Value GL TRX ONE
Transaction Type
Use Default
Constant Value GL TRX ONE
Transaction Date
Use Source Field
Date
If Null Use Default
Reversing Date
Use Default
If Null Use Default
Source Document
Use Default
If Null Use Default
Reference
Use Constant
GL Transaction Integration
Constant Value GL Transaction
Integration
Currency ID
Use Default
Constant Value GL Transaction
Integration
Status
Use Source Field
Constant Value GL Transaction
Integration
Note
Use Default
Constant Value GL Transaction
Integration
Options:
Missing Batch Add New Batch
Multicurrency fields Use Functional
Scripts:
BeforeIntegration
AfterIntegration
BeforeDocument
BeforeDocumentCommit
AfterDocument
IntegrationError
DocumentError
DocumentWarning
Share
Report
455
All responses (
Answers (
