Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#706 Physical Inventory-Multiple Lines for same Product & Locator

closed
nobody
None
5
2008-01-16
2007-08-02
contract16
No

Hi,

What is the correct functionality if a user, within Physical Inventory, adds multiple lines with the same Product and Locator?

From a business process this makes no sense and should never happen. But Compiere allows a user by mistake to manually enter duplicate lines and save them. However, the second line does disappear when toggling views or going back to the header.

It would be nicer if the system, when saving the line, checked to make sure that the product/locator combination was unique for that count.

Thanks
Jeff

Discussion

1 2 > >> (Page 1 of 2)
  • Kathy Pink
    Kathy Pink
    2007-08-03

    • assigned_to: sboda --> kviiksaar
     
  • Kai Egbert
    Kai Egbert
    2007-08-06

    Logged In: YES
    user_id=1784380
    Originator: NO

    Hi Jeff,

    this is a wanted and documented behaivior of Compiere and used by customers.
    You can only write your own logic for that.

     
  • Kai Egbert
    Kai Egbert
    2007-08-06

    • status: open --> pending
     
  • contract16
    contract16
    2007-08-06

    Logged In: YES
    user_id=1742483
    Originator: YES

    Hi Kai,

    Thanks for the reply. Interested to know why a customer would want to enter the same product in the same location twice? I can't think of a business reason for it.

    The method that Compiere uses to handle it isn't that good and could be improved (just loosing a record isn't that a good). The user should be given a message indicating that they have done performed an illegal action.

    Thanks
    Jeff

     
  • contract16
    contract16
    2007-08-06

    • status: pending --> open
     
  • contract16
    contract16
    2007-08-06

    Logged In: YES
    user_id=1742483
    Originator: YES

    Hi Kai,

    Thanks for the reply. Interested to know why a customer would want to enter the same product in the same location twice? I can't think of a business reason for it.

    The method that Compiere uses to handle it isn't that good and could be improved (just loosing a record isn't that a good). The user should be given a message indicating that they have done performed an illegal action.

    Thanks
    Jeff

     
  • contract16
    contract16
    2007-08-06

    • status: open --> pending
     
  • contract16
    contract16
    2007-08-06

    • status: pending --> open
     
  • Kathy Pink
    Kathy Pink
    2007-08-06

    Logged In: YES
    user_id=329831
    Originator: NO

    duplicate lines should appear if you are using instance attributes and they are assigned.
    Kai, did you try to replicate. It seems like if you can replicate that the duplicate line disappears when switching views there is an issue here
    Kathy

     
  • Kai Egbert
    Kai Egbert
    2007-08-07

    Logged In: YES
    user_id=1784380
    Originator: NO

    Hi Kathy,

    I've tested it on GardenWorld yesterday with two Products, one without and one with Attribute Set (PChair). In both cases the system creates a summery entry if I generate a Physical Inventory with same product and locator twice or more.

     
  • Kai Egbert
    Kai Egbert
    2007-08-07

    Logged In: YES
    user_id=1784380
    Originator: NO

    Hi Kathy,

    Replicated.

    Jeff has send me a new instruction how to reproduce the problem. See attached file.
    The Problem occurs not on Physical Inventory Documents but on Material Receipts. It creates a new line in Table M_Storage for each Material Receipt Line even if the product is the same.
    File Added: MultipleLines.txt

     
  • Kai Egbert
    Kai Egbert
    2007-08-07

    Instruction how to replicate multiple lines for Material Receipts

     
    Attachments
  • Kai Egbert
    Kai Egbert
    2007-08-07

    • assigned_to: kviiksaar --> kmpink
     
  • Kai Egbert
    Kai Egbert
    2007-08-07

    Instruction how to replicate multiple lines for Material Receipts

     
    Attachments
  • Kai Egbert
    Kai Egbert
    2007-08-07

    Logged In: YES
    user_id=1784380
    Originator: NO

    Hi Kathy,

    Replicated.

    Jeff has send me a new instruction how to repuduce the problem. See attached file.
    The Problem occurs not on Physical Inventory Documents but on Material Receipts. It creates a new line in Table M_Storage for each Material Receipt Line even if the product is the same.
    File Added: MultipleLines.txt

     
  • contract16
    contract16
    2007-08-07

    Logged In: YES
    user_id=1742483
    Originator: YES

    Hi,

    Think these comments relate to 1769240, not this request.

    Jeff

     
  • Kai Egbert
    Kai Egbert
    2007-08-07

    Logged In: YES
    user_id=1784380
    Originator: NO

    Hi Kathy,

    Jeff is right. We've mixed up this Support Request with some other Mail correspondence.

    The Problem here is only that it is possible to ad a product on a same locator multiple times to one Physical Inventory Document. Some of our Customers are using the Physical Inventory this way and there is no negative effect on doing it this way.

     
  • Kathy Pink
    Kathy Pink
    2007-08-07

    Logged In: YES
    user_id=329831
    Originator: NO

    Kai,
    Are there any functional problems with this? Can you replicate the stated issue where a line disappears when toggling views?

     
  • Kathy Pink
    Kathy Pink
    2007-08-07

    • assigned_to: kmpink --> kviiksaar
     
  • Kai Egbert
    Kai Egbert
    2007-08-08

    Logged In: YES
    user_id=1784380
    Originator: NO

    Hi Kathy,

    No I can't replicate this and there are no functional problems with it. The second line stays visible if I select same product and locator twice or in any other combination. And the results after complete are also correct.

     
  • Kai Egbert
    Kai Egbert
    2007-08-08

    • assigned_to: kviiksaar --> kmpink
    • status: open --> pending
     
  • contract16
    contract16
    2007-08-10

    Logged In: YES
    user_id=1742483
    Originator: YES

    Hi,

    I've managed to get working on the latest 2.6.1 build where it doesn't loose the second line.

    Discussed with Kai the business reasons why, and we agree that the customers who want to add the same location/product combination twice on a count are probably unique. Can we change this to an feature request to have a flag somewhere which allows or disallows this?

    Thanks
    Jeff

     
  • contract16
    contract16
    2007-08-10

    • status: pending --> open
     
  • Kathy Pink
    Kathy Pink
    2007-08-10

    • assigned_to: kmpink --> spaski
     
  • Steve
    Steve
    2007-08-10

    Logged In: YES
    user_id=1837418
    Originator: NO

    I will change this to a Feature Request for you.
    Steve

     
1 2 > >> (Page 1 of 2)