Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

EConnect Payable's Credit Memo

Posted on by 660

After a couple of weeks of frustration trying to get web services to work with GP 10 I decided to try eConnect. I was able to install it and get one of the sample apps to work that just creates a new customer. I'm looking for a example or an XML file to create a payables credit memo with GL distribution. I've looked through the documentation, googled and even looked at the stored procedures thinking I might be able to work backward but have not had any luck. Could anyone point me in the right direction?
Dean

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: EConnect Payable's Credit Memo

    Hi Dean,

    using eConnect we can generate Credit memo values from user tables or from excel values by providing the eConnect mandatory and default from the setup fields

    example code:-

    try

                {

                    eConnectType eConnect = new eConnectType();

                    PMTransactionType PayableTransaction = new PMTransactionType();

                    taPMTransactionInsert sp = new taPMTransactionInsert();

                    XmlSerializer serializer = new XmlSerializer(eConnect.GetType());

                    sp.VCHNUMWK = "00000000000000684";

                    sp.DOCTYPE = 5;   // for Credit memo generation                  

                    sp.BACHNUMB = "55";

                    sp.DOCDATE = Convert.ToString("06/12/2012");

                    sp.VENDORID = "ACETRAVE0001";

                    sp.DOCAMNT = Convert.ToDecimal(100.00);

     sp.MSCCHAMT = Convert.ToDecimal(5.00);

                    sp.PRCHAMNT = Convert.ToDecimal(100.00);

                    sp.TAXAMNT = Convert.ToDecimal(0.00);

                    sp.FRTAMNT = Convert.ToDecimal(0.00);

                    sp.TRDISAMT = Convert.ToDecimal(5.00);

            sp.CHRGAMNT = Convert.ToDecimal(100.00);

                    sp.CASHAMNT = Convert.ToDecimal(0.00);

                    sp.CHEKAMNT = Convert.ToDecimal(0.00);

                    sp.CRCRDAMT = Convert.ToDecimal(0.00);

                    sp.DISTKNAM = Convert.ToDecimal(0.00);

                    sp.DOCNUMBR = "8905501";

                    sp.SHIPMTHD = "TWO DAY";

                    sp.TAXSCHID = "COMPANYPUR";

                    PayableTransaction.taPMTransactionInsert = sp;

                    PMTransactionType[] MyPayableTransaction = { PayableTransaction };

                    eConnect.PMTransactionType = MyPayableTransaction;

                    FileStream fs = new FileStream(filename, FileMode.Create);

                    XmlTextWriter writer = new XmlTextWriter(fs, new UTF8Encoding());

                    serializer.Serialize(writer, eConnect);

                    writer.Close();

                }

    Thanks,

    Nataraj S

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: EConnect Payable's Credit Memo

    Hi Dean, not sure exactly what you want. Have you reviewed the XML schemas in the eConnect help files?

    Ian.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans