The Community 2018-10-19T18:30:17+00:00

Welcome to ERP-Talk Community

For first time users please create an account

Can anyone advise?
Clear all

Can anyone advise?

1 Posts
1 Users
New Member
Joined: 4 years ago
Posts: 1
Topic starter  

A company sells sporting goods via their website and partners all around the world. They send stock to these partners, who have their own stores and bills them for what they sold only. The unsold stock comes back at the end of the season.In specific, for each one of these stores, there is a location in NetSuite and of course a Customer Account which are to be billed on a basis (weekly/monthly/bi-monthly/etc). The Merchandise department set up profiles on the items for each location (min quantity, re-order point, etc) and based on those profiles on a weekly basis and using a custom module in NetSuite, they replenish these locations (By creating Transfer Orders). The company will import the transactions the store made by creating Invoices/Credit Memos. The location on the Invoices and CM is the store’s location, as a result the stock gets updated in that location and we are able to replenish and so on.The problem
1. Let’s assume we want to send 100 swimshorts to a partner location
Company Warehouse: -100
Partner Location: +100
2. As the partner store is selling items, we import those transactions in NS for the partner location. Assuming that the store has sold 50 of those swimshorts the location now is:
Partner Location +50Problem 1
When the time for billing the partner is coming, the company is going to need to Invoice the partner for those 50 swimshorts by creating an Invoice which means that this will remove another 50 swimshorts from that location. (Partner location 0 stock)Problem 2
When the company will replenish the partner location, because it uses Transfer Orders, the items “arrive” to the location with cost price. This is wrong because the cost price of the items is the price (wholesale rate), we bill them at the end of month only for what they have sold.At this point, we would like to ask you to come up with a solution for those two problems above. The solution should enable us to overcome:
1. The stock issue when it comes to billing at the end of the season
2. How to transfer stock with zero COGS to the partner location