Dropshipping-in-ERPAG

ERPAG 5.1

Dropshipping in ERPAG

dropshipping in ERPAG

Does ERPAG support drop shipping? How do I handle dropshipping in ERPAG? Can a customer return a drop shipped item?

1. Introduction

The concept of dropshipping at first glance seems very simple, e.g. A customer places an order through my webshop and I forward his order to my dropshipper who will take care of everything from that moment on.

Is it that simple in practice?

If you answer yes, you are free to skip this blog.

For those who answer this question with a No, in this blog post, we will explain how dropshipping is managed through ERPAG. This blog is focused on practical application in ERPAG, if you need general dropshipping information you can find it on our other blog: https://blog.erpag.com/2019/02/what-is-dropshipping.html
_________________________________________________________________________________

2. Product type

There is a specific product type in ERPAG, which creates items on which we apply the dropshipping concept.

create dropship product

Creating a dropship product is quite easy - we just select "dropship product" from the drop-down menu, when creating a new product in our products and services list.

fulfillment drop shipping

The setup is almost identical to a regular Product, but because of its specificity, “Dropship product” has the following limits:

• No on hand or quantity in stock (as the items are not received to our stock but are sent directly to the customer by the supplier)
• No stock card
• No reserved quantity
• They can not have serial or lot numbers (as we do not have access to this supplier information)
• Stock adjustment, stocktaking or set quantity with this type is not possible
• It is not possible to select such an item in the transfer document between two warehouses
• Output or input item in Work Order (except for contracting)
• Other options which include manipulation of items in stock

Note:

In practice, sometimes, a regular product (eg we had it in stock) must become a "drop ship product" (no longer in stock, delivery will be directly from the supplier) or vice versa. The change process is simple, just change the "backorder" type.

change fulfillment type

Just make sure that the quantity in stock is "0" and that all sales and purchases are completed.
_________________________________________________________________________________

3. Sales Order

For a better explanation, we will make an example - Sales Order where we will have a regular product, service and "drop ship product" (in ERPAG it is possible to have different types of items on a single Sales order).

erpag sales order

The "icon" of a  drop-ship item is different for easier visual recognition.


Since we don't stock drop-ship items, its quantity will always be missing.

dropship item no quantity

So we have to order it from our supplier.
_________________________________________________________________________________

4. Ordering - Backorder

Ordering missing items in ERPAG is done through the "Fulfillment". For more information regarding the sole concept and process, you can find on our blog: https://blog.erpag.com/2018/10/fulfillment-backorders.html

fulfillment purchase order

In our case, we will have 2 items for ordering.

erpag fulfillment

After activating the bulk action, 2 purchase orders will be generated. One for a regular product, and one for the dropship product.
_________________________________________________________________________________

5. Purchase order

dropship purchase order

The purchase order that has the "drop ship" type has an additional section that is populated with the customer's address to which the supplier (dropshipper) will ship the items.

Note: ERPAG will try to sum the purchase orders, if the customer's delivery address is the same.

On the info button of Committed Quantity, we can see for which Sales Order this item is committed.

committed quantity

Also, in Sales Order, we can see the Purchase Order relation.

sales order purchase order link

We send the Purchase Order formed like this to our supplier (dropshipper) who will send these items to our customer.

Confirmation of whether the products were sent (or delivered) to the customer, we can obtain from the supplier or from the customer that received the products. So there are two ways to complete the process, i.e. we record that our customer has become the "owner" of the goods. The method of implementation depends on the company policy itself and the logical flow.
_________________________________________________________________________________

6. The logical flow

A logical flow represents a series of related events until the closure of the deal (in this case, sales). There are several different flows in ERPAG:

• Sales Order -> Advance Payment -> Packing -> Shipping -> Invoice
• Sales Order -> Packing -> Shipping -> Invoice -> Payment
• Sales Order -> Invoice -> Payment -> Packing -> Shipping

With a regular product, packing is the moment when items "leave our stock" (in accounting, the Cost of Goods Sold is formed) and a packing list is created.

With Drop Ship product, we have the following flows when a supplier provides us with status information:

• Sales Order -> Advance Payment -> Sent by supplier -> Invoice
• Sales Order -> Sent by supplier -> Invoice -> Payment
• Saled Order -> Invoice -> Payment -> Sent by supplier

Or when we receive status information from a customer:

• Sales Order -> Advance Payment -> Received by customer -> Invoice
• Sales Order -> Received by customer -> Invoice -> Payment
• Sales Order -> Invoice -> Payment -> Received by customer

Sent by the supplier and received by customer are moments logically identical to the packing of the regular product, ie the moment when the customer becomes the owner of the products.
_________________________________________________________________________________

7. Received by customer

If our customer informs us that the items were delivered (or sent with a high possibility of being delivered), in ERPAG we will record it through the option "Received by customer".

received by customer

The "drop shipping" packing list will be formed.

dropshipping packing list

At that same moment, "Goods received note" is also formed in the corresponding Purchase Order.

goods received note

With this option, we virtually "packed" the Sales Order, and "received" a Purchase Order.
_________________________________________________________________________________

7. Sent by supplier

Another approach is when the supplier (dropshipper) informs us that he has sent the items to our customer. This option can also work when the supplier accepts our order with the assumption that they will also deliver the goods.

dropship item sent by supplier

Just like in our previous example, two documents are formed:
  • Goods received note in the Purchase Order
goods received note in PO
  • Packing list (Drop Shipping) in the Sales Order
sales order packing list

Results in both cases are identical.
_________________________________________________________________________________

9. Completing process in our example

For the Purchase Order (type: dropshipping) we will create a Supplier Invoice and record the payment.

supplier invoice

record payment purchase order

The document status is now "completed/paid".

In our example, we also have another Purchase Order (for a regular item), where we will "receive" the items in order to increase the quantity in our stock, then we will create a supplier invoice and record a payment.

receive items to stock

Now both Purchase Orders have the "completed" status.

completed purchase order

Our Sales Order currently has the next statuses: Partially packed/Available quantity/Partially shipped/Not invoiced

sales order statuses

We will activate it and do pack > ship > invoice > record payment.

pack sales order

invoice sales order

Now our Sales Orde3r is completed as well.

completed sales order
_________________________________________________________________________________

10. Internal accounting system

ERPAG has an automated internal accounting system whose primary goal is management reporting.

NOTE: ERPAG is not intended for official accounting, for this purpose use integrations with QuickBooks Online or Xero.

More information on our blogs:

You can see an overview of the auto-generated accounting journal voucher on each document by activating the option on the right (journal voucher).

journal vouchers

The Purchase Order journal voucher:

purchase order journal voucher

And Sales Order journal voucher:

sales order journal voucher

Here we see that the drop ship product is posted to a separate "Goods on Transit" account. Other postings are just like regular items.

The cost of goods sold is formed by the real price ie. takes the price from the purchase order.
_________________________________________________________________________________

11. Customer return

With regular items, the return of products from the customer is not a problem for us because the items are shipped to our warehouse and that's it. There are several logical cases when returning a drop ship product, but we will explain the most common case.
  • Customer returns the items directly to our supplier (dropshipper)
return dropship item

In our example, we will have three returning options (Products, Services, Dropship products). We will select "Dropship products" and a new form for entering items and quantity for returning will appear (in negative quantities).

return dropship item

A new document is formed with a "Returned" status.

returned drop ship item

You probably notice that the payment status is "overpaid". As our customer paid us the complete amount, it's necessary that we return him the paid amount and record that in ERPAG. We will do that through the "payment" option, and we will enter this amount as negative.

record payment customer return

The Sales Order status now has a paid status.

paid returned sales order

Note: Customer returns and void documents have the same number as the original.

"Drop ship products" do not reach our warehouse, but the supplier sends them directly to our customers so that automatically forms a return to the supplier.

dropship item return to supplier

return to supplier

And thus, the items are returned to our supplier.
_________________________________________________________________________________

2019. ERPAG Inc


0 comments:

Post a Comment