Skip to main content
Answer

Create a journal transaction using import scenarios of business event.

  • July 6, 2024
  • 4 replies
  • 216 views

Forum|alt.badge.img

Hello!

I want to create a journal transaction by using the import scenarios of business event. To this I use a Generic Inquiry. 

Generic Inquiry only provides information about the credit entry, and the information for debit entry is fixed. 

 

I tried to get the journal transaction created in different ways but it only create debit leg of the transaction. 

Then I thought to go with the journal vouchers, but the issue is the credit and debit entries should go for two different branches and journal vouchers does not facilitate that. 

Can someone help me with this?

Best Regards 

Amanda 

Best answer by dcomerford

@apallawala21 Here you go i changed the mapping so i could test with a spreadsheet.

You issue really was you were not using the linenumber = -1 to insert the second line

4 replies

dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • July 7, 2024

Could you share the import scenario snd i will havr a look


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • July 8, 2024

Hi @dcomerford 

Attached is the import scenario. 

 


dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • Answer
  • July 8, 2024

@apallawala21 Here you go i changed the mapping so i could test with a spreadsheet.

You issue really was you were not using the linenumber = -1 to insert the second line


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • July 8, 2024

Hi @dcomerford 

This worked for me!

Really appreciate the support!😊

Amanda