Hi,
We have set up the AR control accounts with payment discounts for specific GL accounts, and are using the % discount on the OE invoice total screen. The numbers and the process to give a customer a (say) 10% discount works fine.

Say $1000 invoice base excluding taxes calculates the discount as 10% or $100, and the customer is invoiced for $900. Perfect.

But for accounting, we want to see the discount amount reported as $100 in our GL. We run our OE end of day with GL accounts displayed and all we see is the net of $900. We post to AR and all we see is $900.

We open the OE Header table with Gridview, and we see the $100 as the discount amount and we see the GL account for payment discounts from AR showing as the discount GL account (with dept). So, we know that the discount was calculated and distribution is retained on the order.

How do we get the discount amount that is already calculated and retained on the invoiced order with the GL accounts, to be included and reported properly, for accounting purposes in Order Entry?

We will be upgrading to OE 9.3A soon, but didn't see that GL distribution change for discounts in the release notes.

Thanks,
Brian

Hi Brian

The AR control account payment discount field only comes into play on the AR cash receipt screen. That is a payment discount.

What you are referring to on the OE Totals screen is a sales discount, not a payment discount. The GL accounts that are affected by a sales discount are the sales accounts (per the inventory category or miscellaneous charge).

Steve

Brian:

I don't believe that Adagio has a means to account for "Sales Discounts" by debiting an account in GL. Adagio nets the selling price and credits the net amount to the sales account from the items category code.

But why would the GL accounts and actual discount amounts for the discount be in the OE header from the Invoice totals screen.

I get that the discount field in AR would be using the GL accounts for the discounts for payments in Cash Receipts, but it looks like the discount information is also in the header of OE invoices and just doesn't go anywhere.

Our client for this question, doesn't do cash receipts discounts but does offer order discounts, and wants to track the discounts separately instead of just netting against gross sales amounts.

Thanks,
Brian