I have looked into the issue and identified that the automation is currently picking the fields called "Amount in Doc. Currency (wrbtr) and Amount in Local Currency (dmbtr)" from the table BSEG where the values are stored in SAP.
If you see the table entry, the value which you are expecting is only stored in the field called "General Ledger Amount". The Local Currency and the Currency values are picked from this table and displayed correctly in the final output file.
[cid:5f531a08-b0cd-4b18-b0ad-90ba8f7a7e81]
[cid:15ede6c0-bd5d-4c1d-8b50-3dc3d36c9d8c]
I am not sure if in FBL3N, this data is somehow converted or displayed in some other format and not sure what is the expected column to pick the data for this amount field or this is somehow happening only for this currency type alone.
Please let me know if this clarifies the query or if you have any questions regarding the same.
SysAid Number - 2765168
Hi, I am creating a ticket per Juan Solano’s request. Below the context.
Thank you.
[cid:image003.png@01D9939F.DBCABB80] [cid:image004.gif@01D9939F.DBCABB80]https://bacardi.sharepoint.com/sites/BESCommunications/PTP/SitePages/PTP%20General/PTP%20-%20Home.aspx Please create a ticket for all your requests. Send an email to EMT.CONCUR@BACARDI.COMmailto:EMT.CONCUR@BACARDI.COM Why do we need a ticket?
From: EXT_Avva Chandra Koushik akoushik@bacardi.com Sent: Wednesday, May 31, 2023 12:36 PM To: Evelyn Zeledon Rodriguez ezeledonr@bacardi.com Cc: Juan Solano Rojas jsolanor@bacardi.com; Paola Moreira Abarca pmoreiraa@bacardi.com; EXT_Bharath Mahesh b@bacardi.com Subject: Re: 7225 Personal Expenses May 2023
Hi Evelyn,
Good Day!
I have looked into the issue and identified that the automation is currently picking the fields called "Amount in Doc. Currency (wrbtr) and Amount in Local Currency (dmbtr)" from the table BSEG where the values are stored in SAP.
If you see the table entry, the value which you are expecting is only stored in the field called "General Ledger Amount". The Local Currency and the Currency values are picked from this table and displayed correctly in the final output file. [cid:5f531a08-b0cd-4b18-b0ad-90ba8f7a7e81] [cid:15ede6c0-bd5d-4c1d-8b50-3dc3d36c9d8c]
I am not sure if in FBL3N, this data is somehow converted or displayed in some other format and not sure what is the expected column to pick the data for this amount field or this is somehow happening only for this currency type alone.
Please let me know if this clarifies the query or if you have any questions regarding the same.
Thanks & Regards Koushik AC
From: EXT_Avva Chandra Koushik akoushik@bacardi.com<mailto:akoushik@bacardi.com> Sent: Wednesday, May 31, 2023 8:45 PM To: Evelyn Zeledon Rodriguez ezeledonr@bacardi.com<mailto:ezeledonr@bacardi.com> Subject: Re: 7225 Personal Expenses May 2023
Hi Evelyn,
Good Day!
I will check on this and get back to you.
Thanks Koushik AC
From: Evelyn Zeledon Rodriguez ezeledonr@bacardi.com<mailto:ezeledonr@bacardi.com> Sent: Wednesday, May 31, 2023, 8:41 PM To: EXT_Avva Chandra Koushik akoushik@bacardi.com<mailto:akoushik@bacardi.com> Subject: FW: 7225 Personal Expenses May 2023
Koushik hi,
I compared the amounts and as you can see the tool shared something that is not correct:
In orange the amounts the tool shared, in green the real amounts. Do you know why was it changed?
[cid:image001.png@01D9939F.DBCABB80]
[cid:image002.png@01D9939F.DBCABB80]
[cid:image003.png@01D9939F.DBCABB80]
[cid:image004.gif@01D9939F.DBCABB80]https://bacardi.sharepoint.com/sites/BESCommunications/PTP/SitePages/PTP%20General/PTP%20-%20Home.aspx
Please create a ticket for all your requests. Send an email to EMT.CONCUR@BACARDI.COMmailto:EMT.CONCUR@BACARDI.COM
Why do we need a ticket?
From: Tulip RPA tulip01@bacardi.com<mailto:tulip01@bacardi.com> Sent: Wednesday, May 31, 2023 8:16 AM To: Sanae Osawa sosawa@bacardi.com<mailto:sosawa@bacardi.com> Cc: Evelyn Zeledon Rodriguez ezeledonr@bacardi.com<mailto:ezeledonr@bacardi.com>; Jostin Canales Araya jacanalesa@bacardi.com<mailto:jacanalesa@bacardi.com> Subject: 7225 Personal Expenses May 2023
Hi Team,
Please find the Personal Expenses sheet attached to the email.
If you have any questions, please send an email to emt.concur@bacardi.commailto:emt.concur@bacardi.com for clarifications.
Regards,
Tulip Automation Platform