process sales order

nostran

hi,

i am processing a sales order for an item that i don't have on stock. the unit cost of the item is zero.
i purchase the item and post the sales order.
The sales order is posted with a unit cost of zero, as the sytem does not refresh it while posting the order.
When checking the statistics of the posted invoice, the profit % is 100 as to be expected. The sales commision report and all sales report are also wrong.

any solution on this one :?:
thanks

RobertMo

Have you run Adjust Cost - Item Entries batch job ?

nostran

hi,

i've run adjust cost item entries, the problem arises because at the time of posting the sales order, navision does not refresh the unit cost before proceeding with the updates.

DenSter

Navision doesn't refresh the cost/price during posting by design, because it assumes that they are correct. When you enter an Item on a sales order, the system will find the best price and it enters it on the line, after which you can still change it on that line. Following your logic, the system would change it back to the original price. Navision assumes that the user knows what they are doing and that they entered the correct price to use.

RobertMo

So you need to Validate "No." either manually or automatically (in code) before posting. Of course with all the consequences that whole sales line will be filled with the defaults and manual changes will be forgotten.

Maybe write your own function that refreshes only "Unit Cost" in sales line. Beware of other fields that may be dependant on that change.

To overcome this you can enter Sales line with an item and all other data. Zoom it to get all values in Excel. Then change cost on Item card and then validate No. in Sales Line. Zoom again and compare which fields have changed. This way you can add your own function to update “Unit Cost” and other fields in sales line, before posting.

And finally the Unit cost on Item card is updated with Adjust Cost - Item Entries batch job, so if your cost on Item Card is not up to date, neither your Statistics will be...

Maybe start to think to get statistics based on “Item Ledger Entries” and “Value Entries” instead of “Sales - Invoice Lines”...

DenSter

Validating the 'No.' field does update the cost, but it also does a lot more than just that. If you really want the system to update the cost before posting, I would write some code in the posting routine to refresh the cost, rather than validating the 'No.' field. Also, make the cost fields not editable or remove them from the forms, since whatever the user changes, it will be changed back by the system anyway.

chaswin

Is the posting date of your purchase later than the sales order date? This would cause the cost to remain at zero. Alternatively have you posted only the purchase receipt? As a general rule, once the purchase is processed with an equal or earlier posting date, the adjust cost will correct the invoice line cost.

Incidentally, if you create a sales order whilst there is no stock, the system will pick up a zero unit cost. However, if there is stock when you actually post the sales order (say a day or two after initial entry) although the unit cost is zero on the sales line, the system will use the correct average cost!

Remember that the cost used at time of posting is only the initial estimate, it can be changed by the Adjust Cost/Post Cost to GL periodic activities later the same day. For instance, if you have a receipt late in the day, prompting a new average cost, the adjust cost will adjust every stock movement for the item that took place on the same day, even if it was earlier in the day. This is because the adjust cost processes positive adjustments before the negatives when calculating an average for the day. In this case all the average costs used earlier in the day are automatically wrong.