UOM Code Missing - Shipped not Invoiced

MP_NAVMP_NAV Member Posts: 42
Multiple Sales Orders using Resources on the lines that have been shipped and not invoiced. The UOM Code is NULL on these lines. Can not invoice them because the UOM is blank, can not update the UOM Code because the Quantity Shipped does not equal Zero.

Any thoughts on a resolution? Is there specific code I can comment out to allow the UOM Code update? We are speaking of approx. 100 Sales Orders. (Undo Shipment does not work on non-Item line types)
-MP

Comments

  • SavatageSavatage Member Posts: 7,142
    Blank UOM suck no doubt. That's why when creating new item we have code to check if that field has been filled & if it wasn't it will not let you leave the item card.

    anyway..I was possibly thinking of an update report that inputs codes into blanks..
    .
    .
    SalesLine."Unit of Measure Code" := 'your code';
    SalesLine.MODIFY;
    .
    .
    filtering on blanks only

    Obviously your NSC with there license can change these codes for you via the internet. Have you tried that?
  • themavethemave Member Posts: 1,058
    have you tried to undo the shippment, from the sales order, navigate to the shipment document and select the function undo shipment.
  • MP_NAVMP_NAV Member Posts: 42
    Even with the Dev license we are unable to simply populate the code fields due to the Shipped Qty <>0.

    themave - undo shipment does not work for Resources (wish it did though)

    I suppose I will need a report that populates the null fields while circumventing the NAV code that prevents this if the line has already shipped.

    Open to other ideas still though... kinda surprised that the Dev license couldn't populate these blanks though.
    -MP
  • themavethemave Member Posts: 1,058
    just a guess, but it would probably be easier to modify the undo shipment routine, it appears to just set a filter to only undo items,

    if you navigate on a resource shipment, there are not any value entries or ledger entries that are made, it should be fine to undo a resource shipment.

    then undo the shipments, change the code back.

    correct the lines and ship and invoice.

    not a developer so can't actually try it out.
  • Alex_ChowAlex_Chow Member Posts: 5,063
    If it's a resource, the UOM won't matter that much.

    What you can do is ask your solution center to do the following:
    1. temporary remove the UOM check for resources when you post the invoice.
    2. Post those invoices
    3. Revert it back
    4. Modify the posting routine to check for the UOM during shipping and receiving.

    This will be a lot easier than trying to modify the undo shipment process.
  • mukshamuksha Member Posts: 274
    You can also ask your solution provider to do the following:

    1. temporary remove the UOM check for resources and update/modify on the required lines to be posted and any other lines.
    2. Post those invoices and add the check for UOM.
    4. Place a check for UOM during making a sale order/Purchase order.
    Mukesh Sharma
  • MbadMbad Member Posts: 344
    What themave sais should be done. Undo the shipments, and make a report that fills the UOM code without validating, then re-ship. When you have made mistakes its always better(if possible) if you can get back to square one, correct the faulty code and re-post.

    Guess this is one of those 'be sure what you code is correct, and remember to test what you make' lessons.
Sign In or Register to comment.