BPC UPLOAD JOURNALS

[Former Member]

Hello Experts

In the flat file journal upload,we are facing the issue of rows being populated to the same Journal ID despite having different description.

E.g.

4 rows to be uploaded.

Row 1: Test description

Row 2: Test description

Row 3: Test description2

Row 4: Test description2

Expected result:

Row 1 and 2, being of same description, go into Journal ID 1.

Row 3 and 4, being of same description, go into Journal ID 2.

Actual result:

All rows go into Journal ID 1 and the description is only "Test description".

Could you please advise?

Thank you.

[former_member186338]

I have already told you, that RESTORE journals can't be used to upload new journals. You have to write your own code to implement upload.

[Former Member]

Hi Vadim

Thanks for your reply . I used the restore functionality and performed the following steps:

1. Run the Export journals package.

2. Downloaded jrn file from UJFS.

3. Opened jrn file in the csv file.

4. Added few journals and ID kept as blank

5. Upload the changed file to the server.

6. Import journals from this file.

Issue I am facing is the rows being populated to the same Journal ID despite having different description.

There is a client requirement that during monthend they want to post many journal adjustment entries as they want to track the adjustments and they are looking for functionality to upload the journals in bulk

Regards

[former_member186338]

Sorry, but there is no standard "Upload journals" from text file. There is a chain /CPMB/RESTORE_JOURNALS, but restore is not upload.