Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Credit Cards Payments for Customer Orders/Invoices

(0) ShareShare
ReportReport
Posted on by 18

I have a customer who is currently using Dynamics GP for Sales Orders and here is the process.

They sell and item for $15.00, but they need $5.00 to go to an Amazon liability and $2.00 to go to Shipping liability with the rest to be paid by the amount that is on the invoice.  The sale invoice needs to remain at the $15.00, but we need some sort of clearing type account or something for the other amounts.  The order is fully paid when it is entered we just need those amounts to hit another account.  I could use a payment method to post to one liability, but I can't use two payment methods.

What they do today in Dynamics GP is they enter two credit card payments to different credit cards which have different clearing accounts attached.  So essentially they enter 3 payments for each order/invoice one to credit card A for Amazon clearing, one for credit card B for shipping clearing and then credit card C for the rest of the amount which hits the cash account when posted.

The other two entries are not paid until 2 weeks later when Amazon sends a payment which they just enter a G/L entry to clear the clearing account.

Any idea to replicate this in BC?  I thought of prepayments, but I am not sure that would work.

Any help is greatly appreciated.

Tanya

  • Suggested answer
    AriaConsulting Profile Picture
    2 on at
    RE: Credit Cards Payments for Customer Orders/Invoices

    There are also some ISV solutions that may offer part or all of what is needed (you will need to investigate with them directly):

    appsource.microsoft.com/.../TYPE.connect|PUBID.folio3-dynamics-services|AID.amazon-connector-dynamics-business-central|PAPPID.00000000-0000-0000-0000-000000000000

    appsource.microsoft.com/.../PUBID.suite_engine|AID.csmforamazon|PAPPID.c687e311-128c-40f6-b9cf-2d987961b7cf

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Credit Cards Payments for Customer Orders/Invoices

    Tanya,

    Ugly one. I like Josh's idea to create a recurring entry to meet the requirement but in the end, I might as well do an extension that actually performs the above entries and posting when I flag the Order based on a specific Payment Method.

    It is rather simple based on the Payment Method to perform the additional transactions during the posting process so you get:

    Payment Method = AMZ =

    Revenue - ($8.00)

    Amazon - ($5.00)

    Shipping - ($2.00)

    AR - $15.00

    It will make the customer happy and streamline the posting process.

    Just a thought.

    Thanks,

    Steve

  • Suggested answer
    JAngle Profile Picture
    89 on at
    RE: Credit Cards Payments for Customer Orders/Invoices

    Is the distribution to the other accounts weighted by a percentage? If so maybe using your initial payment method idea is appropriate. You move the whole amount but then have a recurring general journal that takes a percentage from account and moves it to the other liability accounts. Some work needed for it to balance. Maybe the initial payment goes into a special holding account and then you redistribute. To automate the journal posting you could try this idea: joshanglesea.wordpress.com/.../

    Just have the frequency more often

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
YUN ZHU Profile Picture

YUN ZHU 374 Super User 2025 Season 1

#2
Mansi Soni Profile Picture

Mansi Soni 247

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 231 Most Valuable Professional

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans