Dynamics Community Forum Thread Details

SOP Invoice Posting Issues

We had a server issue that interrupted the batch posting for invoices. After Checklinks and other routine maintenance all the invoices posted but one. It is showing as "open" in the RM20201 table and is also in the GL20000. However it is not in the SOP History tables and when i drill back from the Receivables Inquiry by Customer I get a message saying it has been removed from SOP History.

The Invoicing details are still sitting in the SOP Work Tables but they won't post. The latest issue is an Inventory allocation problem. I am running checklinks and recreating the fulfillment but I very much need this information in SOP History. We have multiple month end reconciliations and analysis based on these tables.

Has anyone had this before? if I delete this SOP Work and recreate it can I use the same SOP Number?

If I uncheck the Posting setup for Sales Transactions to the GL will it also interrupt the connection to the RM Tables?

Any thoughts would be appreciated.

Sandra

Hi,

If it's only showing in the RM20201 table, that seems odd. Was a payment received against this SOP document? If it's showing in the GL20000, that would mean it posted. Does the transaction exist in the RM20101 table? Can you, in fact, delete it from SOP? If it exists in the RM Open tables, you will not be able to use the same document number. If you uncheck the Posting setup for Sales Transactions to the GL, it will not interrupt the connection between SOP and RM.

When I run into this kind of situation, I search the database for the document number to see which tables/fields that number exists in. From those results, I can tell how far it got during posting and what kind of 'file surgery' I might have to do in order to correct the records. I use a free search tool called Apex Search, it's awesome - and free. Did this invoice have any sales tax, commissions or 'user defined' information attached to it?

Have you tried the SOP Reconcile - remove completed transactions? One thing you can do to move it to history is to edit certain database fields in the SOP10100 table so that the system would recognize it as a completed document. Still, I would wonder why it's not in the RM20101 table. Does it show up on the A/R aged trial balance?

Kind regards,

Leslie

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)