SalesPad Posting Invoices in GP 3 records failed

(0) Share

Report

Posted on by CTUSA

We have Dynamics GP 2013 and SalesPad.. The problem we have right now is after running the SalesPad Batch process called 'Posting Invoices in GP', three records (2 invoices and one RMA) did not go successfully to GP (the reason might be those records were still open by some user, when the batch process was ran)

When we check the records in SalesPad - -- Sales Dcocument, .-> Dcoument number Invoice, -> put the Invoice number, it shows 2 rows i.e. History and as well as ‘Open’, while the good ones show just ‘History’.

So what is the fix. We do pay for yearly support with SalesPad.com but they told that the y can not give us a fix and we have to get GP support and the company has financial constraints. SalesPad.com did give me a script to run against the database to find duplicate records. While that is nice to because confirms those records but hope someone can give me steps to fix this.

Categories:

Microsoft Dynamics GP

All responses (9)

Answers (0)

Tim Wappat 5,703 on at

Like (0)

Report

RE: SalesPad Posting Invoices in GP 3 records failed

You might find this interesting too https://community.dynamics.com/gp/b/dynamicsgp/posts/troubleshooting-sop-invoices-that-are-in-both-work-and-history

I have the feeling this is the same as what you will have been given in script form from SalesPad.
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: SalesPad Posting Invoices in GP 3 records failed

Tools->Utilities->Inventory->Reconcile. Do this while no one is in GP. I always direct the output to a text file for later review. Who knows what else it will correct. Performing a backup is a good idea as well.
CTUSA 15 on at

Like (0)

Report

RE: SalesPad Posting Invoices in GP 3 records failed

Thanks again,

Is the IV Reconcile run from Financial - Reconcile to GL and then pick the Module drop down to Inventory?

I do not see any other so called 'PSTL' tool installed.

Thanks,
Richard Wheeler 75,848 Moderator on at

Like (1)

Report

RE: SalesPad Posting Invoices in GP 3 records failed

OK, so there a duplicate record problem. Something went wrong during posting. Before you do anything perform a backup. You can do an inline backup using

SELECT *

INTO SOP10100_2019_10_01

FROM SOP10100

GO

SELECT *

INTO SOP10200_2019_10_01

FROM SOP10200

GO

Then

DELETE SOP10100 WHERE SOPNUMBE='INV016360' AND SOPTYPE=3

GO

DELETE SOP10200 WHERE SOPNUMBE='INV016360' AND SOPTYPE=3

GO

Do this for the other two documents as well. When done run IV Reconcile.
CTUSA 15 on at

Like (0)

Report

RE: SalesPad Posting Invoices in GP 3 records failed

Hi Richard,

Thanks again. yes they do appear - as per screen shot below. Where will I delete these records? Is there a script for those or there is a navigation in GP to find the 'Open' table and the records therein, to subsequently delete them.?
Richard Wheeler 75,848 Moderator on at

Like (1)

Report

RE: SalesPad Posting Invoices in GP 3 records failed

Try something like this for each one:

SELECT * FROM SOP10100 WHERE SOPNUMBE='INV016360' AND SOPTYPE=3

SELECT * FROM SOP30200 WHERE SOPNUMBE='INV016360' AND SOPTYPE=3

Does it find a record in each table? If it does, do the corresponding records in SOP10200 and SOP30300 match?. If they are the same then the records did make it into sales order history. You could delete these records from the open tables. You will want to run IV Reconcile after any deletions. Make sure you perform a backup before doing anything.
CTUSA 15 on at

Like (0)

Report

RE: SalesPad Posting Invoices in GP 3 records failed

Hi Richard, I just used the 'reconcile' against one record i.e. Inv016360 but no change. The SOP #s are:

1. INV016360

2.INV016482

3.RMAI002174

SOP type is 3 and ORIGTYPE is 2 for all of these.

Thank you.
CTUSA 15 on at

Like (0)

Report

RE: SalesPad Posting Invoices in GP 3 records failed

Hi Richard,

Thank you for your comments/suggestions. Yes, you are correct, while they (salespad.net) giving us some sugestions/pointers etc. but they are not really owning up to take up the issue completely. I will go over the steps as per your suggestion and will elt you know.

Thanks
Richard Wheeler 75,848 Moderator on at

Like (1)

Report

RE: SalesPad Posting Invoices in GP 3 records failed

It sounds like SalesPad is saying this is not their problem. You could try Tools->Utilities->Sales->Reconcile ->Remove Documents. Hopefully this will these documents into history. If this does not work let us know the sop document numbers and we can send over some scripts to help investigate.