Supplier Cost different from Item Cost?

Why is there a separate Supplier Cost for each Item? We worked hard to
update the costs of all of our edible items (several hundred), but when we
create Purchase Orders, the costs of all the items shows $0.00.  It's
because the PO shows the cost associated with the supplier. While this makes
some sense, why is there a need for 2 different costs?--perhaps in different
businesses an item's cost after it is bought from the supplier goes up due
to packaging and labor?

In any case, is there any way to create purchase orders so that it gets the
cost from the regular cost field? Also, what happens if we send out a
worksheet from HQ to update the costs of items? Will we have to manually
update the cost associated with the supplier? Our edibles buyer sometimes
may have 50 or 60 items on one PO and has to re-enter the costs every time.

I could use SQL and HQ Admin to copy over the costs to the supplier costs,
but does anybody know where i can find the table and field structure? i'd
hate to mess things up. This should be done at HQ if i need to go that
route, correct? Of course if there's a way to do this within the RMS
interface, please tell.

thanks,
kamal


0
kamal (120)
11/20/2004 2:32:43 AM
pos 14173 articles. 0 followers. Follow

1 Replies
466 Views

Similar Articles

[PageSpeed] 27

Kamal Hood wrote:
> Why is there a separate Supplier Cost for each Item? We worked hard to
> update the costs of all of our edible items (several hundred), but when we
> create Purchase Orders, the costs of all the items shows $0.00.  It's
> because the PO shows the cost associated with the supplier. While this makes
> some sense, why is there a need for 2 different costs?--perhaps in different
> businesses an item's cost after it is bought from the supplier goes up due
> to packaging and labor?
> 
> In any case, is there any way to create purchase orders so that it gets the
> cost from the regular cost field? Also, what happens if we send out a
> worksheet from HQ to update the costs of items? Will we have to manually
> update the cost associated with the supplier? Our edibles buyer sometimes
> may have 50 or 60 items on one PO and has to re-enter the costs every time.
> 
> I could use SQL and HQ Admin to copy over the costs to the supplier costs,
> but does anybody know where i can find the table and field structure? i'd
> hate to mess things up. This should be done at HQ if i need to go that
> route, correct? Of course if there's a way to do this within the RMS
> interface, please tell.
> 

/* Example */
CREATE TRIGGER trUpdateSupplierCost ON Item
AFTER INSERT, UPDATE

UPDATE SupplierList SET SupplierList.Cost = inserted.Cost, LastUpdated = 
  GETDATE()
FROM inserted WHERE SupplierList.ItemID = inserted.ID

------------------------------------------------------------
Consideration:
I have 1 item with more suppliers.. example:

The eggs
  - For my customer eggs are only eggs..
  - For my suppliers.. their eggs are the best.. and they sold me with 
different prices.. and I have a primary supplier, and other suppliers..

The Item.Cost is average of cost.. and each supplier have different cost 
(and I buy only from supplier with low cost).

Bye
Antonio
0
amazzeo (368)
11/20/2004 10:12:33 AM
Reply:

Similar Artilces:

Overlapping of values in different tables.
I am wondering if there is a way to create a pivot table - or some other way - that will show the relationships of rows between tables. I have attached data from potentially 4 different tables and the business is wanting to see the number of times that a paticular ID shows up in different table join combinations. For example, we want to know the count of unique IDs will show in the NPS, AAC and ECM tables. Is it possible to create a pivot table that will dynamically adjust based on a user choosing the column combinations that they want to see without having to create a separate pivot...

CListView losing items
Hi, I have a problem with a CListView in report mode. I can add items but when I add the 10:th (or any > #10) item it's subtexts aren't shown, but is rather shown in the last element in the view (sorted by column #1 (ints showing the row number)) so far always the ninth element. result: 1 text 10 11 2 text 3 text 4 text 5 text 6 text 7 text 8 text 9 text corsponding to # 11 I can't figure this one out. Can someone please help me? For something like this you should post some code.. But here is how to fix half of your problem. get the return valu...

edit variable length items in "Access" database tables
In my database table I am holding a variable length item in a database record; the item may be from two to six alphabetic characters long. Trailiing spaces pad the item where required. To print out the item in a report, the item itself is sandwiched between two fixed-length items separated by an oblique stroke, (forward slash): - ***/variable length/***. How can I suppress the trailing spaces in my variable length item when printing results ? Yours Sincerely, CHARLES WALKER Take a look at the RTrim function or even the Trim function. RTrim(SomeField) will trim trailing spaces off a...

Discontiuned inventory items
Once an item in inventory has been marked as discontinued and has a quantity on hand of zero, the user should have the option of removing it from lookup lists throughout the sales order processing and inventory modules WITHOUT removing history for the item and deleting the item. Can you please tell me how to do this? Is there a way to get the quantity to zero so that I can delete it? We are changing part numbers (again). I have over 700 parts in GP's and need only about 75 and I have never, in five years, been able to figure out how to do this. Any help you can give me would ...

matching items #2
Peter I am aware of the using filter on what worksheet, however i am being bit basic with what i am trying to achieve. I need the information t be on a seperate worksheet in a completely different arrangemen basically like a report with the information what i need being shown. am strying to show the principle in what i am trying to do with m quaestion. Thanks anyway. Ton -- tony lindsle ----------------------------------------------------------------------- tony lindsley's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1499 View this thread: http://www.excelf...

Standard Cost Rollup
We have a client using GP 9 sp2. They are having problems with labor cost NOT rolling up for 'some' parent items. I checked the obvious things: make item, primary routing, etc. but everything looked fine. I deleted the routing and re0entered it - still no labor or overheads. I then created a new item by copying the old item, bill, and routing. The rollup for this item included labor and OH. There appears to be something 'corruoted' in one of the tables, but I have run out of places to look. Any ideas? -- MikeS ...

How to fetch FIFO Cost Price?
Hi, In Sales Transaction Entry, I want to fetch the item's FIFO cost per unit to be placed in Price per unit. This is required to avoid any profit and loss and the cost should be equal to sales. Can any body help me out in this requirement. Thanks and Regards, On Mar 22, 11:56=A0pm, Waliullah <Waliul...@discussions.microsoft.com> wrote: > Hi, > > In Sales Transaction Entry, I want to fetch the item's FIFO cost per unit= to > be placed in Price per unit. This is required to avoid any profit and los= s > and the cost should be equal to sales. ...

Summation: Difference in Decimal
I am computing this simple computation but when i am on the summation i got to have a difference in the decimal places. i compare my computation with a calculator and excel..How can i solve this simple problem. the situation is this. I formated the cell into currency and a two decimal places only. Can you help me figure this problem? Thank you "Mels" <Mels@discussions.microsoft.com> wrote: > I am computing this simple computation but when i am on the > summation i got to have a difference in the decimal places. > [....] > I formated the cell into curr...

Error "Unable to Read Item" opening .msg files
I am having intermittent problems where a user will have saved a .MSG file from Outlook 2003, and then is unable to open it later. By default, these saved files are marked read-only, and the following error is displayed "Microsoft Office Outlook - You don't have appropriate permission to perform this operation." If the read-only option is unchecked, they receive the following error trying to open the file "Microsoft Office Outlook - Unable to read the item." This problem seems to occur randomly to different users. All of my users are using Outlook 20...

Macros failing in different language versions of Word
My company wants to standardize on templates across several countries - we have offices in many countries, but for simplicity I will just talk about UK and Sweden. My problem is that some features in the English version of Word do not work in the Swedish version of Word. For example, StylRef. I use StyleRef in the header margin to refer to "Heading 1" style. The problem is that it is not called "Heading 1" in the Swedish version of Word. It is called "Rubrik 1", which translates back to "Heading 1" of course. In the UK we use many macro...

select multiple items from dropdown
hello everyone, i have a table which is populated using a form. one of the fields is person's name, the dropdown for which picks up data from a second table (which has an index and person's name). what i want to do is modify the form so that a user can select multiple items from the dropdown, but i havent been able fo find a way to do so. i am using access 2003. i know that access 2007 lets you do that, but i dont have an option of upgrading right now. i would appreciate your suggestions thanks, vc-programmer Create a related table, where you can store many options for one...

Different orientations in one publication in publisher?
I am trying to create different orientations in one publication in publisher, ie one page portrait and then the next landscape. Is this possible? Not in the way you are thinking. What you *can* do is to lay a page out as a separate document, rotate it 90�, and paste it into your target document. -- JoAnn Paules MVP Microsoft [Publisher] "Shoshigrl" <Shoshigrl@discussions.microsoft.com> wrote in message news:DC532338-15D5-4D8A-81A8-B25ABA99FD5B@microsoft.com... >I am trying to create different orientations in one publication in >publisher, > ie one page port...

Can I arrange items on my clipboard in a specific order?
Is it possible to change the arrangement of items in my clipboard to a certain order to make it more usable for me? Thanks! ...

How to generate different series of document nos for different users..
We would like GP 8.0 to auto-generate different document numbers for each user. For example: User A will be assigned INV document numbers 1-100 and User B will assigned INV document numbers 101-200 and so on. Is that possible in GP 8.0? If so, how do I go about it? Any ideas? Thanks very much in advance for you help. -Surendra It would have to be a customized solution. VBA or Dexterity are your best bets, for now. With GP 9 you will be able to use Visual Studio 2005 to create customizations, too. "Surendra" wrote: > We would like GP 8.0 to auto-generate different do...

Reading other users 'sent items' folders
Hi all, When using delegate access - Is there 'any' way of granting access for others to view the sent items folder? This does not appear as an option. Alternatively is there any other method to implement this? Many thanks - ras - Hi Craig! In Outlook you can right-click on Sent Items, select Properties, open Permissions tab and delegate appropriate permissions for other users. R.V. "Craig Pilkington" wrote: > Hi all, > > When using delegate access - Is there 'any' way of granting access for > others to view the sent items folder? This does n...

BOM cost report
Does anyone have or know of a report that shows what it would cost to build a BOM if I were to build it right now? -- Japheth Nolt MCP Microsoft GP/SBF Specialist Landis Computer http://landiscomputer.com Japheth, Good question, I never found such report in GP, if you are talking about Manufacturing BOM then you can find the cost in the BOM Card as a figure, you might need to write this report, let me know if you need any help preparing the view and locating the tables. Regards, -- Mohammad R. Daoud MVP, MCP, MCBMSP, MCTS, MCBMSS Mob: +962 - 79 -999 65 85 Great Package For Busine...

Tracking PST items in CRM
I have a user who wishes to track email that's stored in a PST file on his computer in CRM. When he clicks the "Track in CRM" button, he gets an error message about it not being in an active folder or something similar. Is it possible to track PST items in CRM? Thanks in advance. Only the default Outlook/Exchange/PST folder is being synch with Microsoft CRM. Frank Lee Workopia, Inc. http://www.workopia.com/Links.htm "Herb Powell" wrote: > I have a user who wishes to track email that's stored in a PST file on his > computer in CRM. When he clicks ...

Startup Item pops up twice, taskbar color flips
On an Acer Aspire One, I put a notepad TO DO file in All Users Startup and it comes up twice. On this machine, I also have a wierdness in that the taskbar sometimes comes up Blue XP and others grey (like Win 98). - = - Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist http://www.panix.com/~vjp2/vasos.htm http://www.facebook.com/vasjpan2 ---{Nothing herein constitutes advice. Everything fully disclaimed.}--- [Homeland Security means private firearms not lazy obstructive guards] [Urb sprawl confounds terror] [Phooey on GUI: Windows...

Difference criteria from different forms
I have messed with this for a while now and can get it to work. I have two different tabs (in a tab control) that have basically the same combo box which is a "Job#". There is a report button next to each of the combo box's that will run the same report. So if someone chose Job# ABC in tab 1 then navigated over to tab 2 and chose Job # 123 then clicks the report button on next to job# 123 the query criteria for "Job#" should use 123. however if they went back to tab 1 and hit the report button next to Job ABC then the query criteria for job# should use ABC. S...

What is the next step after mailbox mig 03 to 03 different domains
Running 03srv and Exc03 in both domains and I am not sure what needs to be done in source domain after the mailbox move to the target. ...

Visual Studio Setup project. Vista and Xp differences
Question 1: I develop on Vista and my project consists of myExe.exe and myProj.dll. I use Visual Studio 2008's Setup Project to produce setup.exe and .msi. It installs and works on other Vista systems but on Xp systems, it installs but upon launch I get 'procedure entry point _ftol2 not found' errors. Not surprisingly, I found that this error goes away on Xp if I compile and build the same VS2008 project on a Xp machine instead. Anyway I don't need to do this? Question 2: My myProj.dll is dependent on mfc90ud.dll, msvcp90d.dll, msvcr90d.dll and etc. accord...

Error: "A failure may have corrupted the content of the item..."
Hi there! In Outlook 2002, when replying back to an email, getting error message: "A failure may have corrupted the content of the item. Copy the content to a new item, or save the item as a text file or RTF file." Has anyone ever heard of this? If so, please let me know!!! thanks!!! cat I have a user who is experiencing the same problem when trying to reply to an HTML formatted email. Using Outlook 2000. I attempted to "repair" the Office installation, with no effect. Does anyone have an answer for this one? ...

strange difference in print preview of vertical strings and ...
Hi, I do not know if I have been doing a funny mistake , or there is a bug. There is something very strange when I textout a vertical string with leading spaces in print preview mode. I put an small example to show it: try this: make a multiple document, with CScrollView , (vc 6) changes the following functions, the result of the 2 textout are not in the same x position in print preview display. Each space at the beginning of "profiles" shifts the output to right!!! but the x position of both should be the same. Off course it is ok on the screen and on the printer. Only the print p...

Count items in cel
Okay, here's my problem: In my excel-list I have 3 codes: "l","s" and "ls". l is the equivalent of 1,50 euro s the equivalent of 1 euro ls is thus 2,50 euro The codes are entered during the month. At the end of the month I want to see how much someone has to pay. So if that's 3 times "l", 2 times "s" and 1 time "ls" that would be 9 euro. How do I do that in a formula? Thanks in advance! =(LEN(A1)-LEN(SUBSTITUTE(A1,"1s","")))/2 gives the number of "1s" values in A1 =LEN(SUBSTITUTE(A1,"...

Function for add different values
I need one function that adds values that are not equal. Like this: 3 3 3 4 4 5 5 I need a formula that will go to add value 3+4+5. Only different numbers between itself. Which are my options? Please refrain from multiposting, you got at least one answer already in the worksheet functions ng -- Regards, Peo Sjoblom http://nwexcelsolutions.com <douglasracaixeta@gmail.com> wrote in message news:1146597978.225731.85640@i40g2000cwc.googlegroups.com... >I need one function that adds values that are not equal. > > Like this: > 3 > 3 > 3 > 4 > 4 > 5 >...