Michael
For Inventory/Part Master Items being purchased, we wrote a screen
customization.
The Part Class had a Variance Percentage field added.
Upon entering a purchase order or checking 'buy' in purchasing
suggestions, it compared the price on the order (calculating in the Cost
Per Info /E /100 /1000) and comparing this to the current average price.
If it was out by the percent on the part class it would warn the buyer
with a soft warning.
You could easily take this a step further by comparing it to the last
purchase cost for that part.
This resolved most of the poor cost of sale information being presented
on Gross Margin reports and stopped having to delete and re-enter
receipts to stop variances.
Also, be aware, in most versions I have tested this in, when you enter a
receipt it uses the receipt header receipt date for the transaction.
When you delete a line it uses today's date as the transaction, hence
stock values can be incorrectly reported if they are deleted in a
different fiscal period to the entered fiscal period. You would get two
positive entries in one period and a single negative entry in the next
period. Apparently this is by design.
Gary Parfrey
Dot Net IT Limited, Reg No 4412519
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael McWilliams
Sent: 25 July 2007 20:30
To: vantage@yahoogroups.com
Subject: [Vantage] Wrong PO price entered.
A PO was entered and the user entered in the wrong price. The item
was then received at the wrong price. How are people dealing with
this without having to delete the Receipt and then do it again after
fixing the price?
[Non-text portions of this message have been removed]
For Inventory/Part Master Items being purchased, we wrote a screen
customization.
The Part Class had a Variance Percentage field added.
Upon entering a purchase order or checking 'buy' in purchasing
suggestions, it compared the price on the order (calculating in the Cost
Per Info /E /100 /1000) and comparing this to the current average price.
If it was out by the percent on the part class it would warn the buyer
with a soft warning.
You could easily take this a step further by comparing it to the last
purchase cost for that part.
This resolved most of the poor cost of sale information being presented
on Gross Margin reports and stopped having to delete and re-enter
receipts to stop variances.
Also, be aware, in most versions I have tested this in, when you enter a
receipt it uses the receipt header receipt date for the transaction.
When you delete a line it uses today's date as the transaction, hence
stock values can be incorrectly reported if they are deleted in a
different fiscal period to the entered fiscal period. You would get two
positive entries in one period and a single negative entry in the next
period. Apparently this is by design.
Gary Parfrey
Dot Net IT Limited, Reg No 4412519
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael McWilliams
Sent: 25 July 2007 20:30
To: vantage@yahoogroups.com
Subject: [Vantage] Wrong PO price entered.
A PO was entered and the user entered in the wrong price. The item
was then received at the wrong price. How are people dealing with
this without having to delete the Receipt and then do it again after
fixing the price?
[Non-text portions of this message have been removed]