Topic Options
#38227 - 08/16/13 06:53 AM Purchase Orders with Increased Decimals
Brian Stief Offline
Waterloo Guy

Registered: 04/04/06
Posts: 1736
Loc: Waterloo, Ontario, Canada
Hi,
We have recently converted a site to Purchase Orders 8.1C (20130722). The site was/is using Purchase Orders with 4 decimals enabled for unit costs.

Upon conversion, all data converts existing 4 decimal unit costs to PO's, Receipts, Invoices with 4 decimals. You can see on the document inquiries.

However, when processing the receipt as an invoice adjustment with 4 decimals on the unit costs, if you need to make an adjustment, you can enter 4 decimals but the 4 decimals are rounded and displayed as 2 decimals before extensions. The extension is based upon the rounded unit cost instead of the entered 4 decimal unit cost adjustment. This is wrong.

If you are not making any cost adjustment on the invoice, the existing 4 decimal costs (stored as 4 decimal costs) are also rounds for reporting on the screen to 2 decimals (for invoices processed after conversion), but get saved as 4 decimal costs with the original extension, which is correct if you could only see the 4 decimal costs on the data entry screen.

Can this be corrected?

We have tried on clients data and also on sample data with the same results, except that with sample data if you convert to 4 decimals, all previously entered PO's stay as 2 decimals, and the 4 decimal unit costs only affect new transactions subject to the noted unit cost problem with invoices/adjustments.

Thanks,
Brian
_________________________
Brian Stief,CPA,CA
Stief Group www.stiefgroup.com
Link2 Systems www.link2systems.com
800.540.3164

Top
#38326 - 08/23/13 10:10 AM Re: Purchase Orders with Increased Decimals [Re: Brian Stief]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hello Brian,

Do we have this client's data? We have not been able to recreate the problem, but it's likely that we are not following in your exact footsteps since your post mentions repeating the problem in the sample data.

A document with screen shots would likely solve the problem.

Thanks.
_________________________
Andrew Bates

Top
#38334 - 08/26/13 08:45 AM Re: Purchase Orders with Increased Decimals [Re: Brian Stief]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Brian,

We have been able to recreate a specific circumstance and we'll R&D take a look.

My memory says that this came up during the Beta cycle and was deemed "unavoidable" if we wished to maintain database compatibility with POA. However, that was long ago and we have not been able to put our hands on the discussion.

In any event, R&D will take a look. Thanks for bringing this to our attention.
_________________________
Andrew Bates

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 56 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14458 Topics
70633 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30