Hi,
My client is on GP10 SP3. If you do a SOP invoice and post it, and then 
afterwards do a SOP Return (either via the Auto return option or just as a 
standard SOP Return) - using a line item that is Lot Tracked and save this 
unposted SOP return in a  batch, then upon running Checklinks on the Sales 
Series then the following happens:
'A record for Return 'XXXX' was removed from the Sales Serial/Lot Work and 
History Table; no corresponding record was found in the Sales Transaction 
Amounts Work table'

Any ideas?

Thank you
Neil Palmer

You should do a return as you described and look at the lot table before 
running Checklinks.  I know that when you are working with lot based items, 
if the system cannot apportion the cost (in this case the return dollars) 
exactly evenly, it creates an additional lot with a different cost to balance 
the actual amount exactly.  It may not be tying this correctly.

-- 
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users

Get our Free Tips and Tricks Newsletter and check out our books at 
http://www.AccoladePublications.com



"Neil Palmer" wrote:

> Hi,
> My client is on GP10 SP3. If you do a SOP invoice and post it, and then 
> afterwards do a SOP Return (either via the Auto return option or just as a 
> standard SOP Return) - using a line item that is Lot Tracked and save this 
> unposted SOP return in a  batch, then upon running Checklinks on the Sales 
> Series then the following happens:
> 'A record for Return 'XXXX' was removed from the Sales Serial/Lot Work and 
> History Table; no corresponding record was found in the Sales Transaction 
> Amounts Work table'
> 
> Any ideas?
> 
> Thank you
> Neil Palmer

Hi Richard,

It is not an example of what you mention. My client is using GP10 - 10.00.1237

Steps I am using to replicate the problem:

1. Create new Item (FIFO Perpetual) with Lot Tracking
2. Add quantity to the item 
3. DO a SOP invoice using this item - chose a qty of 2 (irrelevant I think)
4. Posted SOP Invoice
5. Closed SOP Window
6. Created a SOP Return using Additional \ Create Return (This is NB - if 
you do a normal return or a Return using the Copy functionality - then it 
does not give the error) - link it to the previous Invoice.
7. Saved Return into a batch (do not post)
8. Run Checklinks on entire Sales Series
The error is produced and the lot entry removed with Checklinks.

Note: One strange thing for me is that the trxsorce in the SOP10201 table 
before Checklinks shows as 0 - maybe this has something to do with it?

Thank you

Neil


"Richard Whaley -- MVP 2006-2008" wrote:

> You should do a return as you described and look at the lot table before 
> running Checklinks.  I know that when you are working with lot based items, 
> if the system cannot apportion the cost (in this case the return dollars) 
> exactly evenly, it creates an additional lot with a different cost to balance 
> the actual amount exactly.  It may not be tying this correctly.
> 
> -- 
> Richard L. Whaley
> Author / Consultant / MVP 2006-2008
> Documentation for Software Users
> 
> Get our Free Tips and Tricks Newsletter and check out our books at 
> http://www.AccoladePublications.com
> 
> 
> 
> "Neil Palmer" wrote:
> 
> > Hi,
> > My client is on GP10 SP3. If you do a SOP invoice and post it, and then 
> > afterwards do a SOP Return (either via the Auto return option or just as a 
> > standard SOP Return) - using a line item that is Lot Tracked and save this 
> > unposted SOP return in a  batch, then upon running Checklinks on the Sales 
> > Series then the following happens:
> > 'A record for Return 'XXXX' was removed from the Sales Serial/Lot Work and 
> > History Table; no corresponding record was found in the Sales Transaction 
> > Amounts Work table'
> > 
> > Any ideas?
> > 
> > Thank you
> > Neil Palmer