Invoice Doesn't show for Applying payments

[Borvik]

I have the exact same problem as mentioned in the following thread:

http://www.tek-tips.com/viewthread.cfm?qid=670647

However - this thread doesn't provide an answer, so that doesn't help. Hopefully we can work towards a solution.

And to answer the first question of that thread - No it doesn't show up at all when query by Customer.

 

[barbola]

Check to make sure the invoice posted thru the GL and is not sitting there.

If not, then reconcile customer outstanding documents.

Thanks!
Barb E.

 

[Borvik]

Thanks for the response Barb!

How would I go about checking if it posted through the GL?

 

[barbola]

Look at your financial batches, and if there is one sitting there with SLSTE000xxxxx as the batch number, then you need to post it from there (or check Routines > Master Posting).

Also, you can go to sales > inquiry and check the Amount Remaining on this invoice to see if maybe it was applied already.

Thanks!
Barb E.

 

[Borvik]

Hmmm... I don't see any batches that follow the pattern SLSTE000xxxxx from though there are several SLSDP ones.

I can view the invoice - Amount Received: 0.00, On Account: $$$$$.

However the invoice doesn't appear when I goto Sales > Trx By Customer and enter the customer number (the CustNumb that GP is shown when viewing the invoice).

Gotta love Great Pains.

 

[Borvik]

The invoice is in SOP30200 so the invoice itself has been posted - would this be a cause?

 

[Borvik]

Well I think I may have found the error, but I'm not sure on how to correct it - maybe someone else has some ideas on it.

Anyway here's what it might be:

I do Checklinks followed by Reconciling every month. I look over the File Maintenance report and I notice the following - "A record for Invoice I00000xxxxx was removed from the {table} table; no corresponding record was found in the Sales Transaction Work table." (I00000xxxxx being the invoice I'm looking for).
I notice this on the report four times. Once where {table}=Sales Commisions Work and History, and three times where {table}=Sales Distribution Work and History.

Now of course it couldn't find the record in the Sales Transaction Work Table - it's over in SOP30200.

Any ideas on how to fix this?

 

[barbola]

Did u reconcile the customer information? Also check to see if the transaction posted to the general ledger (check the accounts).

As for your checklinks errors, I'm not sure - I don't encounter many errors here but that's probly cuz I don't run it as often as I should.

That SLSDP batch should probably be posted.

Thanks!
Barb E.

 

[Borvik]

Well, the checklinks problem(if it is a problem) may be the cause of this problem - as it deleted several records for the Invoice in question.

As for reconciling customer information - nope I just did Utilities > Sales > Sale Doc Utilities. Should probably add Utilities > Sales > Reconcile to my list to do. I'm not sure if it posted to the GL, I don't think it did - but I'll ask around.

 

[Borvik]

Ok - I found that there were two invoices that this was happening for and neither of them posted to the GL.

We're thinking that we can just delete these - and then create an invoice to apply the payments to them.

 

[barbola]

If the invoices were partially posted on the RM side, you probably should find out how far they were posted, and then enter returns or void them.

Make sure posting is turned off when you do this.



Thanks!
Barb E.