When FOC quantity is entered in Decimal for receiving, the quantity is not correctly calculated. The decimal figure is not taken into account. Consider the below business scenario

Business Scenario
When customers buy 10 cartons of Milk (12 Packets in 1 carton), suppliers give 5 packets FOC. The system does not cater for this exact quantity to be received in the system.

Setup

• Create item AAA01 with "UOM" as "Each"
• Create a "UOM" as "PACKOF40"
• Set the "UOM" conversion for "PACKOF40" to "Each" with a conversion factor of 40.

Scenario 1 (Correct functionality)

• Create a PO for AAA01 with UOM as PACKOF40
• On the receiving screen enter FOC as 3.
• Receive the PO.
• 519 is updated as 40 after receiving PO.
• Inventory adjustment is created for 120 items (40*3).
• The above is correct.

Scenario 2 (Functionality to be improved)

• Create a PO for AAA01 with UOM as PACKOF40
• On the receiving screen enter FOC as 2.5. The user has received 2 and a half cartoons free.
• Receive the PO.
• 519 is updated as 40 after receiving PO.
• Inventory adjustment is created for 80 items (40*2).
• 0.5 is not considered.

Improvement.

Option 1: If receiving for FOC items is made with decimals, use it to calculate FOC quantity
Option 2: If above is difficult to achieve, introduce a new field for UOM of FOC quantity

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

1. Corrected the back-office purchase receive screen to save the full decimal amount for FOC items.
2. Added Adjustment Date for FOC adjustment entry to be same as receive date.

Wrong comment on wrong case

System test completed. The following were done:

• Create item AAA01 with "UOM" as "Each"
• Create a "UOM" as "PACKOF40"
• Set the "UOM" conversion for "PACKOF40" to "Each" with a conversion factor of 40.
• Create a PO for AAA01 with UOM as PACKOF40
• On the receiving screen enter FOC as 2.5. The user has received 2 and a half cartoons free.
• Receive the PO.
• 519 is updated as 40 after receiving PO.
• Inventory adjustment is created for 100 items (40*2.5). Posted Adjustment. Inventory was updated to 140 available.

Note that on Category, Sub-category and UOM screen, a validation message is displayed when New button is clicked. This has been resolved in beta2.

Hi Alvis,

Below is the test results.

When are unable to enter amounts that is greater than 3 digits as the FOC items. Refer to item 6.

Test Environment

• Version 9400
• Database - LINKSOFT on QA1.
• Application on QA1 
• OS - Windows 7

Thanks

Rashna

Hi Rashna,

The current design only allows for 2dp in FOC. If you need to change the screen design, please log a new case.

There is a new case in version 9.5 that will allow for FOC items to be entered in PO entry screen as a separate line.

regards
Alvis

Hi Sanjay, 

This case has been passed as per comments 6 and 7.

As per the discussions with Vineet and I.

1. For scenarios where conversion rate is more than 2 digits. Users can round the receiving FOC quantity nearest to 2 dp.
2. This will create an adjustment where the qty can be altered before receiving.
3. For example, referring to item no 6 in the comment 6, 0.175 can be converted to 0.18. The adjustment will be created with quantity 7.20 instead of 7.
4. Users can edit the qty before posting adjustments.

Thanks 

Rashna 

Hi Sanjay, 

I have documented the case under 

Backoffice -- Purchasing -- Receive PO.

The details have been added

1. Steps to receive PO.
2. Details of the contents on the PO screen.

Thanks

Rashna