Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
I'm the owner of the items.
using loan orders is OK but will prevent me from invoicing the items sold before the loan date ends.
Example, home appliances were loaned to a shop for a year, and every week my client visits the store to count the items sold and invoice the store for them.
we created different locations in the warehouse carrying the different customers' names, then we do stock transfer to these locations.
These locations can easily be queried and periodically counted as needed.
(our client have teams that periodically visit each customer location and do a stock count)
in case of sales:
A direct sales order is created --> items manually allocated from the customer location --> and finally a sales invoice is created.
sure, you can achieve this by following the below steps:
- set the location type (the one you created for the customer) as replenish-able.
- assign a product to that location. When assigning a product, set the ROP and Max quantity.
- go to Inventory > Internal flow > Calculation of replenished locations. this will create suggested movements from internal locations to the replenishable location. for example from normal stock location to consignment location.
- Inventory > Internal flow > Reorder plan, here you can see the suggestions created above. click on the lines and go through with the stock change and then the system will create a stock replenishment movement.
I come on same situation as you described above - but need some more advice about location setup:
After i run Calculation of replenished locations (FUNCALREO) - it do doesn't include customer locations.
This function works only on internal or subcontract locations.
Hi Girts,
You are correct, that's why you should not set the location type as 'Customer', instead set it as internal and replenishable.
of course you should name it as the customer name to easily identify it.