PO & Deliveries

HI Peter, Let me clear something for you. the cost of the vendor pricing are maintain at vendor level not the ltem level mean if any cost of vendor change it will directly update at Supplier> Properties> Item Supplied > Cost

Remember RMS is retail application and most of the retail applications does not care about what the last cost was? same applies to RMS where at the time of sale the cost will be taken from Item Master, so make sense to us. You can use back office application to integrate the RMS where the average, fifo or whatever costing method you have will be maintained, as we are using MS Dynamics GP and also integrated the all things with it to work.

"Peter" wrote:

I always thought that "receiving" should put the items into stock and "committing" should adjust the costs. This would work better for me. I don't see the point of receiving without committing under the current setup...

I agree that putting the stock into inventory and costing the items should be handled differently.

What you are talking about is the ability to receive blind invoices or packing slips that are later reconciled to final invoice. To accomplish this you'll need to receive the products but don't commit them yet. To do that click OK when receiving rather than Commit. When the final invoice arrives, recall the PO, edit costs if necessary, then commit. If you need the quantity available to reflect received-not-committed inventory in POS lookups, install our SWAT Search add-in for RMS. This utility counts these pending items as available and identifies quantity on hand, available, committed, pending, and on order in the search list results.

SWAT Search 30 day trial:

Yes I know that we can do it this way, but, being a UK user we have always sold packages that would do what I am suggesting as standard and when we are trying to move these customers on to RMS as the way forward they expect the same level of Functionality and would consider something like this to be a backward step.

Is it possible that it could be done in future releases?

Thanks again

Peter

"Greg [DRS]" wrote:

Is there an easier way to do import costing and receive POs?

My current process is : Create purchase order for overseas supplier in HQ with (free on board) purchase price . Do not approve the Po to the store/warehouse. When shipment arrives use an excel spreadsheet to manually work out the actual cost price. (Unit Cost price =Number of Units * Purchase price + import duty+ Sea Freight + Local Handling charges+ Cartage/ Number of Units) Go back to PO key in correct actual prices. Approve PO for store/warehouse to receive.

It get harder when POs have many l> Yes I know that we can do it this way, but, being a UK user we have always

That is exactly how I do it. I have a pretty robust Excel sheet to do it. It's even more complicated because I do my PO in US dollars, which is the FOB currency, and then receive it in my local currency, so I have to convert in addition to adding all of the costs. This problem is precisely the reason for my other thread asking for an "as of" date for receiving. I often can't calculate everything before it goes on the floor for sale...

But what I do is have a column where I formulate a bunch of UPDATE statements. Then I copy and paste this into Store Admin to quickly change the PO costs. This way I don't have to key in hundreds of new values.

For example, the formulas look like this:

="update purchaseorderentry set price = "&AA21&" where purchaseorderid = 677 and itemdescription = "&CHAR(39)&C21&CHAR(39)

And the results look like this:

update purchaseorderentry set price = 203.65 where purchaseorderid 677 and itemdescription = 'TRIMMER LINE SUPRTRIM 130 20LB' update purchaseorderentry set price = 261.65 where purchaseorderid 677 and itemdescription = 'TRIMMER LINE TRAILBLZ 105 20LB' update purchaseorderentry set price = 261.65 where purchaseorderid 677 and itemdescription = 'TRIMMER LINE TRAILBLZ 130 20LB' update purchaseorderentry set price = 265.69 where purchaseorderid 677 and itemdescription = 'TRIMMER LINE TRAILBLZ 155 20LB'

You just have to make sure that you have the right PurchaseOrderID and that you have no duplicate descriptions. Of course, you could use ILC's or ItemID's.

You are going to get responses for a "Landed Cost" module available from a reseller. I evaluated it a long time ago, and it did not fit my needs (was too expensive for my enterprise also). IMO, there are far too many variables to take into account to make an add-on module that can meet everybody's needs (and why MS shouldn't bother trying to add it as a feature).

Anyway, you will see my other post about how I do it now, but one thing MS can do to make the PO function better is to allow you to multiply all of the PO costs by a factor to quickly change the entire PO. Unfortunately, you can only multiply by Item Cost or Supplier Cost, which are different from the cost currently entered on the PO unless you constantly update your database to reflect new supplier costs. Furthermore, it does not take into account inland freight, which is included in FOB for duty purposes. I don't understand why RMS does not allow you to include freight (apply freight) to inventory cost when doing receiving. It's just too inflexible.

Bottom line - try the reseller's module. It might work for you. Otherwise, you are stuck doing what you do now...