3 weeks ago
I have not found what I consider an acceptable way to transfer inventory and cost it at the same time. The solution I would have liked to have would be to have positive and negative PO Lines and then the ability to do a landed cost as well. Then when I transfer 20 pallets of XYZ I can put PO line to the 3PL vendor for the new cost of the items that we will incur from them when they receive the stock. (eg. receiving fees, put away and initial storage) placing the inventory now in that designated warehouse for fulfillment of related customer orders. Then I add a negative 20 pallets of XYZ for the current cost of the items and not their location etc. (we use produmex). Then if I use a seperate freight company to transfer the inventory it can use the landed costing to top off my unit cost at the 3PL location. I have fiddled in test data but it will not allow me to have a negative PO qty. I have used another ERP solution in the past that did allow me to both have postive and negative units on PO and then they netted to the ultimate vendor invoice I was going to pay for 3PL fees. And then of course pay freight company if different using the Landed costs. Seems like the cleanest way to do this surely it can be done somehow?
Hello, I have read this a few times and want to help but it's really unclear to me.
You could just do multiple landed costs if you had landed costs X 3PL costs. Even at different times you could keep adding cost to the stock.
Why are we wanting to do positive and negative rows on a PO? Wouldn't you want the PO to match the GRPO to match the AP Invoice to pay it?
To adjust the inventory balance, the landed costs should be able to handle stock adjustment scenarios. You could also use Inventory Revaluations.
I realize you have probably been staring at this issue and have been inside and out with your experimentation but if you could outline A) what you are trying to ultimately achieve and then B) maybe a more specific example I think it would help us to make suggestions.
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I just did this for a customer using B1UP, they use a lot of 3PLs and they want to track cost like this.
I added a field for a carrier invoice to the transfer and then made an automated mechanism that divides the cost between the quantity and does an inventory revaluation in the background. Everything is linked through "Referenced Documents" so it shows up on the relationship map.
My B1UP customization currently does not do multiple invoices.
They do landed costs for landed costs, this is just for carrier costs for transport from 3PL to production. They roll their other costs into production. I work with a ton of customers, this is not a common issue.
From an accounting standpoint it's overkill. This is a "nice-to-have" which I agree gives you a better degree of visibility but it's not an "add-on" I would publish.
But anyways, if you run B1UP you can do whatever you want (given some B1UP / SDK knowledge). But expecting SAP to change because it's your requirement, you will be waiting a loooong time. Hit me up on LinkedIn if you have more questions (http://linkedin.battleshipcobra.com/), check me out on YouTube (http://youtube.battleshipcobra.com) for SAP Business One videos.
User | Count |
---|---|
105 | |
8 | |
6 | |
6 | |
5 | |
5 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.