Freight allocation to Inventory cost - need a way to uplift by a %

Landed cost does not work for our company.  We need the ability to apply an 
average Freight cost or a percentage  to every item in inventory at the time 
it is received in.  The cost could be applied by the weight of the product or 
a simple % increase.   

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the 
suggestions with the most votes. To vote for this suggestion, click the "I 
Agree" button in the message pane. If you do not see the button, follow this 
link to open the suggestion in the Microsoft Web-based Newsreader and then 
click "I Agree" in the message pane.

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=7a6d4833-4e17-48a7-b15c-0012db6ea8dd&dg=microsoft.public.greatplains
0
fkwik (4)
1/29/2007 9:16:00 PM
greatplains 29623 articles. 5 followers. Follow

3 Replies
900 Views

Similar Articles

[PageSpeed] 2

Hmm ..
This sounds like landed cost to me.
Why do you say it won't work for you?
Maria.


"fkwik" wrote:

> Landed cost does not work for our company.  We need the ability to apply an 
> average Freight cost or a percentage  to every item in inventory at the time 
> it is received in.  The cost could be applied by the weight of the product or 
> a simple % increase.   
> 
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the 
> suggestions with the most votes. To vote for this suggestion, click the "I 
> Agree" button in the message pane. If you do not see the button, follow this 
> link to open the suggestion in the Microsoft Web-based Newsreader and then 
> click "I Agree" in the message pane.
> 
> http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=7a6d4833-4e17-48a7-b15c-0012db6ea8dd&dg=microsoft.public.greatplains
0
Maria1 (236)
1/29/2007 9:45:01 PM
We want to set up as standard % that will be added automatically added to 
inventory cost as it is received without any intervention by a user like 
landed cost works.   We have a great deal of prodcut that comes in the same 
day it is shipped out.   We thought landed cost would do this but our 
Microsft business partner told us it does not work that way.  If you know how 
to get this to work please tell.   

"Maria" wrote:

> Hmm ..
> This sounds like landed cost to me.
> Why do you say it won't work for you?
> Maria.
> 
> 
> "fkwik" wrote:
> 
> > Landed cost does not work for our company.  We need the ability to apply an 
> > average Freight cost or a percentage  to every item in inventory at the time 
> > it is received in.  The cost could be applied by the weight of the product or 
> > a simple % increase.   
> > 
> > ----------------
> > This post is a suggestion for Microsoft, and Microsoft responds to the 
> > suggestions with the most votes. To vote for this suggestion, click the "I 
> > Agree" button in the message pane. If you do not see the button, follow this 
> > link to open the suggestion in the Microsoft Web-based Newsreader and then 
> > click "I Agree" in the message pane.
> > 
> > http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=7a6d4833-4e17-48a7-b15c-0012db6ea8dd&dg=microsoft.public.greatplains
0
fkwik (4)
1/29/2007 10:13:01 PM
We are using GP 8, and are using Landed Cost roughly as you describe.

You have to create the Landed Costs (ex. freight 5%, freight 3% duty 10%, 
duty 5%, etc)

You then create your Landed Cost Groups (ex. F5D10 = freight 5% + duty 10%, 
etc ..)
and assign the Landed Cost Group at the Item/Site level.

When you rcv the item, this extra amount is calculated and added to the cost 
of the purchased goods. 

(No need to tie a vendor to the Landed Cost, although you can).

Hope this helps,
Maria.


"fkwik" wrote:

> We want to set up as standard % that will be added automatically added to 
> inventory cost as it is received without any intervention by a user like 
> landed cost works.   We have a great deal of prodcut that comes in the same 
> day it is shipped out.   We thought landed cost would do this but our 
> Microsft business partner told us it does not work that way.  If you know how 
> to get this to work please tell.   
> 
> "Maria" wrote:
> 
> > Hmm ..
> > This sounds like landed cost to me.
> > Why do you say it won't work for you?
> > Maria.
> > 
> > 
> > "fkwik" wrote:
> > 
> > > Landed cost does not work for our company.  We need the ability to apply an 
> > > average Freight cost or a percentage  to every item in inventory at the time 
> > > it is received in.  The cost could be applied by the weight of the product or 
> > > a simple % increase.   
> > > 
> > > ----------------
> > > This post is a suggestion for Microsoft, and Microsoft responds to the 
> > > suggestions with the most votes. To vote for this suggestion, click the "I 
> > > Agree" button in the message pane. If you do not see the button, follow this 
> > > link to open the suggestion in the Microsoft Web-based Newsreader and then 
> > > click "I Agree" in the message pane.
> > > 
> > > http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=7a6d4833-4e17-48a7-b15c-0012db6ea8dd&dg=microsoft.public.greatplains
0
Maria1 (236)
1/29/2007 10:34:01 PM
Reply:

Similar Artilces:

Field service inventory rewuirements not consolidating transfers
Hello, I am unable to consolidate inventory transfers using inventory requirements screen in GP 10 SP3 field service. It automatically assigns separate transfer numbers where it used to consolidate. I checked service call setup and the the disable consolidation box is not checked. Any help would be appreciated. Tom ...

Allocation of Posted Amount over Days
I have a company that wants to allocate a posted amount to an account over days, not months, so they can produce weekly reporting. Within FRx you have the ability to do day-sensitive reporting so it may be a workaround. I'm hoping, though, somebody has an idea on allocating amounts over x number of days. The revenue/expense deferral module does things based upon fiscal periods so, unless you set up daily fiscal periods, it's not going to work. -- Charles Allen, MVP Charles I have a client that is doing the exact thing (Grocery) We are doing calculations within FRx for the da...

Any way to suppress WM_ACTIVATE message?
Hello all, I'm trying to implement idle time detection in my MFC app. If i detect that the user has been idle, i bring up a dialog for the user to login again, in the handler for my Main window's WM_ACTIVATE. The problem is, if the user cancels the login, I should call WM_CLOSE and exit, but as soon as the login dialog is dismissed, the WM_ACTIVATE message is dispatched again, so I don't see a way to exit... Is there any way to suppress the message, or any other way to handle the re-login? Thanks and Regards Madhavi "Madhavikutty" <madhaviks@gmail.com> wrote i...

freight class
SQL 2005 Assuming the below PCF and Class columns were in a table, how would I create a query, with PCF known, to find the proper freight class? I started with SWITCH, but that just goes on forever. Thanks! FREIGHT CLASS CHART The first column shows the pounds per cubic foot (PCF). The second column shows freight class. So when the PCF is greater than the number in the first column, than the class will likely be the number in the second column. PCF Class 50 ... 50 35 ... 55 30 ... 60 22.5 ... 65 15 ... 70 13.5 ... 77 12 ... 85 10.5 ... 92 9 ... 100 8 ... 110 ...

Easy way to send Outlook 2003 calendar/contact items to Outlook 2000?
Is there an easy, no hassle way to send Outlook 2003 items to 2000? I've tried sending them as invitations, as attachments, and zipping them up and emailing them and nothing works--they all end up as plain text files. Brian Tillmand and Russ Valentine says that the only way to do it is it create a 97/2000 PST folder (see 9/30 posting), copy the items to that folder and then take it home on a disk. Reason I need these calendar items is that I'm a freelancer and am working offsite at a client's place for 3 months. I need to be able to put all my work history into my calendar ...

Inventory adjustment creates two journal entries
I was tracking the results of an inventory adjustment transaction when I discovered the system broke the resulting entry to the G/L into two, separate journal entries. The adjustment transaction (# 0000000009826) contained 123 lines; two journal entries were output by GP. The first entry had the following reference information: Journal Entry #: 499514 Source Document: IVADJ Audit Trail Code: GLTRX00021619 Reference: Transaction Entry Orig Audit Trail Code: IVADJ00001482 The second journal entry had the following information: Journal Entry #: 499515 Source Document: GJ Audit Trail Code...

Is there a way to query the Outlook database?
I want to extract some data from a few hundred emails I have, but each one is huge and rather than spending the half-hour it'll take opening them manually, searching for the tag string and then copy-pasting the value immediately after it into Excel, is there a way to query the email database directly using regular expressions or something similar? Just as an explanation: I have a few hundred emails with errors in them, and I want to extract the actual error code, but it's in different places pages down in each email. It always says "ErrCode: [" and then the 20-digit code. ...

Not to Exceed Logic for Freight
Does anyone use not to exceed logic for freight calculations on orders shipping from multiple warehouses? In other words we want to quote a customer a shipping charge but do not want it to exceed that amount regardless of the warehouses the order ships from. Lili- We have a Shareware module for Dynamics GP that already has some Freight field logic in it. It sounds like this might be a pretty small that we could add into the module. Please contact support@klenzmanconsulting . com with more details of what you'd like to have happen. Regards, Brenner www.KlenzmanConsulting.com ...

% of allocation
Hi, I have added a task from 1-Feb to 1-Apr. Initially I allocated 100% of a resource for the task. Later I changed the allocation to 25%. After changing the %, the end date automatically changed. Is there aby ways to change the % of allocation without changing the start date and end date? Thanks! This is a multi-part message in MIME format. ------=_NextPart_000_002D_01CAC825.C8A433F0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi Maanu, Welcome to this Microsoft Project newsgroup :) Yes! Make the T...

POS/RMS GP Inventory Integration
Does POS/RMS update GP inventory? Does or will it go both ways? Thanks. HI Teri, To my knowledge and experience the integration is not 2 way. It is from RMS to GP not from GP to RMS. If you want such thing then you/partner we need to develop using various tools of Microsoft this two way communication. I use econnect for this purpose. "Teri K" wrote: > Does POS/RMS update GP inventory? Does or will it go both ways? > > Thanks. Hi Teri, If you are interested we can write a tool for GP to RMS. Please drop a email to me. Regards, Manick ERP solutions Specialist ma...

automatically copying data from one sheet to another, depending on which drop-down code is allocated
I have a sheet where I list each item of my business outgoings. Column C lists the amount spent. In Column D I allocate a code from a drop-down list, to allocate that item of expenditure against a particular cost centre. I have thirty cost centres. So once the code is allocated, I can filter the list to see all items for any particular cost centre. But what I really want is this: I have created a separate sheet in the workbook, with all the cost centres as column headings. I'd like each amount to be automatically copied to the cost centre sheet, and placed in the correct column,...

Better way to do inventory?
I am looking for some suggestions as to a better way to do inventory with GP (ver 8) Every year we perform a stop-work, full inventory. Its real fun. Our process is this. We break up the entire warehouse site into 4 stock count schedules, print off the sheets 1 item per page, post them at the correct bin, and count. Counters turn in their sheets after they count their section. When counters are counting and they come to a bin with a sheet, but there is nothing in the bin, the count it as zero. Make sense. That item might actually be in the warehouse and has been moved. As counters co...

Inventory posting for new year before running year end?
Hello, What happens if we post inventory transactions for new year without performing year end for 2008? Thanks, MS When you close inventory for 2008, beginning quantities are updated. If you've posted 2009 transactions, they will be included in the 2008 beginning quantity. There are a handful of inventory reports that use the Beginning Qty field, such as the Inventory Turns report. Hope this helps, Frank Hamelly MCP-GP, MCT, MVP East Coast Dynamics www.eastcoast-dynamics.com blog: www.gp2themax.blogspot.com Thanks Frank... Did you mean to say the posted transaction will be incu...

Project Freight and taxes
How do we distribute freight to multiple projects on one purchase? Hi Paul You can`t distribute freight to multiple projects on one purchase because this topic (freight) the system calculates by the total purchase. I suggest you that you create a new cost category named "frieght" and you add in the budged of each project, "Paul" wrote: > How do we distribute freight to multiple projects on one purchase? ...

processor time allocation
My app routinely only gets 10 to 30 % of CPU time - the system idle process gets the rest (indicated by windows task manager) My app is multithreaded and has one thread that requires lots of CPU time at 20 Hz intervals. I sleep this thread for an amount of time that would put it at the next 20 Hz interval. My other threads sleep when they are not busy. My 20 Hz thread does not recieve the processor time that it needs - even though the system idle process is taking up 70 to 90 % of the CPU time. If I remove the sleep call from my 20 Hz thread then it hogs all of the CPU time and the s...

Freight and Tax on PO
I hate to beat this subject to death - I know it has been discussed at length before. But I am really tired of it... I really think there should be a way to include the cost of freight (allocated) and tax in the item cost when receiving/committing a PO to inventory. In my neck of the woods, these costs must be included in inventory, not expensed or added to inventory value as an accounting function. My accountant is having a fit over this because I cannot spit out an accurate inventory value from my POS/inventory trackign system unless I manually update every cost after receiving a PO,...

Tax on Freight
I have 3 customers that pay taxes on freight. I have setup a FRGT tax detail and added to a Tax schedule. also, in the SOP setup I have added the FRGT tax schedule to the Freight. When I process a Sales order for any of these customers the Freight tax is being calculated on the entire sales amount and not just on freight. I I do not add the freight tax to a schedule i manually have to opent the expansion on tax and put the freight tax schedule id in and add the dollar amount of the freight in order for this to calculate properly. How can I set this up to automatically calculate the...

Custom allocators
Hi, I was reading in a previous thread that some of the C++ experts wrote that a positive point of STL containers like std::vector is that it is possible to provide a custom allocator. I wonder what is the purpose of that. When is a custom allocator needed? In what kind of scenarios? There is no way to do that with MFC containers? Thanks in advance, MrAsm On Apr 10, 2:02 pm, MrAsm <m...@usa.com> wrote: > Hi, > > I was reading in a previous thread that some of the C++ experts wrote > that a positive point of STL containers like std::vector is that it is > possible to ...

Budget Allocation
Hi, Is it possible to allocate a monetary value for a recurring bill in the budget? (Money 2003) My budget keeps showing all items that are also listed in bills as being "Over Budget". Thanks, Jack ...

Inventory Asset Types
Hi - I'm trying to figure out how to add an asset type in the household inventory. I'm running 2005 Premium. In previous versions you could add an asset type, in this version it appears you can only utilize preselected fields. I'm a collector of various things and my list of "collectibles" would be very long if I put them all under just one asset class I only have money 2004 so I may be wrong here, but it does not appear that you can change the asset categories. "Palatial" wrote: > Hi - I'm trying to figure out how to add an asset type in the ...

help on inventory criteria
What criteria should be placed on the textbox "qty" on Form1 so that the quantity that is going to be purchased should not exceed the quantity on hand, which is shown on the textbox "unitsleft". Also if the quantity purchased exceeds the quantity on hand, what should i do so that the quantity purchased will equal the quantity on hand so that it will just purchase the remaining units instead of exceeding the quantity on hand. Is this possible? If so,pls help! Thanks! Pls reply ASAP! Really needed! Thanks again! -- ai® Message posted via AccessMonster.com http://www....

PA Inventory Transfer
I have a customer who wants to create a demand for inventory thru Inventory Transfer in Project Accounting. Then when the PO generator is ran, it will produce a PO to fill this demand. The problem in Inventory Transfer (PA) I cannot enter a qty > what is available. How do I get around this. I want to put the demand out then fill the demand with a PO. Thank you, Amy ...

Allocate payments 04-09-10
I have a list of unpaid invoices in two columns. In A is the original value. In B is the outstanding amount. Normally payments would be allocated to the oldest debt at the top and invoices would be zeroed in B as the payments progressed. Zero invoices drop off. As often happens, some payments have been allocated to the wrong invoices and although the overall debt position is the same I cannot use the data in column B to supply an accurate statement of what is due. Whilst it is easy to identify where the payments are and how much has been paid in a separate col I would like to be ...

Distribute tax & freight based on this invoice's allocations
Allow a hot key (such as "*") to apply any indirect charges against all the prior line items. With this, instead of multiplying the line item times tax and freight for each line of expense and entering the result, you enter the expense amount directly and on the next entry line enter the hot key ("*"), now the software multiplies it out and adjusts for rounding. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane....

How to add in freight from a 3rd party to inventory transaction
How do I get a freight charge added to multiple line items of inventory when the billing comes from a 3rd party carrier, not the shipper. Use Landed Costs "Doug" wrote: > How do I get a freight charge added to multiple line items of inventory > when the billing comes > from a 3rd party carrier, not the shipper. > > ...