You’re offline. This is a read only version of the page.
We've been having a odd issue with item pricing on sales transaction entries.
What makes the problem particularly odd is that it appears to be localized to certain items and certain users.
When some users are logged on and entering sales transactions certain item numbers (usually older items) populate odd pricing (either an old/outdated cost of goods amount or a retail amount (when it should be wholesale)).
For other users the pricing on the same items (and all other items) is fine.
Not sure if this is a item setup or user access/role/permission issue (or some strange combination).
Any help would be greatly appreciated!
*This post is locked for comments
Hi Tami,
I'm mostly repying to Heidi who's having a recaclulated unit price. She inputs 125 and GP recaluclates 125.01. is there a way to be able to input the unit price withtout a recalculation ?
we have different pricing depending on customer class and price levels...another place to check would be the customer cards
Have you found a solution to your problem Heidi?
I have a question related to this --
A customer has their functional and reporting currency set up as Canadian dollars. They have many customers in the US, and we recently got the Multicurrency exchange rates/tables to work when doing basic entries (yes, all the appropriate access, rates, etc work). But, when doing a Sales Transaction Entry for an item that has a price list, but not a default PRICE....it messes with us.
For example: A service item (not tangible item) set up in Inventory, has one price list, and two lines, one for CAD and one for USD.
If we enter a US dollar transaction: quantity of 1 hour at $125 US, as soon as we tab off, the system changes the item price to be $125.01. The only way we can make it stay $125 is to update the price list to be $125 and then it stays $125. However, not all of their customers get the rate of $125. Why can't we just enter the item at $125 and have GP leave it? If we enter $124.99 as the unit price on the transaction, it stays $124.99, but when we enter $125 as the unit price it rounds it up to $125.01 because of the exchange rate table.
Why would GP do this?
Let me make an assumption that you are not using extended pricing though that module would not be affected by access/role/permission either.
I'd say no connection to access/role/permission.
The pricing defaults for SOP Entry would drive from the customer card so it might be that the reason it seems certain users get different pricing is due to them entering orders for a set of customers they work with that others don't that have a different default level. I'd first look on the customer card for the price level and see what defaults from there. If that one is blank or is missing from the Item Price window, then I believe GP will pull price from the default item price level on the Item Price window. Point being if you have RETAIL on the customer but no retail price level on the item, the item will pull its own default level. Somewhere between those default price levels should be the reason you pull a different price for the same item.
If that does not resolve it I would look at Currency to see if you have multiple currency's set up such as USD and Z-US$ such that two currencies you see as the same have different prices per item price levels.
As to cost, GP would display last cost or standard cost from the Item Card as an informational field and then calculate actual cost based on your inventory method when you post. Point being, you won't be able to look at a line in SOP Entry and know what the exact cost is (standard cost being an exception) by looking at the line window even after you post.
So, don't know..... but here's some things to look at.
Best
Tim
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (