Proble in PO receipts

[shafee212]

Hi , I am facing problem during PO receipts . If I do a PO receipt using multi entry option (selecting multiple lot) , then Incorrect GL entries are generated .

Suggest me what to do ?

Thanks In Advance .

 

[Kishor Chari]

You need to be more specific what a/c are affected? Is single entry trans work ok?

 

[shafee212]

When I do po receipt of 10 qty without using multi entry option , I get correct GL entries like Total amount for debit and credit accounts

But when I do pO reciept of 10 qty by using Multi entry option ( says in two lots lt1 and lt2 5 each ) then getting wrong Gl total for both credit and debit accounts )

 

[Kishor Chari]

Now be specific on totals is there price or qty different. So the GL a/c are correct.

 

[shafee212]

difference in price is coming and I can see it in 3.21.1

Tran Nbr: 1271070 Order: PR649419 GRF10129
Trans Type: RCT-PO Revision: 0
Date: 02/02/10 Item Number: 50200002
Time: 22:04 Description: Mango Pulp - Totapuri
Effective Date: 02/02/10 Unit of Measure: KG
Remarks: Address: V9900041
User ID: g57668 Name: Godrej Harshey Ltd.
Program: xxvdporc.p Sales/Job:
Currency: INR Ship Type:
Qty Change: 2,150.0 Price: 36.34
Shipper Number: Inv Mov:
Ship Date: 02/02/10
Inventory Data
Site: F1 Begin Balance: 101,520.0
Location: INSP-MZ Quantity Change: 2,150.0
Lot/Serial: 100101sfs Qty Short: 6,235.0
Inv Status: N-Y-N Begin Loc Bal: 0.0
Supplier Lot: Loc Qty Change: 2,150.0
Grade/Assay: Expire Date: 15/02/10
Reference: GRF10129 Batch:
Cost Data
Material: 40.5667 Overhead: 0.00
Labor: 0.00 Subcontract: 0.00
Burden: 0.00 Cost Total: 40.5667
RCT-PO
Dr Acct: 13120100 R210
Cr Account: 22220200 R210
Amount: 87,218.41 GL Reference: IC100202000001
RCT-PO
Dr Acct: 60010100 R210
Cr Account: 22220200 R210
Amount: -7,524.79 GL Reference: IC100202000002


Tran Nbr: 1271071 Order: PR649419 GRF10130
Trans Type: RCT-PO Revision: 0
Date: 02/02/10 Item Number: 50200002
Time: 22:05 Description: Mango Pulp - Totapuri
Effective Date: 02/02/10 Unit of Measure: KG
Remarks: Address: V9900041
User ID: g57668 Name: Godrej Harshey Ltd.
Program: xxvdporc.p Sales/Job:
Currency: INR Ship Type:
Qty Change: 1,075.0 Price: 36.34
Shipper Number: Inv Mov:
Ship Date: 02/02/10
Inventory Data
Site: F1 Begin Balance: 103,670.0
Location: INSP-MZ Quantity Change: 1,075.0
Lot/Serial: 100101firstlot Qty Short: 4,085.0
Inv Status: N-Y-N Begin Loc Bal: 0.0
Supplier Lot: test1 Loc Qty Change: 1,075.0
Grade/Assay: Expire Date: 15/02/10
Reference: GRF10130 Batch:
Cost Data
Material: 40.5667 Overhead: 0.00
Labor: 0.00 Subcontract: 0.00
Burden: 0.00 Cost Total: 40.5667
RCT-PO
Dr Acct: 13120100 R210
Cr Account: 22220200 R210
Amount: 43,609.20 GL Reference: IC100202000003
RCT-PO
Dr Acct: 60010100 R210
Cr Account: 22220200 R210
Amount: 163,437.95 GL Reference: IC100202000004



Tran Nbr: 1271071 Order: PR649419 GRF10130
Trans Type: RCT-PO Revision: 0
Date: 02/02/10 Item Number: 50200002
Time: 22:05 Description: Mango Pulp - Totapuri
Effective Date: 02/02/10 Unit of Measure: KG
Remarks: Address: V9900041
User ID: g57668 Name: Godrej Harshey Ltd.
Program: xxvdporc.p Sales/Job:
Currency: INR Ship Type:
Qty Change: 1,075.0 Price: 36.34
Shipper Number: Inv Mov:
Ship Date: 02/02/10
Inventory Data
Site: F1 Begin Balance: 103,670.0
Location: INSP-MZ Quantity Change: 1,075.0
Lot/Serial: 100101firstlot Qty Short: 4,085.0
Inv Status: N-Y-N Begin Loc Bal: 0.0
Supplier Lot: test1 Loc Qty Change: 1,075.0
Grade/Assay: Expire Date: 15/02/10
Reference: GRF10130 Batch:
Cost Data
Material: 40.5667 Overhead: 0.00
Labor: 0.00 Subcontract: 0.00
Burden: 0.00 Cost Total: 40.5667
RCT-PO
Dr Acct: 13120100 R210
Cr Account: 22220200 R210
Amount: 43,609.20 GL Reference: IC100202000003
RCT-PO
Dr Acct: 60010100 R210
Cr Account: 22220200 R210
Amount: 163,437.95 GL Reference: IC100202000004


 

[Kishor Chari]

I dont understand price/cost all are correct and so is the calulations . The amount is correct. What is the issue?

 

[shafee212]

I dont understand price/cost all are correct and so is the calulations . The amount is correct. What is the issue?

when total qty is receved without using multi entry option -7,524.79 is amt , which is correct (credit entry)

when it is splitted in 2 lots , then wrong gl amount is calculated as it can be seeen (it is not adding up and showing positive value. Same error comes with standard program also .


here 2 receipts are done , one with single lot and other with multiple lot using multi entry option .

error comes in multi entry option.

 

[Kishor Chari]

What are the a/c descriptions?

Dr Acct: 13120100 R210
Cr Account: 22220200 R210
Dr Acct: 60010100 R210
Cr Account: 22220200 R210

 

[Kishor Chari]

What is the ver of mfg/pro?

 

[shafee212]

its eb2sp9 ..

Is it a standard bug .

 

[Kishor Chari]

If you are able to recreate this in standard version report to QAD. Cause I suspect the bug could caused by customisation.