Skipped Number in posted invoice sequence

(0) Share

Report

Posted on by Community Member

We have an issue wherein there was a posted invoice number skipped and we are trying to find out what happened. Based on the blogs, forums and other help documents I found - it seems when a sales order is being posted and an error occurs - a posting number is assigned.

I was able to find out in the Sales Header Table where the skipped Invoice number was assigned to the Sales Order number.

This sales order was not posted - Sales Order No. 14-2864 and there is a posting number assigned SI079864.

We would still like to post this sales order to generate the invoice - but how do post the sales order and still use the Posting No. Assigned to this sales order?

I know how to looked for skipped posted invoice now - the problem I have is how do I post the sales order but still use the assigned posting number?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (2)

Community Member on at

Like (0)

Report

RE: Skipped Number in posted invoice sequence

Check the No. Series table whether the said number is used or not.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Skipped Number in posted invoice sequence

If we post the sales order - will it still use the posting no. that is assigned to this sales order ?

Was this reply helpful? Yes No
Suggested answer

Jan Veenendaal 510 on at

Like (1)

Report

RE: Skipped Number in posted invoice sequence

As far as I know, on posting of the Sales Order, when the Sales Invoice Header is created, the "Posting No." that was inserted in the Sales Header on the previous attempt, will automatically be used to create the sales invoice.

So I think you should just post the sales order.... [ please try and verify the result first in a copy of your current database ]

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

RE: Skipped Number in posted invoice sequence

Yes it will use the assign posting no.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Skipped Number in posted invoice sequence

Appreciate your response on this - have asked our accounting to post it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Skipped Number in posted invoice sequence

Appreciate your verification on this. We will be posting this sales order today.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

RE: Skipped Number in posted invoice sequence

I checked it once again to make it sure. yes it will use the assigned posting No while posting the document and will not generate a different No for the document. So you can post this without a problem and will not cause any issue in your No. series.

Was this reply helpful? Yes No