150
When posting a sales invoice, it adds a customer ledger entry with the payment method code selected. Is it possible to do this with two different payments? (So there would be a total of 3 customer ledger entries connect to the invoice instead of 2.)
If not, is it possible to do this with AL?
If the invoice is not posted the payments will just sit on the ledger. You will need a routine that does the application. For that you will need to work with the detailed customer ledger entries. Manually apply a payment to an invoice and you will see how the entries look. You can then create a routine that does that on mass. Be sure to add permissions in the object as inserting/modifying the mentioned table directly is not possible otherwise.
From the sales invoice you could create a drill down from the payment method field to generate line data for multiple payment methods and the expected value for each which should be equal to the total. You could use the deferral line schedule table and page as a template for the concept. After that do you need a routine that references this? If your receipting cash does it need to know about this schedule or does this detail need printing on an invoice document? Not knowing the full story makes it harder to realise the boundaries of the request.
Basically I am trying to create an app that accepts payments made directly at the sales invoice (before it's posted).
Normally, BC adds a customer ledger entry for the payment method selected when posting. However, I want to make a split payment between multiple payment methods. Since this is an app it would be done with AL, so I'm trying to find a simple (or the simplest) way to apply payments to the invoice with AL when it's posted.
What is the practical reason for needing this? Cash being received doesn’t necessarily need that recorded. Plus the payment method field is editable on the customer ledger entries. If you were to use something like the payment reconciliation journal where you import a bank statement it will allow multiple applications. Or if an invoice has a remaining balance you can apply accordingly. For instance you might do a payment reconciliation for a PayPal account statement and then for the business bank account where you get bank transfers or cheques.
If you need to break up the customer ledger entry then AL could be an option
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
