Serialization implementation - Sage 300 v2017 I/C (Help!)

SOLVED

We just started using serialization and we have a few items in inventory (received before the item had the serial number flag turned on) that we wanted to record serial numbers for when we shipped. So I went into Serial / Lot Reconciliation and added serial number receipts for them so the serial numbers would be available.

One of the items had not yet had the PO invoice applied against the receipt, and when we try to post the PO invoice now, we get "Serial/lot's quantity does not match the transaction quantity for item" and are unable to post the invoice (or do anything).

I don't want to turn on the “Allow Serial Quantity to be Different from the Quantity in the Entries” flag for this item - any ideas on how to fix this?

Sage 300 v2017

Parents
  • +1
    verified answer

    I believe you should be able to turn off (temporarily) the Serial Number flag on the I/C Item if via export/import. Then post your PO Invoice and day end. Turn the Serial Number flag back on for the Item if via export/import. Once that is done, you will have to reconcile your serials again.

  • 0 in reply to Team Equation

    Thanks - I will try that. As is always the case, I am finding out after implementation of all the things I should have known in advance!

  • 0 in reply to Microfiche

    I hear ya. Serials and lots are tricky to implement on in-use items.

  • 0 in reply to Team Equation

    Great - that worked and allowed me to post the invoices.

    However, I am unable to use the reconciliation function to add serials to that PO Invoice - I assume because they were posted as unserialized?

    Would I then use a serial receipt (instead of PO Invoice) and use the I/C cost to add the serial to the item?

  • 0 in reply to Microfiche

    You need to turn the Serial Number flag back on for the Item if via export/import. Then you can reconcile and receive serials.

  • 0 in reply to Team Equation

    Sorry - should have pointed out that I did that first. Yes, it is re-imported and on in I/C, but my guess is there is a flag in the PO invoice that indicates that it is not serialized?

    If I try to use that PO invoice to add a serial in reconcile - it shows no items available.

  • +1 in reply to Microfiche
    verified answer

    You won't be able to add serials to that invoice. That PO/Receipt will have to be completed as a non-serialized transaction. You will have to add the serials via the serial/lot reconciliation.

    Sometimes I get this wrong. And sometimes you will need to (with the serial flag off) adjust out the non-serialized amount with a both decrease, day end, then (with the serial flag back on) adjust back in that quantity and assign it serials.

    In fact, while you can adjust out from I/C Adjustments, I think you would need to adjust back in the quantities via I/C Transactions > Receipts in order to assign it new serial numbers.

  • 0 in reply to Team Equation

    Thanks for all your input! Very much appreciated.

    I assumed that if the Serial / Lot reconciliation gave an option to pick a PO invoice that you could add a serial to this if the item was NOT serialized before the PO Invoice was posted.

    I will go with a serial receipt in Serial / Lot reconciliation, which seems to work OK.

    One last question - the "cost" it requests when you do a receipt in Serial/Lot Reconciliation - it that a separate costing just related to serial numbers? I tried making a serial receipt in a test database with zero cost in the cost field, and it didn't affect the I/C costing when I did a shipment later - i.e. the cost was the average I/C cost as it should have been. Serialization doesn't create separate cost buckets or anything?

  • 0 in reply to Microfiche

    Yes, the serial costing is separate. The costs in IC Location Details have the accounting impact, but the serial costing should be correct if at all possible.

    You can see at a glance where there are variances if you run the I/C Stock Control Reports > I/C Serial/Lot Number Qty On Hand report, with the "Show only items with IC Quantity Variance" box checked.

    Once you have your serialized reconciled the first time, the system doesn't easily let it get out of balance again.

Reply
  • 0 in reply to Microfiche

    Yes, the serial costing is separate. The costs in IC Location Details have the accounting impact, but the serial costing should be correct if at all possible.

    You can see at a glance where there are variances if you run the I/C Stock Control Reports > I/C Serial/Lot Number Qty On Hand report, with the "Show only items with IC Quantity Variance" box checked.

    Once you have your serialized reconciled the first time, the system doesn't easily let it get out of balance again.

Children
  • 0 in reply to Team Equation

    Another question that has come up...

    We have back-orders for items in Order Entry that should now be serialized. The item is marked as requiring a serial number in I/C Items. However, OE does not check back with I/C Items (like PO seems to do with receipts), so it will not look for a serial number because the item did not require serialization when the sales order was originally posted.

    I am assuming that this is based on the SLITEM switch in OEORDD? Would there be any possible negative effects to changing that field to 1 for the back-ordered items that now require serialization? It is either that, or I have to go back and change all those items to unserialized, and then turn it back on after they are shipped and invoiced, or delete and add back each affected detail line in OE.

  • 0 in reply to Microfiche

    I would be inclined to delete the line and re-add. I've never tested editing the tables in this situation. I would not recommend editing the tables. In a module like OE, with huge superviews, there's probably a lot more going on than that one field in the detail line.

  • 0 in reply to Team Equation

    Damn! Not the answer I was hoping for!
    I am not going to be popular when I tell someone they have 80 OE detail lines to re-enter! Worried