Creating SOP Payment in GP

[Karen Porter]

I'm at my wit's end here. I am attempting to create aSOP Payment in GPand apply it to a SOP Sales Invoice (that has not been posted yet). The Sales Invoice was created earlier in the map and I can see it in GP. I would like to then create a cash payment and apply it.

I am using the SQL Server Connector and then attempting to execute the stored procedure taCreateSopPaymentInsertRecord. I've tried this with an Action of 1 (new payment) and I continually get an error of "The given key was not present in the dictionary." I have looked in the scribe agent log files and the SQL Profiler. It appears it has to do with the SOPNUMBE but whether I supply it or not in the block, I cannot get this to work.

Does anyone have any insight how to get this to work using the stored procedure There really isn't another option because this entity does not exist in the GP Connector.

[Stella Dimitriou]

Hello!

We just went through this on a recent project integratinga POS system to GP. I have been working with Scribe the past few years and most recently, worked with our outside GP VAR to develop integrations to GP using the SOP nodes.

We tried to bring in the payments with the SOP invoices but couldn't get it to work. We also tried to bring in the payments in the SOP invoice separately but that didn't work either (even though our VAR said he could absolutely make it work).

Our workaround is to bring in the payments as cash receipts (Sales...Transactions...Cash Receipts)and then run a separateScribe job to apply the payments to the SOP inovices. Both invoices and cash receipts need to be posted before we can run the Apply Scribe job so we scheduled the Apply job to run after the invoices and cash receipts are manually posted by end users.

There is also a 3rd part add-on called SmartPost by eOne Solutions that will post the batches automatically but we haven't deployed this tool yet.

Hope this helps.

Stella