How to use the Negative Sign Identifier in Data Exchange Definitions

(1) Share

Report

Posted on by Sathish M

Hello Everyone,

I am attempting to utilize the /Negative Sign Identifier/ in Data Exchange Definitions to upload amounts with negative signs. However, I am facing difficulties in uploading amounts with a negative sign. Could someone kindly explain how to use this feature? For your convenience, please refer to the column details below.

Tran Date	CHQNO	PARTICULARS	DR	CR	BAL	SOL
02-07-2023	-	UPI/P2A/318352376315/SUJEET NA/HDFC BANK/Payment	404		633.88	1348
03-07-2023	-	UPI/P2M/318410930363/IRCTC UTS/Paytm Pay/Oid8070	100		533.88	1348
04-07-2023	-	UPI/P2M/318575778592/PATEL MOT/Paytm Pay/Payment	80		453.88	1348
04-07-2023	-	UPI/P2M/318579564691/BharatPe /YesBank_Y/Pay to	160		293.88	1348
05-07-2023	-	UPI/P2M/318622228053/MOHD ALIM/Yes Bank /Payment	40		253.88	1348
05-07-2023	-	UPI/P2M/318626624971/Balaji Dr/Paytm Pay/Payment	125		128.88	1348
06-07-2023	-	UPI/P2M/318718337302/IRFAN SID/Bank of I/Merchan	40		88.88	1348
07-07-2023	-	UPI/P2M/318579564691/BharatPe /YesBank_Y/Pay to	0	100	188.88	1348
08-07-2023	-	UPI/P2M/318622228053/MOHD ALIM/Yes Bank /Payment	0	100	288.88	1348
09-07-2023	-	UPI/P2M/318626624971/Balaji Dr/Paytm Pay/Payment	0	200	488.88	1348
10-07-2023	-	UPI/P2M/318718337302/IRFAN SID/Bank of I/Merchan	0	300	788.88	1348

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

With the data you are presenting I do not think you can use this feature because your data does not contain any negative sign identifier.

So if you are importing to a journal I think you will have to import the debit column into debet amount and credit column into credit amount.

Or you will have to use some kind of custom coded formatting.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,718 Super User 2025 Season 2 on at

Like (0)

Report

Hi, just to add some information, hope it will give you some help.

https://learn.microsoft.com/en-us/dynamics365/business-central/across-how-to-set-up-data-exchange-definitions

https://www.dynamicsuser.net/t/data-exchange-framework-negative-sign-identifier/64049

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Sathish M 28 on at

Like (0)

Report

"Dear YUN ZHU,

Based on your previous answer, I've attempted to do the same. However, I'm still unclear about what value I should input for the 'Negative Sign Identifier' in order to import positive amounts with a negative (credit) symbol. I am trying to import the 'CR' column as a negative value.

Thanks in Advance

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

That is the issue with your data.

You do not have a negative sign identifier in your data so you can not enter anything.

You need another approach to import your data. You will have to do some customization in order to be able to import your credit amount as negative values.

Was this reply helpful? Yes No