Skip to main content

Notifications

Announcements

No record found.

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

  • Suggested answer
    jbakach Profile Picture
    jbakach 85 on at
    RE: Automate Cash Receipts

    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.

  • Bsimon-AT Profile Picture
    Bsimon-AT 15 on at
    RE: Automate Cash Receipts

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

  • Bsimon-AT Profile Picture
    Bsimon-AT 15 on at
    RE: Automate Cash Receipts

    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?

  • Suggested answer
    jbakach Profile Picture
    jbakach 85 on at
    RE: Automate Cash Receipts

    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
    Bsimon-AT 15 on at
    RE: Automate Cash Receipts

    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

  • jbakach Profile Picture
    jbakach 85 on at
    RE: Automate Cash Receipts

    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

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans