Skip to Content
author's profile photo
Former Member

Deduction on Customers Accounts Payments

I dont know much about finance related reporting. I have to work upon the report of customers that take similar deductions on their account payments, such as for sales tax, freight or a percentage of the invoice.

There is a $50 tolerance level for USD and the reporting needs to identify by invoice and customer when a deduction under this tolerance level is taken.

Can anybody help me out in understanding the above.

Thanks in advance.

Kartavya

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Oct 11, 2007 at 04:42 PM

    OK In Finance you will create an automatic account determination for roundings and write offs. This is where the difference is being posted to.

    You need to display that GL account and there is a field called offsetting account and type

    Where the type = "D" for customer the account will be the customer account number

    This can then be sub totalled to show the total amount taken by Customer.

    If you want to see the invoices, there is a payment usage option in environment where the invoice number (accounting document number) can be found.

    Hope this helps Award points if useful.

    Add comment
    10|10000 characters needed characters exceeded