x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 15 subscribers
  • Views 107 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
4
replies
General Discussion
1k
topics
2k
replies
murni

any function to find items in any transactions and remove it programmatically?

Posted By

Hi all,

is there any functions to do the following:

1. find the item

2. find the all transactions that uses this item

3. remove the items and transactions. 

4. in the meantime, take care of the data to avoid data instability. 

thank you.

Parents
  • 0

    Are you talking about a stock item and SOP/POP order lines (etc) as transactions? Are you trying to delete old items but can't because they're in use? (A common problem!)

    You can find all the order lines via SOP/POPStandardItemLink (and Arch).  But you can't delete them as it'll mess up the order.

    However, what you can do (in practice, even if not sanctioned by Sage!) is change the order line type to free text so the  standarditemlink can be deleted. This needs to be done using the underlying "Persistent" objects.

    If I've guessed right about what you're trying to do, you'll also need to check lots of other tables (eg. BOM etc).

  • 0 in reply to Geoff Turner

    Hi Geoff, yes, that is what I am trying to do. thank you for the advice

Reply Children
No Data

*Community Hub is the new name for Sage City