How to handle value-added services by third party vendors?

We're stumped on how to handle the following (i.e., issuing POs and 
accounting for the costs properly):

1. We normally stock & sell ItemA as individual units.
2. It was decided to bundle 3 ItemA's into one package & sell as ItemA-3.
3. We are going to purchase the ItemA's from VendorA, but have them drop 
shipped to VendorB to shrink wrap them in bundles of 3 for us. VendorB will 
then ship the shrink-wrapped bundles to our warehouse.

We've come up with a plan for dealing with this, but it's very cumbersome.

In a perfect GP world, how would one deal with this? The ultimate goal would 
be to have the ItemA-3's in inventory, with the cost being the cost of the 3 
units of ItemA plus the value-added cost of the shrink wrap process.

Bud Cool
Microsoft Certified Business Management Solutions Specialist, GP 9.0 
Currently supporting: GP 9.0, SP2
Bud (544)
1/29/2009 4:13:02 PM
greatplains 29623 articles. 6 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 42


I assume you're not using GP Manufacturing.  To me, the easiest way to
handle this is to use the Inventory BOM and Assembly Transaction.  I
would set the A-3 BOM up with 2 components - 3 of the Item A and one
component representing the contracted service.

Issue PO for Item A and receive them as a normal PO receipt when
Vendor A notifies you they've shipped.  Issue a PO to Vendor B for the
contracted service item.  When Vendor B notifies you that the items
have shipped to your warehouse, receive the contracted service item as
a normal receipt.  Then, perform an Assembly Transaction to consume
the 3 Item A's and the contracted service item into the A-3 BOM.  This
will reduce the inventory of Item A's and the contracted service item
and increase the inventory of Item A-3 and perform all the accounting
for you.

If you want to see a detailed explanation of how the Assembly
Transaction/Inventory BOM is setup and works, check out this article I
wrote for MSDynamicsWorld here -

Hope this helps,

Frank Hamelly
East Coast Dynamics

fhamelly1 (1404)
1/29/2009 4:33:37 PM

Similar Artilces:

Allow a user to log on as a service as well as a user
I'm doing a blackberry enterprise install and need to allow the admin user for the berry install to log on a service as well. How do i configure the user this way? He is already configured as a admin user. -- Trinidad You configure this (usually) under the Local Security Policy in User Rights. -- Jim McBee Blog - Directory Update - "nigel" <> wrote in message > I'm doing a blackberry enterprise install...

Access Code Pushing Values
I have a customer database with [BillAddress] and [ShipAddress]. I am using a "yes/no" box titled[SameShipAddress?]. To automatically fill [ShipAddress] after checking the "yes/no" box I used this code in the after update event for the check box. If Me![SameShipAddress?] Then If IsNull(Me![BillAddress]) Then Else [ShipAddress] = [BillAddress] End If End If This works for the selected customer, but then pushes the entry [BillAddress] of the previous customer to [ShipAddress] of all of the following customers. Any thoughts? Sounds as...

enter value based on drop down list of another field?
I have an excel 2003 spreadsheet with 3 worksheets. In sheet 1, I created a drop down list in column A based on values in sheet 3, column A (item number). Thisd data comes from sheet 3, where I have column A (Item #'s), column B (Item desc)an Column C (price) In column B of sheet 1, I have Item Descriptions and in column C I have price. I want this to automatically fill in based on what I enter in the column A sheet 1 and it should get the corresponding values from sheet 3 column B and C. I can make the drop down list in sheet 1 column B and C, but some of the descriptions need ...

Services terminating
For the past few days I've come to the office with my Exchange services stopped. The Event Log tells me the IIS Service Mgr shutdown first then the IMAP4, FTP Publishing, POP3, Exc Routing and SMTP. This series of events happened 12 times between 4am and the time I rebooted the server, which fixes the problem until the next morning. Another Event log entry tells me the the SMTP server could not connect to any DNS server, this occured 4 times between midnite and 4am. I have what I believe is a solid AV program (CA eTrust w/Exc option) that is kept updated and scans the drive d...

ADAM Error with Web Service Installation
i need to install the Business Portal for GP 10.0 the web services is required. during the installation of the web services, i encountered an error " ADAM Error 128" what could cause this and how do i solve this? Any one help!!!!! Hi Taiwo Are the web services already installed? If they are it sounds like the issue may be that a different user account installed the web services (other then the one that is installing the BP) Fliehigh "Taiwo" wrote: > > i need to install the Business Portal for GP 10.0 > the web services is required. > during the insta...

Returning Data from a third cell in same row that meets two other
I'm looking for a formula that will return a result from a cell on a same row as two other cells that meet certain criteria. I'm sure there is a way to do this but i am a novice at this kind of stuff and can't seem to figure it out. For example i want a cell to = what is in column E when column A="36751" and when column B="Total Returns" The spreadsheet has 55000 rows. there will only be one instance where both these criteria are met. i want to use this to create a seperate spreadsheet with just info i need and can update on a daily basis. thanks in ...

How do I filter rows based upon a column value
I have a spreadsheet that contains multiple agency id's in a column. When generating reports, I would like to filter per agency and display only the rows associated with that agency. Is there a tutorial or sample on how to do this? Hi It sounds like you are looking for Data / Filter / AutoFilter. Have a look here for some basics: -- Andy. "Jack" <> wrote in message news:eqiU08TVEHA.2988@TK2MSFTNGP10.phx.gbl... > I have a spreadsheet that contains multiple agency id's in a column. When > generati...

CRM 3.0 SDK Web Services
Hi I am writing a small data migration tool to migrate account and contact data. I have approximate 1500 accounts and 6000 contacts to import to CRM 3.0. I finished the application and ran the data migration, I will able to migrate all of the account records without any problem at all. when I run the contact migration, it can migrate 2800 contact records when it get over 2800, my application throw me the following error message: The underlying connection was closed: Unable to connect to the remote server. I am running CRM 3.0, SQL server and my data migration on the same server. I am wonder w...

Comparing cell values then labeling them based on comparision
Hi. I'm trying to find a function or way to compare two cells and then label them according to if one cell is lesser, greater, or the same as the other. I have a large data sheet where I want to compare many pairs of cells and then have them labeled in this way. For example for each pair where the second cell value is larger than the first it would put greater, where the first is larger it would be lesser, etc. Can anybody help me with this? also feel free to email me at Thanks so much for your help. > Hi. I'm trying to find a function or way to compar...

Adding Fonts to New Font Collection
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I need help in adding a few of the fonts I commonly use to the Fonts Collection, which appears at the top of the Drop down menu under FONTS. I would like to store the names of a half dozen fonts in the Font Collection menu so that I can avoid scrolling through the entire Font list in order to highlight them. If one uses Verdana a lot, this is a real pain. Right now, when I go to Font Collections (under the Font menu), I see the subheading New Favorites, not no list appears when I click on it. I want to put my favo...

Sum of values in a form
Folks, I have read numerous threads on this topic, and understand that in order for my Sum() to work I need t ensure all references are made back to the Record Source. I have endeavoured to do this, but am still getting #Error. I am trying to Sum the revenue each tenant provides in a given date range, to give a total revenue figure. If the date range is a whole month, then the expression just takes the value of Rent PCM, and not Rent PCM * No. of Days, which would give some unusual results. My Expression looks like this: =Sum(Nz(IIf([Short Let]=-1,[Rent pcm],IIf(Day([Forms]...

Programmatically adding function to copy all incoming mail to public folder (based on sender domain)
Hi all. I would like to be able to (from any client) execute a script (vbs, exe, whatever) that creates a public folder. That's should be pretty easy. The tricky part is that I want the same script to create a rule (?) on the Exchange server that copies all incoming mail from a specific sender domain to that new public folder. Hmm... Let us assume that I have the sufficient credentials for this action hardcoded in the script.. does anyone have a good idea how to do that. I am creating an interface in our ERP software that should be able to see mail correspondance horizontically accross ...

Add cell value with mouse click
I want to create a counter, so that every time I click in a certain cell it takes the existing number and adds "1" to it. Is there any way to do this? I'm compiling statistical information, and need to get cumulative counts in various categories as I sort through the data. Hi! Maybe you can use a spinner button for this. Right click any toolbar then select Forms. Click on the spinner button ( it looks like an up arrow on top of a down arrow). Place it near the cell you want increment. Once you have it placed and sized right click on it and select Format Control. Fill in ...

Combo box default value multiautocomplete
Hi All i have a subform with 10 item. The first one is a combo box that can choose the value from a list that is linked to a table with many record. This subform is related to the master form with link master field codice,cognome,nome link child field codice,cognome,nome that are the other items that are not visualize in the subform. These link give me the right connection to the master form. Normally when i choose the value from list (table) i place also all the other item in the subform using this code in after update precedure Me.ISEE.Value = Me.ISEE.Column(0) Me.F_Costo_con_M...

Adding Contact Person to SOP Other Invoice Form
We would like to add a field to the "Bill to" and "Ship to" addresses that is the "Contact Person" field from the Address ID palette. How do I do this? This is done easily, check out Knowledgebase Article 874176. You will need to add some additional calculated fields and then modify the existing calculated fields. Using the rw_SelectAddrLine user function you can add the following fields (for example) to an address and have it grow and shrink dynamically with no empty lines. Customer Name Contact Person Address1 Address2 Address3 City State Zip Country ...

IIF Query for Numeric Values in Text Field
I’m attempting to flag interest rate spread errors and omissions in a file from a sales database using IIF statements I adapted from another database (I’m a novice at this). The field I’m querying is text format and contains both alpha and numeric values. When I test for a null value the IIF works fine, but when I test for a numeric value I get an #ERROR. Spread Error1: IIf(([Tbl 1 Eligible Closed Deposit Opps Appended]!Spread Is Null),1,0) Spread Error2: IIf(([CCC Fall 2007 Eligible Products]![IB/NIB]="NIB" And [Tbl 1 Eligible Closed Deposit Opps Appended]!Spread<4),1,0...

How to get task manager CPU and default memory column values
I need to return CPU and memory columns for each process in server from web service like task manager shows by default. I tried code below but s.TotalProcessorTime throws Win32exception with stack below. How to get CPU and real memory size from server using web service ? Andrus. static void Processes(StringBuilder sb) { List<Process> processes = new List<Process>(); foreach (Process process in Process.GetProcesses()) processes.Add(process); processes.Sort((a, b) => { ...

Getting the handle of a combo box in a dialog
have a dialog box that contains a tool bar that contains a combo box. From the dialog box I want to obtain the combo box control to perform a SelectString(). I know that I need to get a handle for it first. The reason I am doing it this way is because when I created the tool bar I placed an empty button there and named it IDC_FONTNAME and then in my tool bar class, I did a SetButtonInfo and changed the style to a TBBS_SEPARATOR. I then created the combo box using the IDC_FONTNAME From the dialog class. CComboBox* pCB = (CComboBox*)GetDlgItem(IDC_FONTNAME); //// returns 0x00000000...

Cincinnati Janitorial Service ...

M04, Go to Online Services, default selection
Whenever I synch with my bank, MS Money defaults to 1) Download quotes, News, and Exchange Rates 2) Get the latest money updates I'd prefer to do neither by default. Can I turn these selections to default "off"? TIA ...

Adding a space to a string
Hi i am trying to add a space i.e Column A1 " hello " Column B1 "mom" with column C1 reading "hello mom" at the moment it reads "hellomom" i know it maybe a simple question but new to this Paul Hi Paul In C1: =A1&" "&B1 HTH. best wishes Harald "lennymos123" <> skrev i melding > Hi i am trying to add a space i.e Column A1 " hello " Column B1 "mom" > with column C1 reading "hello mom" at the moment it rea...

Adding images to a checkedListBox
If I understood well, I can add not only text but also objects to a checkedListBox. So i'd like to add an image as item to my checkedListBox. I tried this: checkedListBox1.Items.Add(imageList1.Images[0]), but it adds "System.Drawing.Bitmap" instead of an image. I'm still pretty inexperienced with c#, so who can help me with this further. Jasmine ...

Linking Values in Worksheets
Is there a simple method of linking a column of values in one worksheet to another worksheet? I can do it manually, one at a time but is there a way of copying the link down the column? (The columns are identical in length) Registers\[Stock Control-Sigma-SMTech.xls]Sheet1'!$C$1369 Registers\[Stock Control-Sigma-SMTech.xls]Sheet1'!$C$1370 Registers\[Stock Control-Sigma-SMTech.xls]Sheet1'!$C$1371 etc, etc Many thanks david Hi David try ='C:\Registers\[Stock Control-Sigma-SMTech.xls]Sheet1'!$C1369 and copy down Frank DavidM wrote: > Is there a simple method of linki...

most often occurent value(s)
I would like to count and determine the most often (10) occurent values (strings) in a column. How can I do that? Thank you very much your help. Tamas, Use a helper column of formulas. For example, in cell B2: =IF(COUNTIF($A$1:A2,A2)=1,COUNTIF(A:A,A2),"") Copy down to match your column, then use Data / Filter.. Autofilter and pick "Top 10" from the dropdown at the top of column B. HTH, Bernie MS Excel MVP "Tamas Konczer" <> wrote in message >I would like ...

Merging Accounts Twice to Use Bank OFX Services PLUS MSN Money Bil
I have not upgraded from Money 2004 primarily because of the problem I am describing here related to merging accounts. I have tested this with Money 2005 and 2006 and each time I reverted back to 2004 because of this. I have not checked 2007 yet but suspect that this problem persists. Could anyone confirm this for me one way or another? The problem involves the limitation that merging works only with one online and one "offline" account. So for a checking account, when I connect to my bank's online services, a separate online acocunt is created that I can merge with the o...