Our company would create Sales Invoice (with an earlier posting date) before create Purchase Invoice. And it is required to match the cost of each PI to SI one by one. When we tested with a specific costing method item (create a SI before create PI), system prompt me that the item cannot be fully applied. I guess that system would try to match the SI item (by serial no and lot no) with the inventory. If the specific item haven’t stock in yet, then it would not allow to post the SI. right?
We are wonder a workaround method on it, any ideas?
BTW, our client would like to have a report showing the item relation between the SI AND PI, is this report already exists in the inventory module of NAV 2009?
Specific costing method relies on serial number to identify the exact item you are selling, it is then applied to the item entry. If no item entry exists then obviously this is impossible. Could you receive the item in, if you know the serial number, into some kind of In Transit location?
The serial number is issued by ourselves. But the problem is, we received and post the purchase invoice after we post the sales invoice, hence the PI date must be later than the SI date. And we have to map the cost of the item in SI to the specific PI.
can we update the serial no to a posted sales invoice?
No. And a modification will NOT help you, only create mess, as all costing is already processed, if you change serial forcefully afterwards, it is of no use.
Specific costing is introduced with concrete workflow in mind, you can’t expect that it will still work if you forcefully turn everything upside down…
Can you explain the business reason behind this process? Is it the invoice, or is the receipt processed prior to the outbound transaction?
You have it, you must do to invoice it. So your process sees you want to invoice out prior to receipt in - why? If this is business critical then you may have to live with the downside of the application of costs to cope with the acceptance of the business practice.
I have a strong feeling they create these serials only to be able to use Specific, which requires them - and, in turn, they have decided to use Specific, as they have this business need to trace Item from PI to SI… but actually they are trying to do it vice versa, which, of course, do not, and CAN NOT work.
Not using Orders, but Invoices, already looks like that they do everything post factum, when physical movement has taken place,