General Journal upload with dimensions details

schoolkid

Hello

I will need to upload salary entries through General Journals using csv files. Is it possbile to upload Journals with dimension details, if yes, how and what are the tables do I need to select in the dataport?

Thanks in advance for your help!

kapamarou

If your dimensions are part of the line in the file you will need to declare a variable of type Record 356 Journal Line Dimension. After importing the Journal Line record then you will insert your dimension line through your variable.

matttrax

Actually if you just validate the dimension fields the code in the OnValidate trigger will take care of everything for you (assuming it hasn't been modified for some reason).

kapamarou

matttrax wrote:

Actually if you just validate the dimension fields the code in the OnValidate trigger will take care of everything for you (assuming it hasn't been modified for some reason).

But this will not be for any dimension. Just for the shortcuts located in the Journal Line table. Additional dimensions will require manual insertion.

matttrax

kapamarou wrote:

But this will not be for any dimension. Just for the shortcuts located in the Journal Line table. Additional dimensions will require manual insertion.

True enough. Dimensions 3 through 8 do have to be inserted manually. If you're not using the Advanced Dimension Management, though, just do a validate.

Before we get into a lot more detail than is necessary I think we should wait for schoolkid to let us know if they are in fact using Advanced Management. There are plenty of things that need to be taken into account if you're going to insert dimensions manually.

tthyagu

First upload data into Gen Journal Line table. Then upload dimension data into Journal Line Dimension table. Here use the same Line No, which you had used for Gen Journal Line table.

Now you check the Journal form for dimension. Automatically linked.

Regards

schoolkid

Thanks for your valuable suggestions!!

We are not using Advanced Management. The dimensions are inserted manually.

matttrax

So yeah, if you're only using the two main dimensions do a simple validate when you bring in the fields. No need to go into all the other advanced dimension stuff. Good luck with your dataport.