You’re offline. This is a read only version of the page.
680
We have an interesting issue.
On the Invoice Entry window we are able to add line items for both Inventory Non-Inventory items as expected. However, when we open the Distributions window, the amounts are being rounded to zero decimal places on both the Debit and Credit columns -- BUT the totals are correctly displaying the cents.
If we delete the distributions and click Default, the amounts all DOUBLE. If we click Default again the amounts TRIPLE. The amounts increase by the same amount with each click of the Default button.
This issue extends all the way to the GL -- when printing a Detail Trial Balance, the same issue presents itself. For the GL distributions associated with those sales line items, the debits and credits show zero decimals, but the totals correctly show 2 decimals.
I've reviewed the setup for Financial, Sales, Inventory and all indicate 0 decimals for QTY and 2 for Currency.
I'm leaning toward a StoredProcedure issue for the distributions, but before I start poking around I would like to ask for feedback.
Anyone else seen this odd behavior?
*This post is locked for comments
Check the GL00100 DECPLACS <> 0
I found many and updated them to 0
This resolved the issue.
Bill -- thanks for your response. I did check the Item Class Currency, but received message that it was only used if Multicurrency was registered.
GP 12.00.2084 (2013R2)
SQL 10.50.2500 (2008R2)
All workstations/server and users/sa have same results.
Just because you looked at Inventory did you happen to look at the Item Class Currency setup screen.
As to the double and triple that is not so fast an answer, and I think you might be right - there may be a stored proc problem.
Just for clarification and knowledge, what version of GP are you running and what version of SQL Server. Secondly, is this happening on one or more than one workstation and can more than one use duplicate the problem. Want to identify local machine or network related, user permission or just total code malfunction.
Good luck, and continue to post as others will be interested.
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 (