Hi Friends,
I have Multiple Chart Of Account Structure.
Each Chart of Account having multiple dimensions.
One COA having the dimensions of Project , Customer.(For Eg. Main Account - 4110100,Project - P123,Customer - C0001)
Another COA having the dimension of Project , Vendor and Fixed Asset(For Eg. Main Account - 2210100, Project - C123, Vendor - 1001, FIxed Asset - EQ001)
How the system know for the ledger Account(4110100) having project and customer as dimensions.
how to Assign the LedgerDimension field value in LedgerJOurnalTrans table dynamically based on the Main Account.
I want to Create LedgerJournalLines like . Account type - Ledger Account - 4110100-P123-C0001
How the system know for the ledger Account(2210100) having project and vendor and Fixed Asset as dimensions.
how to Assign the LedgerDimension field value in LedgerJournalTrans table dynamically based on the Main Account.
I want to Create LedgerJournalLines like . Account type - Ledger Account - 2210100-C123-1001-EQ001
Friends If You Know Please Share your Knowledge…
Regards,
Muthusamy
LedgerDimension field is actually a reference to DimensionAttributeValueCombinationTable and AccountStructure and MainAccount are its fields.
Does it answer your question?
Hi Martin Thanks for the reply.
I have to CREATE and POST the General Journal using X++ Code.
Create the two Journal Lines for a Single GL Journal.
Line 1. Account type - Ledger , Account - 1220300-P9999-S00002 Debit Amount - 15000
Main Account - 1220300; Project - P9999; Vendor-S00002
Line 2. Account type - Vendor, Account - S00002 Credit Amount - 15000
Question:
How to find the Particular Main Account(1220300) having the Combination of COA Structure(Main Account-Project-Vendor)
Because, Some Other Main Account having different COA Structure like Main Account - Vendor - Worker
Please Suggest the Solution.
Thanks and Regards,
Muthusamy
As I already said, the combination of AccountStructure and MainAccount is in DimensionAttributeValueCombinationTable. What you see in the form is just a representation for users, not the real data. The real value of LedgerDimension is a RecId of DimensionAttributeValueCombinationTable.
