Product Receipt - No Physical Cost in inventory transaction and SubLedger invoentory

(1) Share

Report

Posted on by Mohamed Shuhaib

Hi All

Greetings !

There is a product receipt which is posted and there is no physical cost amount in inventory transaction and subledger .

We check the trial balance there is an amount posted .

Also we noticed that in the voucher transaction there is no line for product recepit (item Group) account , but in the voucher transaction there is line for purchase expenditure uninvoiced (item Group) account .

could you please help out in figuring out the issue ?

Categories:

Supply Chain

Financial Management

All responses (14)

Answers (0)

André Arnaud de Cal... 290,263 Super User 2024 Season 2 on at

Like (0)

Report

Product Receipt - No Physical Cost in inventory transaction and SubLedger invoentory

Hi Mohamed,

With all the suggestions, it is now too hard to help you further via the community. You can consider hiring a consultant to do a deep dive into your environment.
Mohamed Shuhaib 28 on at

Like (0)

Report

Product Receipt - No Physical Cost in inventory transaction and SubLedger invoentory

Hi Andre ,

Field Ledger account has no value on the PO lines .
André Arnaud de Cal... 290,263 Super User 2024 Season 2 on at

Like (0)

Report

Product Receipt - No Physical Cost in inventory transaction and SubLedger invoentory

Hi Mohamed,

I Apologise, I used a wrong label in my reply. There is a field called Ledger account. Please check if this field has a value on the PO lines having the issue.
Mohamed Shuhaib 28 on at

Like (0)

Report

Product Receipt - No Physical Cost in inventory transaction and SubLedger invoentory

HI Andre ,

There is no main account field on the line details section .
André Arnaud de Cal... 290,263 Super User 2024 Season 2 on at

Like (0)

Report

Product Receipt - No Physical Cost in inventory transaction and SubLedger invoentory

Hi Mohamed,

A main account field is on the line details section on one of the tab pages.
Mohamed Shuhaib 28 on at

Like (0)

Report

Product Receipt - No Physical Cost in inventory transaction and SubLedger invoentory

Hi Andre

We have seen this behavior in Multiple purchases.

The purchase order is not linked to any project , but its linked to purchase requisition .

The Scrap field is not enabled on the PO line.

where can we see in the Purchase order expense main account filled on the purchase order line ?
André Arnaud de Cal... 290,263 Super User 2024 Season 2 on at

Like (0)

Report

Product Receipt - No Physical Cost in inventory transaction and SubLedger invoentory

Hi Mohamed,

Your settings are correct. It may be related to the data entry on the purchase order or a bug. Have you seen this behavior for multiple purchases or is this the only one? Is the purchase order linked to a project or was the expense main account filled on the purchase order line? Was the Scrap field enabled on the PO line?
Mohamed Shuhaib 28 on at

Like (0)

Report

Product Receipt - No Physical Cost in inventory transaction and SubLedger invoentory

Hi Andre ,

Item is regular item .

Screenshot of Item Model Group setting .
André Arnaud de Cal... 290,263 Super User 2024 Season 2 on at

Like (0)

Report

Product Receipt - No Physical Cost in inventory transaction and SubLedger invoentory

Hi Mohamed,

What settings do you have on the item model group? Is this a service or regular item?
Mohamed Shuhaib 28 on at

Like (0)

Report

Product Receipt - No Physical Cost in inventory transaction and SubLedger invoentory

Hi Andre ,

Please find below screenshot of voucher transaction and item group . the product type is item . item model group is FIFO .

Product receipt voucher transaction

Invoice Voucher transaction