SAGE 300: Warehouse and Costing

Good Day,

I need to be able to see bag inventory manufactured by our supplier to use the data for replenishment triggers. Only once the inventory is transferred from my supplier to my manufacturing plant do we take "ownership" of the bags and therefore a value associated.

Thus, I would like to create separate external warehouses for my suppliers in the system to carry quantities of the SKU's, but not as our asset until transferred to the Production Plant Packaging Warehouse. Purely for forecasting and replenishment consideration. The data will be uploaded daily/weekly into these warehouses (or is upload not possible manually entered).

I was told SAGE can not allow warehousing without any costing associated. Is this true? How does SAGE deal with Quarantine or QA locations which are "hold" locations?

Thank you in advance!

  • Moving this post to the Sage 300 Support Group since it was posted in the incorrect forum.

    Thanks,

    Derek

  • If an asset belongs to another company (your supplier) then it cannot be accounted for in your Sage system.  It belongs to someone else.  As you say, it goes on your Sage when you take ownership.  I think you are trying to do something you should not.  If you want visibility of stock in another system then you need to ask the supplier for access.

    Alternatives might be to

    - use reporting against PO's

    - book into a 'supplier' inventory location at no cost, then transfer to a real location and add cost when you receive

    Maybe there are other ways, but all workarounds.

  • in reply to Stephen Bagnall

    Hi Steve,

    Thank you very much for the response. This is exactly what I was looking for. Unfortunately I am not a SAGE configuration consultant, but have other ERP experience. The intent is to create a "dummy warehouse" for each of the external suppliers. They hold product they manufacture for us until such a time we request it based on our production plant requirements. I would like to do exactly as you said - create the "Supplier 1" and "Supplier 2" locations in SAGE. I will upload or enter the physical inventory into these locations. Through the integration module (or standard SAGE inventory reporting) I hope to see this location and the quantities. I can now consider quantities for replenishment and forecasting. When I need to use the inventory at the production plant, I will transfer inventory and receive it into the production warehouse/location which is a "real location". This receipt can be linked to cost and accounting (but not the supplier locations)? This can be done, right?

  • in reply to GabeT

    Hi Gabe, if you'd like to have the fetch & import of the Supplier inventories completed via an audited, semi-automated manual import or external service-based automated process, feel free to ask us to reach out to do an intro and demo of our Nexus and/or EnableTRANS modules to do this. Cheers, Derek 

  • in reply to D Kellock

    Thank you Derek, but for now I just need to confirm my scenario above is possible in SAGE as our service provider seems to disagree.

  • in reply to GabeT

    Hi Steve,

    Can you kindly confirm if I can set up non stock warehouses & locations in SAGE 300 and activate costing only after transfers or receipts into certain warehouses? Thus, can I assign costing rules to warehouses and locations separately?

  • in reply to GabeT

    There are a number of possible scenarios here and clearly I'm not aware of your exact situation.  I'd trust your consultant.

    Creating dummy locations isn't an issue.  It's how you handle PO's and costing that introduces difficulties.  If you don't have PO's then you can simply transfer from Supplier 1 to real location and add cost at time of transfer.

    If you use PO's then there will have to be a mechanism (manual or automated) to decrease same stock items in Supplier 1 location as you receive into real location.

  • in reply to Stephen Bagnall

    Thank you Steve. I have what I was looking for. Truly appreciate your feedback. Regards, Gabe.