Hi Folks,
I have been asked to provide the following from Vantage:
Transaction Number - Uniquely identifies the record; no duplicates
Base_Curr - Currency used to report financials in HFM
Entry_date - Date the transaction was entered in the system
Fiscal Period(Format YYYYMM) - Fiscal period the transaction is applied to
GL_Acct - Account number for GL transaction
GL_Acct_Desc - Account description
Transaction_type - Example: I for Invoice, JE for Journal Ledger Entry
Document_No - Invoice/Credit/Debit document number
Document_type - I/C/D
JE_Line_No - Line number of JE if applicable
Customer_code - Bill to account number of customer
Transaction_amount - Amount in base currency
Ultimate_Destination - Two Character ISO country code of ultimate destination if possible or provide a mapping
This has been asked for in csv format. A couple of concerns - what would I use for the Transaction number? Also, how do I tie in the ultiamte destination? I thought about exporting the general ledger report into excel and somehow doing a lookup to customer codes but that seems extremly lang winded.
Any help would be greatly appreciated.
Michael
I have been asked to provide the following from Vantage:
Transaction Number - Uniquely identifies the record; no duplicates
Base_Curr - Currency used to report financials in HFM
Entry_date - Date the transaction was entered in the system
Fiscal Period(Format YYYYMM) - Fiscal period the transaction is applied to
GL_Acct - Account number for GL transaction
GL_Acct_Desc - Account description
Transaction_type - Example: I for Invoice, JE for Journal Ledger Entry
Document_No - Invoice/Credit/Debit document number
Document_type - I/C/D
JE_Line_No - Line number of JE if applicable
Customer_code - Bill to account number of customer
Transaction_amount - Amount in base currency
Ultimate_Destination - Two Character ISO country code of ultimate destination if possible or provide a mapping
This has been asked for in csv format. A couple of concerns - what would I use for the Transaction number? Also, how do I tie in the ultiamte destination? I thought about exporting the general ledger report into excel and somehow doing a lookup to customer codes but that seems extremly lang winded.
Any help would be greatly appreciated.
Michael