Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Drop-Ship Costs on Purchase Order
11-23-2017, 06:46 AM, (This post was last modified: 11-23-2017, 06:49 AM by VortecCPI.)
#1
Drop-Ship Costs on Purchase Order
I have already searched this forum and have found no clear answer so I am going to have to ask...

For some of our products we simply send a PO to our vendor and they handle every aspect of the order including drop-ship. The PO MUST include a line item for S&H along with associated cost/charge and destination address.

My first thought is to add a Non-Stock item to the PO so it will show on the PO and so we can reconcile it when we receive an Invoice from the vendor. The Non-Stock item will go to the proper GL Account and use the drop-ship address as a description. The only thing I am not too sure about is what happens during our ghost receipt of the drop-ship goods at the customer site.

If the above is okay I will add a little bit of code to bring in the Branch Address, Proper GL Code, and Freight Cost from the associated Sales Order to make the task very fast and easy.

   

   

Do any of you have the same situation and, if so, how are you handling it? I don't want to reinvent the wheel and I want to keep it simple. Very shortly I will be integrating SuiteCRM as the Contract initiator with webERP as the Sales Order data consumer so the simpler the better. I looked at Shipments Management and from what I read I don't believe it will help in this context.

Any help or thoughts are greatly appreciated!
https://www.linkedin.com/in/eclipsepaulbecker
Reply
11-23-2017, 10:54 PM,
#2
RE: Drop-Ship Costs on Purchase Order
This is an interesting subject, but not one I have any experience in.
You could add the delivery address to the PO comments on PO_Header.php, but your solution is quite elegant.
What do you mean by 'ghost receipt' ? Do you plan to GRN the PO items once you receive an invoice from your supplier (confirming they received and dispatched the goods)? If there is a time delay between receipt of goods and dispatch from your supplier, you could request separate invoices for each stage of the process.

Andy.

https://www.linkedin.com/in/andrewcouling
Reply
11-24-2017, 01:52 AM,
#3
RE: Drop-Ship Costs on Purchase Order
By "Ghost Receipt" I mean we must receive the items (so we can invoice) even though they go directly to our customer. Most all goods ship within two days of PO receipt by our Supplier/Vendor so we will generate GRN and Invoice when we confirm receipt by our Customer. Our Warehouse or Inventory Location is also a bit of a ghost as it is basically a pass-through from the Supplier/Vendor to the Customer.

Thank you for the kind words but I consider my solution a bit lazy as opposed to elegant. Perhaps "Elegantly Simple"? I can get very creative when need be and since we have to do this operation manually until the SuiteCRM integration piece is in place I want it to be fast and easy.

If any of you could use what I have done I will gladly share once testing is complete.
https://www.linkedin.com/in/eclipsepaulbecker
Reply
11-27-2017, 08:46 AM,
#4
RE: Drop-Ship Costs on Purchase Order
Yes - I think a dummy/service FREIGHT item is the way to go for this.
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
11-27-2017, 11:33 PM,
#5
RE: Drop-Ship Costs on Purchase Order
I tried a dummy/service FREIGHT item but it will not transfer over to a vendor PO from the Sales Order during my testing. Perhaps I was doing something wrong?

I am currently documenting our entire process (Actors/Actions) so when I get to Procurement I will try it again...
https://www.linkedin.com/in/eclipsepaulbecker
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)