[6.10.511] Possible bug? Delete PackSlip but leave Line

Yahoo Archive
1
Todd: don't know if it is a known bug, but if you download the readme file
from the latest patch, you could check for it. I know, you probably already
thought of this. We are on patch 531 (since the end of September) and I
haven't heard a whisper on a problem like this.

Lydia

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, December 20, 2005 11:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] [6.10.511] Possible bug? Delete PackSlip but leave
Line


Ran into an oddity today. Apparently after receiving a subcontract shipment
(and it showed up on "received but not invoiced" report) someone deleted the
packing slip header - without deleting the line. So when invoicing was
attempted it kept saying there was no such PackNum. I ran a quick RB to
select that PackNum and no records were found BUT SubShipDtl did have a
line. I had our A/P person re-add the packing slip header and everything
was then OK - it showed up with the line already there.

This seems like it should not be allowed to delete a header and leave lines
that refer to it. A database no-no in terms of referential integrity.

Anyone know if this is a known bug in 6.1 and if it has been fixed in a
patch sometime after 511?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
2
Ran into an oddity today. Apparently after receiving a subcontract shipment (and it showed up on "received but not invoiced" report) someone deleted the packing slip header - without deleting the line. So when invoicing was attempted it kept saying there was no such PackNum. I ran a quick RB to select that PackNum and no records were found BUT SubShipDtl did have a line. I had our A/P person re-add the packing slip header and everything was then OK - it showed up with the line already there.

This seems like it should not be allowed to delete a header and leave lines that refer to it. A database no-no in terms of referential integrity.

Anyone know if this is a known bug in 6.1 and if it has been fixed in a patch sometime after 511?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]