Check Inventory when Delete Item Variant

elTorito · 2005-06-14

However is possible delete an Variant Code from an Item if them has Inventory <>0.

Which Function can I Call or Modify so before Delete, it checks if they are Inventory <>0 and if Are Items with Variants in Order or in other Use ?

Thanks.

kriki · 2005-06-14

I am afraid you have to write the code yourself. Something like:

rec32.RESET;
rec32.SETCURRENTKEY("Item No.","Variant Code");
rec32.SETRANGE("Item No.",'My Item No.');
rec32.SETRANGE("Variant Code",'My Variant Code');
rec32.CALCSUMS(Quantity);
IF rec32.Quantity <> 0 THEN
MESSAGE('Quantity is not 0');

If there is a quantity different from 0, you have to make item-postings to bring it to 0.

rec37.RESET;
rec37.SETCURRENTKEY(Type,"No.","Variant Code");
rec37.SETRANGE(Type,rec37.Type::Item);
rec37.SETRANGE("No.",'My Item No.');
rec37.SETRANGE("Variant Code",'My Variant Code');
IF rec37.FIND('-') THEN
MESSAGE('There are %1 records in table 37',rec37.COUNT);

and the same test for table 39.

elTorito · 2005-06-14

Hmm. Perhaps it can be Use Form 342 (Check Avaibility) ...

I'm checking at time if i can use it...

elTorito · 2005-06-14

kriki wrote:

I am afraid you have to write the code yourself. Something
and the same test for table 39.

Well , i have now Code myself ... the solution with the form 342 and CU 311 likes Nice, but its me at moment to complicated modify / add any source

8-[

Thanks for you answer and tipp

Howdy, Stranger!

Quick Links

Categories

Check Inventory when Delete Item Variant

Comments