Separate commit for Qty and Cost in PO

Aug 02, 2007 7 Replies

We need the ability to commit the PO quantities separate from the PO cost. Since there is only one commit "event" in RMS, retailers often don't commit the purchase order until they've received and reconciled the invoice which may arrive days or weeks after the shipment arrives. This creates problems because the delay means that the on hand, on order quantities and the last received date aren't accurate.



PLEASE add this feature/option.


---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.



formatting link


We resolve this issue in our Power Ops add-in by tracking received/not committed entries as "pending". Item lists in Power Ops include these quantities as in stock for sales and ordering purposes. When the invoice arrives the PO is reconciled and committed. This also ensure costs are updated accurately in RMS before pushing closed PO's to QuickBooks if you are using that feature.

Greg Digital Retail Solutions

formatting link
"Save a million keystrokes."

formatting link

Thanks. I would like to see it built into RMS but I doubt I will. I think I've at least figured out how to show the true on hand qty in reports using the following formulas.

QOO = SUM(CASE WHEN PurchaseOrderEntry.QuantityReceivedToDate + PurchaseOrderEntry.QuantityReceived > PurchaseOrderEntry.QuantityOrdered THEN

0 ELSE (PurchaseOrderEntry.QuantityOrdered - PurchaseOrderEntry.QuantityReceived - PurchaseOrderEntry.QuantityReceivedToDate) END) QOH = Item.Quantity + SUM(PurchaseOrderEntry.QuantityReceived)

Ed

"Greg [DRS]" wrote:

formatting link

formatting link

POs also need to be able to calculate and update "Landed Cost". We also need to be able to "unCommit" pos that have been Committed prematurely.

POs also need to be able to calculate and update "Landed Cost". We also need to be able to "unCommit" pos that have been Committed prematurely.

Jon,

You can reopen a committed PO. First you must have the setting to allow editing closed PO in SOM | Configuration options. Then open the committed PO in receiving. Add a new item to the PO and it will now be open again. You can then delete off the item you just added and make adjustments to the PO.

Marc

formatting link

Unfortunately, updating landed cost will not go back and correct COGS for past sales. This is a limitation that has been discussed several times before. RMS is not friendly for duties and freight.

formatting link

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required