Allocated quantity

(0) Share

Report

Posted on by Rosemary

Good day,

A receipt was done for an item, which according to the system posted though. I am unable to invoice the item because it is saying 'qty allocated'. I am unable to view where it is allocated. I have run check links and reconcile but the scenario was not fixed. We use Field Service but the receipt was not done via In Transit.

I have run the scripts to view allocation as per module, didn't come up with any results.

The only other solution, I am thinking, is an update statement, but I am unsure what I am changing, am I just updating the allocated quantity per site to '0'

Regards

Rosemary

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (9)

Answers (0)

Rosemary 10 on at

Like (0)

Report

Good day,

I ran an Item Reconcile from PSTL and received this message relative to the item number,

'IV00102 has allocations with no matching detail', how do I work around this?

What 'detail' is it referring to?

Regards

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

It is most likely referring to IV00101.ATYALLOC having a value with no matching line in SOP10200. Pull up the item in GP and go to quantity/item. You will most like see a qty there.

You can run item reconcile under GP Inventory Utilities to correct this.

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report

Thank you Richard for your response, but I am not seeing that field in IV00101. The Item number is there though in that table. Via item inquiry the item number is there 1 'on hand', 1 'allocated'.

Regards

Rosemary

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

The allocated quantity is in IV00102. That is what the Quantity/Site screen will display. Running IV reconcile should fix this if there are no lines allocated in the sales order work tables.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Sorry for the typo. We are in the middle of an ice storm and it is 12 degrees.

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report

No problem, don't envy you guys.

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report

Thank you Richard for mentioning the SOP table, it appears the allocation was due to the invoice. I had initially only did the reconcile on Purchasing and Inventory. But when I did the Sales, it pulled the invoice number and cleared the allocated quantity.

Regards

Rosemary

Was this reply helpful? Yes No
Joseph Markovich 3,976 on at

Like (0)

Report

Hi Rosemary!

I remember reading a support document from Microsoft the order you should run reconcile when something is not right.

When I have to run reconcile about some data not being correct -- especially with inventory numbers or something like it, this is what I always do:

First run reconcile on sales, then on purchasing, then finally inventory. They all touch inventory numbers, so better safe than sorry.

Joe

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report

Thanks, maybe you can post the link.

Regards

Was this reply helpful? Yes No

Join the conversation

Community site session details

Allocated quantity

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Allocated quantity

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates