Does 'lock unit price' create a GL transaction

Epicor ERP 10
1

When you enter a discount% on a Sales Order Line there’s an associated GL Transaction.

Does ‘lock unit price’ have an associated GL Transaction?

2

NO - I do not believe so

3

thanks, I didn’t think it did as I was testing, but wanted to double check

4

I think @amaragni is correct. We use it on “sample” orders and I’ve never seen a GL Transaction for it. But that said, I’ve not really looked for one either.

5

Could you help clarify your testing scenario you are doing with locked unit pricing that does not have GL transactions? We have orders that have locked unit price (OrderDtl.LockPrice) that do have GL transactions when viewing in AR Invoice Tracker in the GL transactions tab. Or does your scenario include a discount% plus lock unit price where you are seeing no GL transactions?

6

“Lock Unit Price”, according to the System Help, is not affected by Discount (probably because the Unit Price itself is not changing). The items are still being shown as $XX per unit, but then a discount is applied. That is logically different from reducing the unit price by the discount rate and THEN creating a total.

7

Could you provide your testing scenario for us to try to duplicate?

8

. I manually entered a unit price on a line item and saved the order. Then I changed the quantity and saved; the price stayed the same. Then I changed the ship to on the order; the price stayed the same.

~;)Karen

9

How did you ship and invoice the order line to not see the GL transactions? What were your steps after changing the price on the order that you noticed no GL transactions?

10

Using this process of changing the unit price and locking the unit price, what would make you think no GL transactions should be created? How does locking the unit price impact whether or not a GL transaction is created or not?

11

Locking the price might change what is posted but not when. Transactions happen at shipment and at invoicing and their related activities.

The question is, what makes you think there are transactions posted? An easy test is to get the system to yourself (Pilot preferably):

  • Run a General Ledger with details for the day
  • Lock Unit Price on an order
  • Rerun the General Ledger with details for the day

If they are the same, then no postings occurred.

Mark W.

12

So is the original question for before posting or after? I was under the understanding from the original question that the GL transactions weren’t being created after posting if you lock unit price.

13

When I tested your scenario and changed the order qty after unit price locked, the order total price reflected the new order qty at the same price. When you mentioned “priced stayed the same” are you referring to the line’s unit price or the order total? Why would the unit price be affected by a change in order quantity regardless of unit price locked?

14

I was referring to the unit price.

The unit price might change due to price lists, that was the case with the part I was testing with. Before I manually changed the unit price on the line the price shown was calculated by a price list.

We’ve been seeing orders where we wanted to give the customer a better price for whatever reason, but when we changed the ship to or the order quantity, the unit price reverted to the calculated/price list price.

~;)Karen

15

So after you made your changes, did you ship and post the order and that is when you were not seeing the GL transactions? Are you not seeing the GL transactions before or after posting?

16

Makes sense since I was probably using a configured part without an attached price list. I’ll have to do more testing but still trying to get to the original question if GL transactions are created in these scenarios.

17

you have to check the override price list box I believe.
and again - there is NO accounting transaction associated with changing the price on a sales order

18

Could you help clarify this? Are you saying that once you change the unit price on a sales order line, ship it, post and invoice it, there are no GL transactions for that shipment? Or are you saying there is no impact to accounting transactions with changing the price?

19

Sure. Simply put
*** There is no impact to GL Book or Accounting transactions generated when sinmply changing the sales order unit price. ***

Accounting is ONLY affected when a sales order is shipped and invoiced - at which point the SALES evaluation is made using the unit price.
Even so, if the sales unit price is subsequently changed; still, NOTHING happens to the GL

Unless and Until the sales order is possibly shipped and invoiced again - At which point the SALES evaluation is made again

*** Now just to muddy the waters, I will include the fact that there is a feature called SALES BOOKINGS feature. Sales Booking ARE affected by changing the sales unit price - without shipment or invoicing.

However

  • SALES BOOKINGS ARE NOT RELATED TO OR POSTED TO ANY GL ACCOUNT
  • The Sales “bookings” is initially disabled. (it may even be a chargeable feature IDK)
  • The Sales “bookings” feature keeps a non-financial running total of sales value change by date.
  • Set ON using Company Config/Sales/Order/“BOOK SALES ORDERS”
  • I don’t even believe there is a standard Sales Bookings Report
  • Sales “bookings” are simply a measure of incoming order activity.

Sales bookings answers the sales manager question of “How much did we SELL (not ship) this week?”

There’s a difference, right.

1 Like
20

Thanks for the clarification. Helps clarify that there are still GL accounts being hit at the time of posting and invoicing and not prior. I was under the impression no GL accounts were being hit after posting when changing a unit price.