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

[Tammy Chavez]

Good morning,

I am wondering if there is a way to automate the write off for cash receipts processed through LockBox and applying over Payments to a different GL account?

My transaction will look like this

Customer # 1234 – Check Number 12345 – Date 5/2/17 – Payment Amount $79.68 – Invoice # 123456 – Invoice Amount $85.92 – Write off $6.24 

Customer # 1234 – Check Number 12345 – Date 5/2/17 – Payment Amount $5.63 – Invoice # 123456 
Payment #2 amount $5.63 (this is a GRT payment that needs to be applied to a different GL)

I can’t see any way to do this through the import.  I think I may just need to do this adjustment after it imports and during review.  

Thank you in advance,

——————————
Tammy Chavez
Senior Software Consultant
LightHouse Business Information Solutions, LLC.
Albuquerque NM
——————————

[David Joosten]

Hi,
In sales routones, there is an option to write off documents. This allows you to select write off for a range of customers and for a limited amount with a document cut off date. The GL code used will be the write off account specified on the debtor, so it will be complex to change the GL account unless you setup a fixed reallocation account in the GL, set all the debtors to use the reallocation account for write off. You can then set the reallocation to the underpayment account and run the write off, then change the allocation to the overpayment account and run the write off for the overpayments.

Regards,

——————————
David Joosten
Enterprise Architect
Premier FMCG (Pty) Ltd
Waterfall City
——————————
——————————————-