Latest news

109: Wizard - increase supplier price list
Colin Horne, 03/02/2004

For instructions on how to use the wizards contained in the technical news, please read the technical news article called How to use technical news wizards.

This Wizard increases the buy price for items purchased from the specifed supplier by the percentage given




{{{  TEMPLATE: SuppCatIncrease,SuppCatIncrease,Increase supplier cat. prices,csh

{{{  DESCRIPTION:

This Wizard increases the SUPPLIER SPECIFIC prices by the percentage given.
.
.
.
Do you wish to continue?
}}}

SETPAD:,Void
   EXP:,MonitorStart('Supplier Catalogue Price Increase')
{{{  SECTION:Define variables

SETPAD:Ref:Yes            ,Flag      ,Yes
SETPAD:Ref:No             ,Flag      ,No

SETPAD:MCHNumberTotal     ,Int

SETFLD:MCS:Supplier       ,mcs   ,mcsLoop   ,Supplier
SETFLD:MCS:Price          ,mcs   ,mcsLoop   ,UnitPrice

}}}
!stop monitor before input required
EVAL:,=MonitorStop()

{{{  PAGE:Get supplier & increase

ASKFLD:Specify the supplier ,mcs ,MCSRec ,Supplier
   TIP: ,Specify the supplier for price increase

ASKPAD:Specify the percentage increase required ,Real
   TIP: ,Define the percentage increase to be applied to the supplier catalogue items

}}}
{{{  IF:PercentNotZero  ,Specify the percentage increase required

EVAL:,=MonitorStart('Supplier Catalogue Price Increase')

{{{  SECTION:Prepare list of supplier items

EVAL:,=MonitorStep('Prepare list of items for increase')
SETPAD:SuppItems               ,RecNoQ  ,=Find(Specify the supplier,Specify the supplier)

EVAL:,=MonitorStep('Filter all items without a price')

EVAL:,=Filter(SuppItems,Selected(SuppItems)[UnitPrice])

}}}

{{{  IF:ItemsToAdjust ,Items(SuppItems)

SETPAD:MultiplyFactor  ,Real  ,=(100 + Specify the percentage increase required)/100

EVAL:,=MonitorStep('Apply the modification')
{{{  SECTION:Apply the percentage

EVAL:,=MonitorStart()

{{{  SECTION:Setup transaction

EVAL:,=TransPrepare('Prepare transaction')
EVAL:,=TransInclude('mcs')
EVAL:,=TransBegin()

}}}

EVAL:
   EXP:       ,Iterate(Load(Item(Iteration(),SuppItems) ,MCS:Supplier);

   EXP:       ,      MCHNumberTotal + 1 @ MCHNumberTotal; MonitorStop(); MonitorStart(MCHNumberTotal & '...' & MCS:Supplier);

   EXP:       ,      MCS:Price * MultiplyFactor @ MCS:Price ;Update(MCS:Supplier),

   EXP:       ,Iteration() = Items(SuppItems))

EVAL:,=TransEnd()

EVAL:,=MonitorStop()

}}}

EXIT:  ,=MCS:Supplier

}}}

EVAL:,=MonitorStop()

EXIT: ,=Void()
 TIP: ,No supplier items to adjust


}}}

EXIT: ,=Void()
 TIP: ,Zero increase specified

}}}



Back to latest news




Match-IT Limited - Smarter Solutions for Manufacturing
Tel: 0845 1300 510   Fax: 0845 1300 610  
Email: enquiries (at) make247.co.uk
Web: www.make247.co.uk