Split a bulk purch using Item Reclass then allocate Item Chg

ajmalsherif
ajmalsherif Member Posts: 111
edited 2012-11-27 in NAV/Navision Classic Client
I will be most grateful for any suggestions how this scenario can be undertaken:

1- purchase receipt of bulk item 100T as lot number 1001220A at £ 40,000.00
2- split into two batches of 50T each, so first batch of 50T has lot number as shown above and second batch given a new lot number 1001220B - each at £20,000.00

I have done to this point using item reclassification journal, however i need to assign a transport Item Charge to the second batch (only) of amount £1000.00.
Grateful for any suggestions of how the Item charge can be allocated to the second batch so that its value shows as £41,000.00.

Thanks in advance

Comments

  • MarkHamblin
    MarkHamblin Member Posts: 118
    You won't be able to assign an item charge to a partial lot unless you do multiple receipts for the item. I.e., receive the 100T by posting 2 receipts - that's really the best choice.

    If for some reason you can't do that, I don't think you have many clean options. Probably the best solution of the ones I can think of is instead of doing a reclass to change the lot #, do a £0 out/in purch order to change it (e.g., line with -50T for lot "A" and another with 50T for lot "B" at the same cost). That "changes" the lot # and gets you a separate receipt line to add the charge to in the future.

    If the original PO hasn't been invoiced, you won't be able to invoice the out/in one until you get the actual costs for the original purchase or you'll probably have some strange-looking variance entries.
  • ajmalsherif
    ajmalsherif Member Posts: 111
    Mark - thanks for your suggestion, however the -50T using a PO will result in a remaining quantity, when in fact we have received stock of 100T.
  • MarkHamblin
    MarkHamblin Member Posts: 118
    The point is to do two lines on the PO: a -50T and a +50T so that there is no net change to inventory quantities, only to the lot #. The goal is to create a second receipt for part of the original purchase to apply the item charge to.

Categories