Retail statement posted but inventory reserved physical still there

(0) Share

Report

Posted on by hatem.bouhdida

Hi,

I'm faced to an issue with reserved physical quantities. In retail module, when we calculate a statement, quantities are reserved in the inventory, and later when the statement is posted, all reserved quantities will be reset to zero and physical inventory is updated.

The current situation is that the statements are posted but physical reserved quantities for some items still exist in the inventory not as expected.

transactions exist in the inventtrans and inventtransorigin with referencecategroy=150 (statement) in spite statements are posted.

who knows the cause of this issue? and how to sort this out?

Thank you

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

AamirKhan 85 on at

Like (0)

Report
Copy link

Link copied!

I am also facing the same issue in R3 CU9, any solution will be highly appreciated.

Thanks in advance.

Was this reply helpful? Yes No
Suggested answer

Mohd irfan mehdi 956 on at

Like (0)

Report
Copy link

Link copied!

hi hatem,

this is the most common problem in all the version that physical reserved quantities not updated against the statement number event the statement get successfully posted.

in this case you have two option.

1. First right down a JOB(AOT) with the help of your technical team to remove this physical reserved.

condition: 1. In RetailTransactionTable check all the statement lines updated with invoiced id and status should be posted

2. write same condition in RetailTransactionsalesTrans.

3. verify that all the statement line get posted successfully with all the discount and tax

second option

1.Go to Inventory On-hand

2. select the line click on transaction button

3. again select the physical reserve line and click on inventory option and then select the reservation option.

4. in the reservation option there is one field that is reserved quantity from where you can remove the physical reserved quantity.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

We get this issue every time whenever statement doesn't posted properly . But actually statement posted , sales order posted, payment journal posted .

Here below the job which I used to release the reservation against retail statement .

static void removeReservation_RetailStatement(Args _args)

{

InventTrans InventTrans,InventTransDel ;

InventTransOrigin InventTransOrigin,InventTransOriginDel;

RetailTransactionSalesTrans RetailTransactionSalesTrans;

RetailTransactionTable RetailTransactionTable;

while select inventtrans

join InventTransOrigin

where inventtrans.InventTransOrigin == InventTransOrigin.RecId

&& InventTransOrigin.ReferenceCategory == InventTransType::Statement

&&

(inventtrans.StatusIssue == StatusIssue::ReservPhysical || inventtrans.StatusReceipt == StatusReceipt::Ordered)

join RetailTransactionSalesTrans

where RetailTransactionSalesTrans.inventTransId == InventTransOrigin.InventTransId

&& RetailTransactionSalesTrans.inventStatusSales == RetailInventStatusSales::Posted

&& RetailTransactionSalesTrans.transactionStatus == RetailEntryStatus::Posted

&& RetailTransactionSalesTrans.statementId == InventTransOrigin.ReferenceId

join RetailTransactionTable

where RetailTransactionTable.transactionId == RetailTransactionSalesTrans.transactionId

&& RetailTransactionTable.entryStatus == RetailEntryStatus::Posted

&& RetailTransactionTable.statementId != ''

&& RetailTransactionTable.salesOrderId != ''

&& RetailTransactionTable.invoiceId != ''

&& RetailTransactionTable.type == RetailTransactionType::Sales

&&

{

if (inventtrans.InventTransOrigin && InventTransOrigin.InventTransId)

{

delete_from InventTransDel

where InventTransDel.InventTransOrigin == inventtrans.InventTransOrigin;

delete_from InventTransOriginDel

where InventTransOriginDel.InventTransId == InventTransOrigin.InventTransId;

}

}

}

Was this reply helpful? Yes No
Suggested answer

Asif Sanaullah 20 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your help!

Was this reply helpful? Yes No
Suggested answer

Asif Sanaullah 20 on at

Like (0)

Report
Copy link

Link copied!

...

Was this reply helpful? Yes No
Adhha Adnan 420 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I managed to unreserved the item with posted statement. But the concern is the OHB.

Available Quantity = 12 units

Reserved Quantity = 2 units

In this situation, after unreserve the reserved quantity my available quantity will be 14 units.

My concern is about the data accuracy due to this issue. This due to our physical units are only 12 units.

Appreciate advise on this.

Thank you.

Was this reply helpful? Yes No