Hi Sanjay,

Issue: Quantity for color size items is not updated when a transfer is created from copy record.

Steps to Replicate

1. Create a color/ size product CLSIZ. Adjust in 10 products with size Large and color as blue. Do an adjustment at Retail.
2. Enable the configuration - "Automatically receive transfer when shipped" on 233.
3. Create a  transfer with quantity as 3 from RETAIL to MAIN. 
4. Ship the transfer, Verify the stock on 519 and on the movement report. Stock at "Retail" should be 7 and 3 at "MAIN".- Pass
5. On 524-1, copy the above transfer and submit the request with quantity 2.
6. Ship the transfer, Verify the stock on 519 and on the movement report. Stock at "Retail" should be 5 and 5 at "MAIN". - Failed, Stock for MAIN on 519 is 3

Test Environment

• Version 9408 Beta 6
• LINKSOFT on QA1

Hi Rashna, when copying a transaction, the system will not copy the Serial Lot, Lot Bin,, and Color Size detail breakdown. This is by design.

RegardS
Sanjay

Hi Alvis, 

As per the GTM session (Sanjay, Alvis and Rashna), this is an issue in the case it causes a  mismatch on 519 and Movement Report.

Please address the case.

Thanks

Rashna

1. The following changes were made(Include Database object names, Program classes and any other relevant information):|

1. The following has been completed:
2. Migrated Receive Transfer code to a procedure and linked this to receive transfer button
3. Refactored receive transfer data entry to use procedure updates
4. Removed triggers and use procedures to automatically receiving transfer when shipped
5. Removed trigger for integration to HR module for employee issuable items. 
6. Removed functionality of "Inventory to HR Integration" as this is a client specific customization and needs to be handled separately. If a client is using this customization please do not implement this upgrade.
7. When Submit/Ship/Receive buttons are clicked, we save the record and proceed with the user request.

Hi Sanjay, 

This case has been successfully tested.

Test Plan

• Create 2 items R1001 - Purchase Item, R1002 - Lot Bin item, R1003 - Color Size Item.
• Do an adjustment in as below.
  • R1001 -100 @ $8.00
  • R1002 -10 @ $8.00
  • R1003 - 10 @ $8.00
• Enable the configuration - "Automatically receive transfer when shipped" on 233.
• Create a Transfer from RETAIL to MAIN as below
  • R1001 -5
  • R1002 -1
  • R1003 - 1
• Ship transfer. The Ship should be successful. 519 and Movement report should be updated successfully. Note: The ship uses the BIN from which the transfer was requested when auto receiving transfers.
• File Copy the above transfer and ship the request. 519 and Movement report should be updated successfully  - Pass
• Verify that the color size and lot in details have the correct quantity compared on the available quantity on 519.
• Tested receiving transfers with config disabled. Users can update the BIN when receiving transfers.

Test Environment

• Version 948 Beta 8
• LINKSOFT on QA 1 - Beta 1

Next Step - Rashna to document the case

Hi Rashna, in 949 we have corrected the Inventory master field names as below:

1. Color/Size Matrix ~> Product Matrix
2. Matrix Row ~> Row Matrix
3. Matrix Column ~> Column Matrix

Hi Sanjay, 

I have tested the case as per comment 7:-

We have corrected the Inventory master field names as below:

1. Color/Size Matrix ~> Product Matrix
2. Matrix Row ~> Row Matrix
3. Matrix Column ~> Column Matrix

The below issues has been identified.

• In version 948 Beta 8. The matrix was labeled as "Color/Size Matrix". Hence during implementation, we would select the "Color" for the row and "Size" for the columns.
• The system is hardcoded to show the details as above.
• However, if we change the setup to be as "Size" for the row and "Color" for the columns. Then the color size details are incorrectly reflected. This is an issue with Inventory Adjustment, Stock Take, Purchase and Transfers.

1. Create item R1005 - Color Size Item. Row Matrix = Color and Column Matrix = Size.
2. Create item R1006 - Size Color  Item. Row Matrix = Size and Column Matrix = Color.
3. When creating an Inventory Adjustment, Stock Take, Purchase and Transfer. The color size details for product R1006 have incorrect labels. Refer to Figure 1.

Test Environment

• Version 948 Beta 8
• LINKSOFT on QA1 - Demo Setup

Figure 1:

Hi Sanjay, 

This case is a pass as per comment 6.

Documentation on the case has updated under Backoffice -- Inventory -- Technical Reference -- Inventory Configuration.

Thanks

Rashna