GL - LineTax - Reverse Charge - Displaying

[MariaHashimi]

Hi @ledger123,

During the testing of LineTax in the GL, we noticed that the RC was displayed in a "1:1" relation. This works for CH but not for Germany, as Germany has many "negative" accounts linked to one reverse charge account.

You could see this in the following recording that we did on your server (please not that we have for the testing purpose activated LineTax and afterwards I have disabled it.

https://github.com/ledger123/runmyaccounts/assets/152606672/9eb573f0-e676-40e4-b874-218e24e30fad

[MariaHashimi]

Hi @ledger123,

As discussed, you will find the "screenshots" of how the reverse charge should look like in a booking.

1. Creating a booking - When creating a booking nothing changes, the user selects the:

• Debit account
• Credit account
• Tax account (which is a Reverse charge)

2. Overview of the Booking - When the user is searching for the booking in the journal, the Overview will look like the following (here nothing will change - it is how the bookings where a reverse charge is added look like this on the overview)

3. Open the booking - When the users open the booking from the journal/report, the booking will look like the following: The counter reverse charge will each have a separate line, and they are not linked to an account in the booking

For your information, the tax table would look like the following: The account "1205" is linked to two other accounts (counter reverse charge account): 2205 & 1206

[ledger123]

Hi @Hashimi Maria @.***> , thanks for the update.

I go through it and adjust the code.

Regards

On Wed, 27 Mar 2024 at 13:30, MariaHashimi @.***> wrote:

Hi @ledger123 https://github.com/ledger123,

As discussed, you will find the "screenshots" of how the reverse charge should look like in a booking.

1. Creating a booking - When creating a booking nothing changes, the user selects the:

• Debit account
• Credit account
• Tax account (which is a Reverse charge) 1.Creating.a.booking.png (view on web) https://github.com/ledger123/runmyaccounts/assets/152606672/26daa4b0-8e8b-47af-bc1c-19ac4010da39

Overview of the Booking - When the user is searching for the booking in the journal, the Overview will look like the following (here nothing will change - it is how the bookings where a reverse charge is added look like this on the overview) 2.Overview.of.the.Booking.png (view on web) https://github.com/ledger123/runmyaccounts/assets/152606672/564f4ca8-e07a-487e-8371-427e7ef39a9a 2.

Open the booking - When the users open the booking from the journal/report, the booking will look like the following: The counter reverse charge will each have a separate line, and they are not linked to an account in the booking 3.Open.a.Booking.png (view on web) https://github.com/ledger123/runmyaccounts/assets/152606672/255cef77-e1be-4aad-b382-3296c5d5f5c0

For your information, the tax table would look like the following: The account "1205" is linked to two other accounts (counter reverse charge account): 2205 & 1206 Tax.table.png (view on web) https://github.com/ledger123/runmyaccounts/assets/152606672/a00a0ab6-be22-4d97-9c85-e95448f9dda8

— Reply to this email directly, view it on GitHub https://github.com/ledger123/runmyaccounts/issues/467#issuecomment-2022200653, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAADKHJPSKYPZ7QYDXIC533Y2JYSBAVCNFSM6AAAAABER2NRUWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAMRSGIYDANRVGM . You are receiving this because you were mentioned.Message ID: @.***>

[ledger123]

Hi @MariaHashimi ,

Good morning. My reply got little delayed. Apologies for that.

I have just gone through the update and in the screen shot "2. Overview of the Booking" debit and credit totals are not equal. On one side, it is 200 + 5 and on other side it is 200+5+7.7. So this is incorrect. We need to come up with some scheme where both totals should be same.

I think accountants can help us with the correct display of booking in journal.

Regards

[MariaHashimi]

Hi @ledger123, We had today a call wht our German colleagues and I've we have created the following Excel file on how the bookings should look like when there is a RC tax included in them.

On the line of the "RC counter account," the user should not be able to select an account or add anything in the debit or credit fields.

GL bookings wht RC.xlsx

If he wants to remove that line, he has to change the "RC account" and update the payment, and then the RC Counter account line will also disappear.

Please do not hesitate if you have any questions,

Best regards,

[ledger123]

Hi @MariaHashimi ,

I think there is some mis-understanding regarding the requirements description.

As mentioned in your first post in this thread, we already have this 1:1 reverse charge functionality which is mentioned in the attached XL file above. What seems to be requirement is to have one-to-many reverse charge functionality.

Please correct if I am wrong or confused.

Regards

[ledger123]

Hi @MariaHashimi ,

Good morning.

The proposed requirement to display the reverse charge tax on GL screen is not possible without significant amount of work. This is because we cannot keep the account number blank and tax values as numbers as posting such a transaction will ignore everything on the line with blank account number.

This is quite a complicated module because we have accomodated a lot of functionality in this screen.

However to assist accountants avoid confusion, we can add a display under the transaction with correct debit and credit values as shown in the following screen shot. This will fulfill our purpose of clearing confusion and avoiding any tricky/lengthy changes.

Regards

[MariaHashimi]

Hi @ledger123, We discussed with the accountants and the proposed solution could work for us. So we can move forward with your idea.

Looking forward to be testing this proposition :)

[ledger123]

Hi @MariaHashimi ,

I have made the necessary changes and pushed the code to the respective branch. Here is screen shot from our demo server.

Please test in your convenience.

Regards