Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Sue Barrett]

Does anyone know if it is possible to get the Payment Method balancing functionality working in a Sales Journal?

It works if I create and post a Sales Invoice – and the credit to Sales Ledger Control and debit to the balancing account post perfectly.
We don’t want to produce a Sales Invoice however; as this is a cash collection from a Customer so no invoice is necessary.

Basically we need to create Customer Ledger Entries for historical reporting – and also create the following G/L entries;

Credit – Sales
Credit – Sales Tax
Debit – Sales Ledger Control
Credit – Sales Ledger Control
Debit – Collection Debtors

The Collection Debtors G/L Account is then cleared out on a General Journal when the cash is deposited to the bank.

It seems that the balancing account on a Payment Method would work perfectly – but it doesn’t create the balancing entries on a Sales Journal.

Any ideas?

——————————
ES Barrett
NAV Project Manager
Sudbury
——————————

[David Wiser]

Sounds like it will need to be a customization.  I was able to add the Payment Method Code to the Sales Journal. Populated the sales journal line with a payment method which had a balancing account and posted.  Unfortunately, it only posted the sales line and didn’t trigger the settlement using the payment method code.  You’ll need to talk with your partner.

——————————
Dave Wiser
Controller
Beckwith & Kuffel
Seattle WA
——————————
——————————————-

[Kim Dallefeld]

Dave is right! Its unfortunate that the journal functions differently.

——————————
Kim Dallefeld
NAV Consultant
Past NAVUG Chair
NAVUG Programming Committee
Ft Worth, TX
Kim@Dallefeld.com
——————————
——————————————-

[Sue Barrett]

Thank you all for your feedback.
I had thought as much but figured if anyone knew how to do this – you guys & gals would 🙂

——————————
ES Barrett
NAV Project Manager
Sudbury
——————————
——————————————-