Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Credit Card Payment Method

(0) ShareShare
ReportReport
Posted on by 1,753

We are using the newer feature in GP to process a credit card batch.  So for this case we have a credit card setup that is for vendors only.  Everything about the process works perfectly in TWO for this install and we have setup and working in a test environment on our machine that works perfectly as well.  In the clients live database we have an issue on the Batch Entry window.  We put in the batch id, choose Computer checks, select Credit Card.  At that time the Checkbook ID field goes away and the credit card id field shows us.  All good to this point.  We select the credit card id and hit save.  Batch id goes away if we either close the window or just reclick on batch id lookup and reselect our batch, things go awry.  The batch id, batch origin - computer check and payment method - credit card are all fine.  However there is a glaring issue in that it shows Checkbook id and is populated with our default checkbook.  It does not show credit card id field and our selection there. 

8311.Untitled2.png

Notice no dots before or after the window - there are no customizations.  We are on 16.00.0439RTM.  But the kicker is if i log into Fabrikam it works fine as same user with same security in each company.

6648.Untitled1.png

The one thing i notice is that in TWO the card name is all greyed out.  The checkbook id on the live company is not greyed out - like you can still change and select.  Can even still change the Payment Method and get the credit card window option back and re-select but is not saving the batch.....

I have compared setup for company, company options, gl, and AP - nothing is sticking out.

Compared security, looked at customization mtce to double check no customs on the window.

Happens on multiple workstations.  All i know to do at this point is a sql and dexsql log.

*This post is locked for comments

  • Robyn Profile Picture
    Robyn 1,753 on at
    RE: Credit Card Payment Method

    First date in the query is the GL Post Date.  For TWO it is set to post date by batch.  Live company posts by transaction, so that makes sense.  Have not yet found the currency setting that gets that written to the batch but i doubt it is the issue.

  • Robyn Profile Picture
    Robyn 1,753 on at
    RE: Credit Card Payment Method

    Sorry meant to say...

    Ran a SQL trace today and the only thing i am finding different between the two is first date field, MC, checkbook id in this statement and then this extra call in Live.  This is all on saving of the batch.

  • Robyn Profile Picture
    Robyn 1,753 on at
    RE: Credit Card Payment Method

    Platinum.JPG

    Above is my live company.

    Here is TWO

    Platinum.JPG

    All looks good to me.  We are not using this card for customers so it is not checked in live but that should not have an affect on this.

    I have also compared these two vendor setups.

    Both get cash account from checkbook.  Neither have a default checkbook setup on the options window.

     

    Ran a SQL trace today and the only thing i am finding different between the two is MC and this call.

    FABRIKAM

    /*  Date: 03/07/2017  Time: 18:41:38

    stmt(142101960):*/

    BEGIN DECLARE @num int EXEC TWO.dbo.zDP_SY00500SI '2017.04.12', 'XPM_Cchecks', '245G', 4, 0, 0, 0, 0, 0, 1, '1900.01.01', 0, '', 0, 0, 0, '',

    '', 0.00000, 0x00000000, 0x00000000, '1900.01.01', '', '', 0, '1900.01.01', '2017.03.07', 213.00000,

    'Z-US$', 0, 0, 0.00000, 0, 0, '1900.01.01', '', 2, 0, 0x00000000, '1900.01.01', 0, 0, 0, 0, '', 2, 0, 0, 0, 9, '18:41:33', 0, 0, 'Platinum Credit', @num OUT SELECT @num END

    LIVE:

    BEGIN DECLARE @num int EXEC CSOKI.dbo.zDP_SY00500SI '1900.01.01', 'XPM_Cchecks', '2344', 4, 0, 0, 0, 0, 0, 1, '1900.01.01', 0, '', 0, 0, 0, '',

    'GEN OP', 0.00000, 0x00000000, 0x00000000, '1900.01.01', '', '', 0, '1900.01.01', '2017.03.07', 28663012.00000,

    '', 0, 0, 0.00000, 0, 0, '1900.01.01', '', 2, 0, 0x00000000, '1900.01.01', 0, 0, 0, 0, '', 2, 0, 0, 0, 9, '18:38:58', 0, 0, 'RGL', @num OUT SELECT @num END

     

    Live trace has this and TWO does not.    That is Module ID's Master....  Forms in each module - no idea what that is about.

     

    /*  Date: 03/07/2017  Time: 18:39:05

    stmt(142113832):*/

    { CALL DYNAMICS.dbo.zDP_SY05100SS_1 ( 222 ) }


  • KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: Credit Card Payment Method

    Robyn,

    Have you compared the Credit Card Setup window between Fabrikam and your live company? I want to say the window I am thinking of is MS Dynamics GP, Setup, Company, Credit Cards.

    Regards,

    Kirk

  • Sherry Whitten Profile Picture
    Sherry Whitten 329 on at
    RE: Credit Card Payment Method

    I work with Robyn.  One additional thing we notice....   In the SY00500 (batch) table for TWO, which seems to be working properly, the checkbkid is NOT populated when we save the batch; the cardname field IS populated.  For the live company, both the checkbkid and cardname fields are populated; in the dex sql log, we can see it write the checkbkid to the sy00500 for the live company.  This should not happen; what could be different between the two companies to cause this?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans