Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Borvik (Programmer) (OP)
5 Feb 13 14:41
Hello,

This is going to seem really weird - it took me a while to finally grasp what my boss was asking of me.

We have a product always purchase at 1 EACH, but always sell at 1 BOX (25 EACH).

So I setup the schedule to have Base UofM: EA. Where EA = 1:EA, PK = 25:EA.
Purchasing Options: EA: Whole, PK: Not Available.
Default Selling of PK, and only PK in the Price List.

This works.

However, the Quantities page is showing the Base UofM: EA. So when we only have 1 box, the quantity is showing 25 - and without realizing that it is EA, he is assuming we have 25 boxes available.

Basically, when he looks up the Quantities he wants to see the boxes as the each - but this would throw off purchasing and our vendor.

Does any of that make sense and is there a way to accomplish this while not mixing up purchasing or our vendor?
Helpful Member!  VictoriaYudin (IS/IT--Management)
11 Feb 13 8:36
Quantities in GP will always show the base UofM, in this case EA. Unless you modify all the windows where this might be shown, there is no way around that if you set up your UofM Schedule to have EA as the base UofM.

The only way to accomplish seeing the quantities as boxes on GP windows out-of-the-box would be to set up a new UofM with PK as the base and EA = .04 of PK. This will work correctly for this particular situation, but if this is simply an example, and you have other items where a pack is different and does not divide evenly (like a 30 pack), this may not work properly. Also, you would need to have 2 decimal places tracked for this item and may end up seeing results like 1.04 PK, which would actually be 26 EA. Hard to say whether that is better or worse and often really depends on what the users need to see more often.

Another option might be creating some custom reports or even lookups for the times when users need to see the PK quantity instead of EA.

Hope this helps to give you some ideas.

Victoria Yudin
Dynamics GP MVP 2005 - 2013
Use Crystal Reports and SSRS with GP:
http://www.GPReportsViewer.com/gpreports.html
blog: http://victoriayudin.com

Borvik (Programmer) (OP)
11 Feb 13 8:45
Thanks Victoria.

That is very illuminating at how that would work. I had thought something like that may be accomplished, but I think as we were not tracking decimals for our products quantities (most of them anyway) that was why it never really looked like it would work.

After showing that to my boss, he decided that it is currently working and it's not worth changing at this point.

I'll definitely have to remember this for next time though. Thanks.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close