on 10-20-2022 3:33 PM
After making invoice can i change or update GL ? As by mistakenly I have selected other GL in my foreign company database..
Or is there any way we can make changes through any query or through backend ??
So is there any by chance possible to change GL in Invoice based transactions ?
Regards
Hello Malay,
Hope you're doing well!
Once an invoice has been posted and journal entry has been created in the system, you cannot edit the G/L account in the line item. However, you can cancel the invoice document and reopen the base document which will then generate a cancellation journal entry as well. Later, when the base document is re-opened, you can recreate the invoice with right G/L Account.
Please make sure that you have enable the option to reopen the base document upon cancellation in the settings.
Hope this would be helpful.
Regards,
Kuldeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Malay,
If you have created the invoice without any base document, still you can follow the same steps:
1) Cancel the current invoice (with wrong GL Account)
2) Create the new invoice with correct GL Account.
Also, before adding the document please preview the journal entry to make sure accounting posting is correct.
Regards,
Kuldeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello KD sir,
Thanks for your answer.. and I understand the complete scenario..
Thanks & regards
Malay
Hi,
There are only a few fields in documents which can be changed after these are posted in the system. A posting creates a Journal Entry which is legally binding is not editable.
Changing or updating the G/L Account or details which are not available for editing is not supported and doing it can lead to inconsistencies in the database.
Better you go with the workaround of creating a cancellation document and post the same again with the required details.
Kr,
Jitin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
74 | |
10 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.