Journal Entry numbering stops after Inventory Posting

[Former Member]

Hi Experts!

I have a problem with one of my accounts.

Apparently, when the user is performing End-of-Month Inventory Posting transaction in Inventory->Inventory Transactions, the Journal Entry's numbering series stops.

In that effect, no user can post any transactions that has Journal Entry implications like A/P Invoice, A/R Invoice, Incoming Payment etc.

Help me guys and I appreciate it alot.

They are using

SAP B1 8.82 PL 17

MS SQL 2008 R2

[Former Member]

Hi!,

Actually, the number series is not full nor doesn't have period-related setup.

The scenario is this:

1. Journal Entry module works perfectly fine with current number set as 1842.
2. User performed Inventory Posting and the effect is a Journal Entry #1843 was created.
3. After this, any Journal Entry related transactions like A/R Invoice, Incoming Payment, JE, Outgoing etc... will produce an error saying that there is a JE number already exists and opening a new Journal Entry window will result to having a document number being 1843 (already exists)
4. User will do Help-> Restore Numbering Series and the database will be ok again.

The problem arose everytime user creates Inventory Posting.

Any Idea guys? Thank you in advance

[former_member205766]

Hi

I feel there is some bug in sap so please raise incident to SAP Support.

With Regards

Balaji Sampath

[Former Member]

Hi!,

Actually, the number series is not full nor doesn't have period-related setup.

The scenario is this:

1. Journal Entry module works perfectly fine with current number set as 1842.
2. User performed Inventory Posting and the effect is a Journal Entry #1843 was created.
3. After this, any Journal Entry related transactions like A/R Invoice, Incoming Payment, JE, Outgoing etc... will produce an error saying that there is a JE number already exists and opening a new Journal Entry window will result to having a document number being 1843 (already exists)
4. User will do Help-> Restore Numbering Series and the database will be ok again.

The problem arose everytime user creates Inventory Posting.

Any Idea guys? Thank you in advance

[kothandaraman_nagarajan]

Hi,

1. Please raise ticket to SAP support to fix this issue.

2. Restore function should be performed with SAP support.

Thanks & Regards,

Nagarajan

[former_member205766]

Hi

Take the Backup and check the restore functionality if it is works just confirm with SAP Support then Proceed.

or

Raise the incident to SAP support and solve this issue.

Thanks

With Regards

Balaji Sampath

[kothandaraman_nagarajan]

Hi,

Did you receive any error message?

Thanks & Regards,

Nagarajan

[former_member186095]

Hi Jack,

It is probaby caused by an automatic closing period in the posting period.

You must check it in the posting period. Your journal entry numbering maybe use the period indicator. The period indicator is a year and the posting period that using the period indicator is ctlosed

REgards,

JImm

[former_member196081]

Go to Administration >>system initialization >> document Numbering >> Journal Entry>> click on to this and new one window will pop up. check here the last number of default series. I think the the same has been full.

[Rafaee_Mustafa]

Hi Jack,

If your default series get full you need to create new series and make it default.