Hey Community,
I tried different ways to import data, but still i am not able to match code , can you please help me out. I am attaching screenshot below.
@ysalvi4321 You can match code only with list items not with line items , for line items you would need 1*1 match not the code
Hi @ysalvi4321
Very interesting question - this gives us a chance to understand a couple of things.
First thing to know is that when you do an import, you need one line item(or column) in source that maps to the dimension of Target. In your case, it would be a code column in the excel you're using to do the import.
Another thing to observe is that out of the 3 line items in your screenshot, you have two formula driven line items - you shouldn't be trying to import values in those line items. That is why only size is the active line item in the mapping screenshot of yours. Summary is, you can import data into line items that don't have formulas.
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a…
I have this template to import back to my module By right it should match the module because the time format is the same as the module the only difference is that in the excel file there is a seperator. M-Y. Thus logically to me it should be But when i run the action using M-Y and match names both result in an import error…
Hi everyone, I was trying to Retrieve a Line Item (Boolean) using TIMESUM as formula to another module by using ANY. This Boolean LI has A,B,C as dimensions. My target module has only A as dimension. In order to use a reference module for mapping, does this reference module had to have A,B and C as dimension or just A…
