Questions Processing line level discounts and GL coding
To begin, I don't have much experience with discounts in Acumatica. Up until now, we have done everything with item pricing.
Businesses Issue: Track freight discounts given to customers on the GL.
Scenario: A customer places an order for a product and we incur costs to ship the goods. Acumatica is tied to UPS so the system gets the cost automatically and records it. It also adds a freight charge to the invoice. For a large number of orders, they do not charge for shipping. However, the customer wants to record the revenue they would have earned for shipping and process a discount for 100% of the freight. This way the customer knows they receive free freight. The customer wants the discount to be recorded to a freight discount account so they can track discounts given on the GL.
Issue: I ran a test of a sales order. On it I added a regular item and a non-stock item called freight. I then created a line level discount code that applies to the item freight and applied it to the freight line on my order. So far, so good. The invoice prints with a line for freight with the proper charge amount and an extended amount of $0. However, the GL batch created for the line posts a net $0 to the sales account for the Freight item, not the full amount.
Question: Is there a way to have the discount post to another account?
Great to see you on the AUG Forums.
As far as I understand it, a Discount Code with a Discount Type of Line only impacts the Ext. Price field on the Document Details tab of the Sales Orders screen and the entire amount in the Ext. Price field (0 in your case) gets booked to whatever GL Account is in the Account field on the Document Details tab of the Sales Orders screen.
However, if you use a Discount Code with a Discount Type of Group, then I think you can achieve what you're looking for.
Here I have a Discount Code with a Discount Type of Group and an Applicable To value of Item:
Then, I create a Discount under that Discount Code with a Discount Percent of 100...
... and I list a Non-Stock Item on the Items tab (I was lazy and used ADMCHARG, but you would list your Freight Non-Stock Item here):
Then, I create a Sales Order that uses my Non-Stock Item without any Line Discounts:
But I add my Group Discount to the Discount Details tab:
When you post the Invoice, the journal entry looks like this:
Note that the 49000 account above comes from the Discount Account field on the GL Accounts tab of the Customers screen which defaults from the Discount Account field on the GL Accounts tab of the Customer Classes screen.
All that being said, I don't understand how using a Non-Stock Item would help you here. Won't the freight get double-booked since you are letting the freight line get generated automatically on the invoice based on the freight cost and the shipping terms?
Would it be better to ditch discounts altogether and put a negative Unit Price on your Non-Stock Line with whatever GL Account you want like this:
Then the journal entry generated by posting the Invoice would look like this:
Hi Tim and Shawn,
I have a use case where the client wants to book discount to a different GL code depending on the discount code used. This currently does not seem possible as the Order Type screen allows to use discount GL from the Customer Location or from the Order Type, but no option to use the GL code from the Discount Code itself. Neither does the Discount Code screen allow to enter a GL code there.
I suppose this could be achieved through a customization.
I wanted to see if you would have any other ideas instead of going the customization route?
I can't think of one unfortunately. Sounds like a customization to me.