Lets assume there is one of the common scenario in which you are uploading records for customer groups along with its financial dimensions using data entities.
Problem : Number of dimension values specified in application development is different from the number setup in the active format for data entities.
Root cause : There is difference in number setup of excel file and active format of data entities.
Solution : Check your active format for financial dimension on following navigation (General ledger - Charts of accounts - Dimensions - Financial dimension configuration for integrating applications) and update excel file according to format or change its format. Then try to import data by using entity.
Below is the file format for customer groups uploading process through entities. For dimension value we are using format Dimension1-Dimension2-Dimension3.
Hello, say you have several integrations and each uses a different set of financial dimension. Since you can only have one dimension of each active at a time, what would be the solution so user doesn't have to go into GL>Dimensions configuration each time before uploading to activate the dimension? In my case, i'm using data entities to import General journal and atleast one of the integration will be setup as recurring job which is further making this difficult.
ReplyDeleteHi, you need to check it out whether you can skip out this dimension configuration validation or not. There is a class know as Dimension Resolver and it has a method namely "checkFormatCreated" check it. But make sure you should do skipping or anything just for you entity. Or try to unmark the check box available on entity mapping for validating field. For different set of financial dimension perform add some logic on entity or check it out where suitable.
Delete