Closing Adjustment error after resume

(0) Share

Report

Posted on by YK Cheong

One user is running the closing adjustment. After 5 hours still not complete, I login, pause the closing adjustments. After that resume again.

After a while the system prompts error due to voucher number already exists. Upon checking, the system updated the closing adjustment done by earlier user. It shows I'm the audit trail.

Now, the closing adjustment shows error and we cannot resume. We try to rename the voucher number but nothing happened.

Please help.

Thanks.

Cheong

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Cheong,

What does the error message say exactly?

Can you share the complete error screen?

Many thanks and best regarsd,

Ludwig

Was this reply helpful? Yes No
real_ashwin 1,225 on at

Like (0)

Report

What is closing adjustments is it the "closing sheet" or are you running the "Opening transactions" option in Fiscal year close ? In either case can you share the screen of the options you used before you processed ?

Was this reply helpful? Yes No
YK Cheong 84 on at

Like (0)

Report

Dear Ludwig,

Good day to you.

Thanks for the reply. Here is the error message.

Upon further checking, this voucher already exist in Voucher Transactions. However, we found out that there are no entries in Closing and Adjustment > Settlement for 30 Apr 2019.

We have checked the number sequence and everything is correct. We tried to rename the voucher number but system does not allow.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

There might be an overlap with other vouchers created in your system.

Can you navigate to the inventory and warehouse management parameters form and open the number sequences tab.

There you should find the number sequence that is used for posting closing transactions.

Open this number sequence and make it unique for example by adding a constant into the segment section.

Once you have achieved this, try resuming the process again.

Best regards,

Ludwig

Was this reply helpful? Yes No
YK Cheong 84 on at

Like (0)

Report

Dear Ludwig,

Good day to you.

Thank you for your prompt reply.

We have tried your suggestion and the system still prompts the same error message.

We also tried to rename the voucher number but no action taken by the system.

What is the best practise to pause the inventory calculation by one user and resume the calculation using another user login/session?

For your information, our vendor managed to completed the closing process by allowing duplicate voucher number, but the 'Settlement' still blank. Next, they cancel the problematic closing entry (system prompts error but the entry was changed to 'Posted'). After that, they run the closing again and it was completed without error.

We found out that they are difference between the 'Settlement' and G/L Account.

Is there a way that can help me to quickly find the difference between the 'Settlement' with G/L Account?

Best regards,

YK Cheong

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello YK Cheong,

A quick way to find a difference between inventory and GL transactions is the use of the inventory value report that allows you identifying the inventory balances on top and comparing them with the ledger balances at the bottom of the report.

Have you already tried running this report?

Best regards,

Ludwig

Was this reply helpful? Yes No