web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Would like to see a co...
Microsoft Dynamics GP (Archived)

Would like to see a code sample: Create SOP Sales Invoice in one function, apply a SOP Payment another function

(0) ShareShare
ReportReport
Posted on by Donald Ashworth 545

I'm pulling my hair out over here trying to get this to work.  Using C# I can create SOP Sales Invoices fine.  When I attempt to add a payment, I either create a new

taCreateSopPaymentInsertRecord_ItemsTaCreateSopPaymentInsertRecord  with (from what I can tell) absolutely no association to the invoice I am attempting to apply a payment |or| I receive an error from eConnect complaining about using a duplicate document number input.

Surely there is working code sample out there somewhere that demonstrates how to do this

I can post my code here, but I really do not think that would help.  I would much rather see something that works.

Frustrated and ready to punt.

Thanks to anyone who can give me a nudge in the right direction.

 

Don

 

 

 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Don,

    Not sure I can help - but:

    Are you trying to create a deposit on a sales invoice - or are you trying to create an RM Cash Receipt?

    If its an RM Cash Receipt - are you trying to apply it against the invoice? or do you just want to create the receipt - and manually apply afterwards?

    You would need to give us something to go on - can you post the exact eConnect error message you get when it complains about the duplicate document number.

    Ian.

  • Donald Ashworth Profile Picture
    Donald Ashworth 545 on at

    Hi Ian,

    Thank you very much for your fast reply.  Essentially, I've been tasked with working GP Invoicing into an online shopping cart.  Here are the broadstrokes of how it should work:

    1) User logs in and accesses available products/services that have GPItemType numbers associated with them.

    2) User chooses products and decides to check-out.  At this point I create can successfully create a SOP Sales

    Invoice using eConnect.

    3) The user then chooses his/her payment method.  Could be Authorize.NET or PaperCheck.  Either way, I do not apply the payment to the SOP Sales Invoice until it is confirmed.  With electronic payments, I can confirm and apply the payment immediatly.  With PaperCheck, we have to waiting until the check arrives in the mail and manually apply the payment (of which will be accomplished through an admin web page).

    4) The payment is applied to the SOP Sales Document using taCreateSopPaymentInsertRecord_ItemsTaCreateSopPaymentInsertRecord.  I am assuming this is correct because the RM transactions cannot be applied to SOP entities.

    5) At the end of the day, the Accounting group will POST the SOP Sales Batch and I am assuming when this is done, the associated SOP Payment transactions will also process too...since they are connected by their SOPNUMBE relationships.

    ** End the end, I need to link product sales to GPItemType numbers with unit pricing defined in GP.  Create Sales Invoices and apply payments to them, having the Invoice satisfied fully by its payment or not satisfied (not paid).  All of this needs to reflect correctly in the GP General Ledger.

    I would love to see a working example of the creation of an SOP Sales Invoice, then the creation of an SOP Payment towards that invoice.  Basically two steps.

    Any ideas where I might be able to find this?

    Thanks,

    Don

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans