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

All responses (9)

Answers (0)

Rosemary 2 on at

Like (0)

Report

RE: Allocated quantity

Thanks, maybe you can post the link.

Regards
Joseph Markovich 3,900 on at

Like (0)

Report

RE: Allocated quantity

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
Rosemary 2 on at

Like (0)

Report

RE: Allocated quantity

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
Rosemary 2 on at

Like (0)

Report

RE: Allocated quantity

No problem, don't envy you guys.
Richard Wheeler 75,730 on at

Like (0)

Report

RE: Allocated quantity

Sorry for the typo. We are in the middle of an ice storm and it is 12 degrees.
Richard Wheeler 75,730 on at

Like (0)

Report

RE: Allocated quantity

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.
Rosemary 2 on at

Like (0)

Report

RE: Allocated quantity

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
Richard Wheeler 75,730 on at

Like (0)

Report

RE: Allocated quantity

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.
Rosemary 2 on at

Like (0)

Report

RE: Allocated quantity

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