web
You’re offline. This is a read only version of the page.
close
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

Automate Cash Receipts

(0) ShareShare
ReportReport
Posted on by 15

We are trying to automate processing of web orders.  The website does not (and will not) connect directly to BC.  

We need to create an app / extension, or whatever is best to apply the payments that were successfully processed by the CC company into BC.

A Dynamics 365 licensed partner has shown me how to do this manually in the UI, here is what I was shown:

  • From the Sales Order, put in 100% for prepayment
  • Post Prepayment Invoice
  • Open Cash Receipt Journal
    • Add payment: Doc No: (PO Number), Acct Type, CUST, Bal Type: BANK ACCOUNT
    • Hit Process -> Apply Entries
      • Go to Proper Invoice #, enter the PO number into 'Applies-to-ID'
      • Click OK
    • Click Post/Print -> Post
  • Open Sales Order -> Post sales order

The Apply Entries is the problem.  We have all of the data needed to apply the payment.

How can I automate that?

We are capable of doing whatever we need to coding wise. We can use

  • C# / Web References
  • Custom AL Code Web Services - Called by C#

We have been working with both of these, and are getting tripped up by the section where we have to apply entries from the cash receipts.

Is there another way we can do this?

How do other companies automate this?  

Thanks in advance for any suggestions

Brad

I have the same question (0)
  • jbakach Profile Picture
    85 on at

    Hi,

    You need to develop an extension in BC (with public Codeunit procedures) an make SOAP WS calls from C# into NAV, there is no other way to achieve that.

    Best regards,

    JB

  • Bsimon-AT Profile Picture
    15 on at

    I guess I need to be more specific.  We have been trying to develop BOTH a C#  / Web Reference or an Extension.  We are having problems automating the section that "applies entries" to the payment

  • Suggested answer
    jbakach Profile Picture
    85 on at

    Applies-To-Id is used to mark a document through a Window. You should use Applies-to Doc. Type and Applies-to Doc. No.

    In that order.

  • Bsimon-AT Profile Picture
    15 on at

    This looks like what I needed.  I am waiting to hear back from our 365 partner about a possible setup problem.  It appears we are close.  I know how to post a shipper and invoice through code.  Is there a difference to post this entry?

  • Bsimon-AT Profile Picture
    15 on at

    Unfortunately, I am still missing something.  The payments are not getting applied properly to the pre-paid invoice or sales order.

  • Suggested answer
    jbakach Profile Picture
    85 on at

    Sorry, but for the case, I suggest you to let your partner or another one do the customization. There are some things that have to be done in a way, and I can't pretend to tell you with detail the whole solution. You will need to investigate or let your partner or another one do this thing.

    Look with GUI how the post is done, look which codeunits are used, tables, or anything to understand well how has to be done. But you need to have some functional skills to achieve that.

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…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,468

#2
YUN ZHU Profile Picture

YUN ZHU 923 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans