UBS Inventory Software » Report

ID #1299

Display 3rd unit of measurement item

Description

This solution below show the  steps  to customize display 3rd unit of measurement item.

 

Solution

1.  Go to Maintenance   >   Item Maintenance   >  Item File Maintenance, add new item with measurement pcs, boxes  & cartons (i.e. 1 box = 10 pcs & 1 carton  =20 pcs, change the factor1  to 10 and 20 respectively)

2.          Issue  a Receive for same  item with 3 units of measurement (i.e. 2 pcs, 2 boxes  & 2 cartons)

3.          Then issue an Invoice of 3 units measurement with same  item (i.e. 1 pc, 1 box & 1

carton)

4.          Now you are allowed to generate the  Stock Card report  (Report    Inventory

Reports    Stock Cards, select Format  3)

5.          When you preview the  format,  click “File“, save  as stkO433

6.          Next, customize your saved  format  as command below:-

 

a.    Right click “Exit“ button, select the  format  stkO433

b.    Add new variable, quantity IN for header, detail and total section, refer to the below diagram

c.     Header        iif(icitem.factorl > icitem.factor2,icitem.unit3,icitem.unit)

d.    Detail       trans(ictran.qtyIictran.factorl,qtypicm), at print when                 ictran.sign

= l and ictran.unit_bil = icitem.unit3

e.    Footer,  create new variable ‘IN3’ ;value to store iif(ictran.unit_bil=icitem.unit3 and ictran.sign=l, ictran.qtyIictran.factorl,O) ;calculate as sum; reset  at initfile.itemno. In variable expression assign as trans(IN3, qtypicm).

f.      Next, Add variable quantity OUT for header, detail and total section, refer to the

below diagram

g.    Header        iif(icitem.factorl > icitem.factor2,icitem.unit3,icitem.unit)

h.    Detail         trans(ictran.qtyIictran.factorl,qtypicm), at print when                ictran.sign =-l and ictran.unit_bil = icitem.unit3

i.     Footer,  create new variable ‘OUT3’ ;value to store

iif(ictran.unit_bil=icitem.unit3 and ictran.sign =-l, ictran.qtyIictran.factorl,O) ;calculate as sum; reset  at End Of Report. In variable expression assign as   trans(OUT3, qtypicm), at print when           out3>O

j.      Modify the existing detail field quantity In

k.     Detail         2nd  unit (Box) at print when         ictran.sign = l and ictran.unit_bil <>

icitem.unit3 and ictran.unit_bil <> icitem.unit

l.     Detail         1st unit (Pc)  at print when          ictran.sign = l and ictran.unit_bil <>

icitem.unit3 and ictran.unit_bil <> icitem.unit2

m.   Edit variable   ‘INl’ to  expression              iif(ictran.sign=l  and (icitem.unit3 <>

ictran.unit_bil), Dbunit(ictran.qty,2,.t.,ictran.factorl,ictran.factor2),O)

n.    Modify the existing detail field quantity Out

o.    Detail         2nd  unit (Box) at print when         ictran.sign = -l and ictran.unit_bil <>

icitem.unit3 and ictran.unit_bil <> icitem.unit

p.    Detail         1st unit (Pc) at print when          ictran.sign = -l and ictran.unit_bil <>

icitem.unit3 and ictran.unit_bil <> icitem.unit2

q.    Edit Report      Variable ‘OUTl’            iif(ictran.sign=-l and (icitem.unit3 <>

ictran.unit_bil),dbunit(ictran.qty,2,.t.,ictran.factorl,ictran.factor2),O)

r.      Add field balance of 3 units measurement, refer to the below diagram s.         Pcs        trans(dbunit(qtybf,l,.t.)+in2 -out2,qtypicm)

t.      Boxes        trans(dbunit(qtybf,2,.t.)+inl -outl,qtypicm)

u.    Cartons        trans(in3 - out3, qtypicm)

v.     Enclosed ‘backup-stk0433.bak’

Tags: Display 3rd unit of measurement item

Related entries:

Last update: 2010-11-16 03:25
Author: Noor Diyana
Revision: 1.1

Digg it! Share on Facebook Print this record Send FAQ to a friend Show this as PDF file
Propose a translation for Propose a translation for
Please rate this FAQ:

Average rating: 0 (0 Votes)

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry