60
Hi~
Is better to use one master item data to use in GP for 2 or more entities or is better to use each item master data for each entity if purchasing cost are different each store ?
If I use one master item data, I am afraid if purchasing last cost influence and update all entities which may change every time.
When I create a PO, commonly the last cost will pop up. right ?
pls. help me.
Hello~ Mr. Bill
You well understood my intention and purpose of my question.
For more details,
1. We have a HQ wholesale company in NJ where the most volume purchasing po issues ( lowest cost from vendor)
2. We have 2 different cash & carry stores in NY
3. All 3 company have own entity like tax id even it is same ownership
4. Plan to open 3 more stores in different states.
5. NJ HQ office controls all PO and each vendor ship all 3 locations with different cost based on purchasing qty but all same items
6. When NJ HQ purchases volume order from each vendor, NJ makes SO to our stores.
7. Therefore, NJ considers as a distributor to our stores and purchasing costs are different.
8. Each store uses a different POS now and need to integrate with GP.
In this case, can you recommend what is the best option to go with?
Such as, a separate item master data is better or keep one item master data but assign different cost for each location as you have suggested to control cost without conflicts.
Is GP also support multiple vendor assigns for each item because we purchase multi vendors for same item?
I really need your professtional help and ideas.
Thanks~
Sunflower, greetings.
So when you have multiple locations using a single inventory master can be a challenge for the reasons you are noting above. What I understand your question to be is you have two or more locations buying and selling the same item - however - each location may have a different unit cost from the same supplier. Therefore you want to keep location 1 unit cost with location 1 purchase order and same with location 2.
You could create two different master numbers for the same Vendor Item and assign each to the different locations. This would then keep the unit cost separate but would allow you to report on the total number of Vendor Items sold - both combined and by location.
Example
Vendor X - Item X
Location 1 - set up inventory item X1 - then assign to Vendor X and use vendor ID X
Location 2 - set up inventory item X2 - same process
Reporting by Vendor Item Number will then combine the two item purchase history. This could be done in Smartlist and or SQL Reporting Services.
Others with more programming skills might have a better solution - but I believe this works for your requirements.
Hi,
Thank you for using Microsoft Communities.
I am not 100% sure exactly what your question is regarding one master item data or 2 or more entities. GP does not have any 'entity' processing functionality.
To answer your PO cost question, I have provide some information regarding the PO's in regards to the unit cost field.
Unit Cost functionality:
- Displays the cost for the item in the specified unit of measure. For example, if you're purchasing a case of items, the unit cost will be the cost for the case, not the cost of each item in the case. The default unit cost for a non-inventoried item is $0.00 and can be edited.
- The default unit cost is the item's last originating invoice cost in the Item Vendors Maintenance window. The current cost is the cost at which the item was last received. The default unit cost for a blanket line item on a blanket purchase order or a drop-ship blanket purchase order is the unit cost of the control blanket line item, and it can be modified.
- If you change the unit of measure, the unit cost will be recalculated. When you change the unit of measure for a blanket line item, the unit cost will be based on the last originating invoice cost of the item in the Item Vendors Maintenance window. For example, if you change the unit of measure to PAIR, the unit cost would be the last originating invoice cost multiplied by 2. The unit cost for a non-inventoried item won't be recalculated if the unit of measure is changed. The unit cost of the item will be recalculated if you change the extended cost.
- You can change the unit cost on a line item, even if you've entered shipments or invoices against the line item. You won't be able to change the unit cost once the line item has been closed.
- This field isn't available if the purchase order is on hold and you aren't allowed to edit purchase orders on hold.
- The default unit cost is the originating cost from the item vendor when the currency ID assigned to the purchase order is the same currency ID as Last Currency ID in the Item Vendors Maintenance window. If the currency ID assigned to the purchase order isn't the same currency ID displayed in the Last Currency ID field in the Item Vendors Maintenance window, the default Unit Cost is zero in the originating currency specified on the purchase order.
I hope this helps answer your question.
Thank you,
Janelle
Microsoft Support
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (