How to correct item value entries?

hazem

Hello,
I have a problem with some value entries: sometimes for the same transaction, the cost per unit on the Receipt line is different from the cost per unit on the invoice line...The customer asked to solve this problem...He want to have the same costs on invoice and receipts that are relative to a same transaction...What is the best way to correct cotsts per unit on value entries?

Arhontis

I guess you don't "receive and invoice" the same time, but invoice at a later time, right?

hazem

Yes that's right...If i recieve and invoice at the same time there's no problem with costs...So is there a solution to correct value entries so that they contain
same costs for invoice and receipt when i recieve and then i invoice?

Arhontis

It would be a problem if you had different values in the "Value Entry" table. You problem is just the difference of the Cost per unit of the "Receipt Line" and the "Posted Invoice Line"?

In that case, since the costs on the receipt line is just an information field you could add some code in the post that finds the appropriate receipt line for each invoice line and modify the cost per unit to match the correct that is entered byt the user for the invoicing.

But remember that an item might be received alot of times, or be cancelled and re-received (like partial receive a total quantity of 10 as one item per week and invoice them all together, so you have 10 receipt lines for one invoice line).

ssingla

When do you run the adjust cost batch job?

Rene70

ssingla wrote:

When do you run the adjust cost batch job?

We are running this job every night. It's needs round about one and a half hour to adjust all entries.