Both a positive and a negative position exist (TRM Security)

[charnockl]

Users are trying to capture a sale of a Treasury security and get the error "both a positive and a negative position exist for 28.02.2023".

They are capturing a sale and a purchase for the same securities account.

Any ideas?

[jasmine_li]

Hello Lara,

Please see the long text of the message TRQ0030:

____________________________________________________

Short Text

Both a positive and a negative position exist for &1

Diagnosis

There is at least one other position which matches the company code, ID number and securities account of this position. These positions have quantity ledgers with conflicting debit/credit signs on key date . This is not supported.

System Response

Further processing is not possible.

Procedure

Check the position for key date with the Position List for Quantity Ledger Positions (TPM26)

--------------------------------------------
Company code, security account and id number are the differentiation criteria for the TRS ledger (security account position). In addition valuation class needs to be entered to create the TRL position.

When you enter the new deal, a new short position will be created for the same TRS differentiation criteria (only the valuation class is different). This is not possible/not supported.

You have to enter the same valuation class, so that no new position is created or you have to enter a different security account.

Hope this helps.

Best regards,

Jasmine

[Gustavo_Vazquez]

Hi Lara,

Is the transaction on the same day ? . try to post 1 and then the other. It might work.

I think I have tried sometime ag ot post 2 transaction (buy & sell) on the same and the system didn't allow me.

Does it make sense to buy & sell a Security on the same day ?

Could you share TPM13 for the period in question ?

Kind Regards