Unposted Invoice does not show up in Sales transaction entry

(0) Share

Report

Posted on by Nancy Cohen

460

We have an invoice that shows as unposted in the smartlist and in the database sop10100 and sop10200 have records, but when you double click on the entry in the smartlist it says the document is posted. Other invoices posted from the same batch and the batch header is not there anymore and not in batch recovery. Does anyone know what else to look at in db to know why this is happening.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Praveen Kumar RR 1,552 on at

Like (0)

Report

SOP10100 and SOP10200 tables will have records for both Unposted and Work State Transactions. However i suggest you to check Inquiry Window if the transaction exists in it.

In SOP Series, we don't have differentiation of 20000 Series.

Was this reply helpful? Yes No
Nancy Cohen 460 on at

Like (0)

Report

Turns out that the Batch Source for this invoice had an * in front of the value Sales Entry ie *Sales Entry, therefore it never joined up with anything. Once I removed the * and added to a new batch we could post. So the problem is solved, any thoughts on how or why that * was there?

Was this reply helpful? Yes No
Verified answer

Heather Roggeveen 9,146 on at

Like (0)

Report

Hi

Most likely an interruption to posting. It is relatively common to end up with orphan transactions in SOP.

This is most commonly noticed in one of two ways:

- Inventory shows that items are allocated to a Sales Transactions but that transaction was never finalised or is missing data.

- In the Sales Transaction Enquiry screen when looking at Open transactions you note transactions with no date or customer information - but there may be lines on the transaction. The transaction can't be selected in the Transaction Entry window and you get the message you encountered above.

In both of these cases, records need to be deleted from the tables and if inventory is involved, an inventory reconcile run once the deletions have happened. I have in the past tried check links or similar, but with no result. So now I just always sort from the tables.

Tables that I have had to update details on (not always all of them):

- SOP10100

- SOP10102

- SOP10105

- SOP10200

- SOP10203

Also check SY00500 for any batches that look funny. Batches in the "posting" status will not allow inventory reconcile to run. Check for batches with funny batch id's (a star in front, lower case letters). If there is a transaction count in those batches, check SOP10100, SOP10200 and SOP10500 for any documents with that batch ID. Delete the transactions in SOP tables before deleting the batch - or update as you did.

Hope that helps for further troubleshooting.

Cheers

Heather

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hi,

I am Facing the same issue. Can I pls know how did you remove the "*" from sales entry

thank you,

Shifan

Was this reply helpful? Yes No
Verified answer

L Vail 65,271 on at

Like (0)

Report

You need to do it via SQL. Edit the SY00500 table and type in a real BatchID replacing the "*".

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Very good points you wrote here..Great stuff...I think you've made some truly interesting points.Keep up the good work. I was looking for the solution of this exact same error.

Now I got it.

Thanks a lot.

Best Regards,

Mikey jon (Co-Founder @maketuto)

Was this reply helpful? Yes No