Finance | Project Operations, Human Resources, ...

Invoice journal open in excel

(1) Share

Report

Posted on by CU21081751-4

Hi experts,

Client is using “open in excel ” functionality to update thw vendor invoice.

They are facing an issue of, the invoice invoice date not pulling in excel.

Repro steps as below:

Goto Vendor invoice journal > select the journal batch number > open in excel

Can anyone help me on what could reason of invoice doesn't pull in excel?

Thanks

All responses (7)

Answers (0)

Anoop Paliath 11 on at

Like (0)

Report

Invoice journal open in excel

Sorry I used a wrong link for finding the table browser.

Below is screen shot of data which I got for table browser for "LedgerJournalTrans", which data.

Can you help on how we can fix this, for the journal line to appear in the excel.

Thanks.
Anoop Paliath 11 on at

Like (0)

Report

Invoice journal open in excel

Hi,

Thanks for your valuable suggestion.

The suggestion of sign out and reload is not working as the lines are still empty for the particular journal batch number. Below is screen shot after sign out and reload.

Mr. Waed,

Above the screen shot of journal when i connected Data connector. As you can see the journal batch number, description (the journal name), posting status (No) and the debit & credit value is already displayed in excel however the Line is empty. Below is the values which are in line level in the journal.

The table browser using the link provided by you is as below:

Can you help me on how to resolve this issue?

Thanks!
Waed Ayyad 6,619 Super User 2024 Season 2 on at

Like (0)

Report

Invoice journal open in excel

Hi,

Is your issue resolved, if yes please verify the correct answer.

Thanks,
Waed Ayyad
Suggested answer

Mohamed Amine Mahmoudi 10,964 Super User 2024 Season 2 on at

Like (0)

Report

Invoice journal open in excel

Hi,

Can you sign out from excel Add-In and close all the browser.

And Then click Reload, once it is reloaded then try to sign-in again with your login credentials.

Best regards,

Mohamed Amine MAHMOUDI
Suggested answer

Waed Ayyad 6,619 Super User 2024 Season 2 on at

Like (0)

Report

Invoice journal open in excel

Hi,

It seems the issue on this journal only but from the form can you check if the Journal has lines or not?

Also you can open table browser using this link: YourEnvironment/?mi=SysTableBrowser&TableName=AbbreviationsStaging

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue
CU21081751-4 on at

Like (1)

Report

Invoice journal open in excel

Hi,

The downloaded invoice template has value from header level like Journal batch number, Vendor name, debit & credit amount. Howver the line level values are empty.

The respective journal batch number is not available in lower environment to check this. I checked this for another journal batch number in invoice journal however the excel had all values.

Could it be issue with that particular batch number or the issue can be common for all journal batch numbers?

Thanks
Suggested answer

Waed Ayyad 6,619 Super User 2024 Season 2 on at

Like (0)

Report

Invoice journal open in excel

Hi,

Do you mean the date return empty? Did you check if the field already filled from table browser or form?

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue