Sage 100

Customer tracks most inventory items in grams but sells in gallons. They have the number of grams/per gallon as the Sales U/M conversion factor. When doing a physical count, they'd like to be able to enter the number of gallons and have the grams calculated with the Sales U/M conversion factor. 

My question is, if I add a gallon UDF in the physical count entry panel, could we use a script or somehow calculate what the actual grams are based on the sales u/m conversion factor to populate the actual quantity counted? TIA!

------------------------------
Therese Logeais, Technology Integrators
------------------------------

I would suggest recording the counts in a spreadsheet, do the calcs there, and import from that with VI.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5
------------------------------

Except this is for CertiPros Automated Cycle Count enhancement which loads items to be counted directly into Physical Count Entry. 
#scripting??​

------------------------------
Therese Logeais, Technology Integrators
------------------------------

Original Message:
Sent: 06-11-2019 08:52
From: Phil McIntosh
Subject: Calculated UDF

I would suggest recording the counts in a spreadsheet, do the calcs there, and import from that with VI.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5
------------------------------

If the alternate UoM counts could be set into a UDF (instead of the normal field) you might be able to do something (column post validate on the UDF).  Otherwise, I don't know how a script could know if the entered number was Standard or Sales UoM.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 06-11-2019 12:25
From: Therese Logeais
Subject: Calculated UDF

Except this is for CertiPros Automated Cycle Count enhancement which loads items to be counted directly into Physical Count Entry.
#scripting??​

------------------------------
Therese Logeais, Technology Integrators
------------------------------


Original Message:
Sent: 06-11-2019 08:52
From: Phil McIntosh
Subject: Calculated UDF

I would suggest recording the counts in a spreadsheet, do the calcs there, and import from that with VI.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5

That's what my thought was - add a GAL UDF - and the sales u/m conversion factor UDF - into Phys. Ct. entry then populate the actual quantity counted based on the two UDF's.

------------------------------
Therese Logeais, Technology Integrators
------------------------------

Original Message:
Sent: 06-11-2019 12:28
From: Kevin Moyes
Subject: Calculated UDF

If the alternate UoM counts could be set into a UDF (instead of the normal field) you might be able to do something (column post validate on the UDF).  Otherwise, I don't know how a script could know if the entered number was Standard or Sales UoM.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------


Original Message:
Sent: 06-11-2019 12:25
From: Therese Logeais
Subject: Calculated UDF

Except this is for CertiPros Automated Cycle Count enhancement which loads items to be counted directly into Physical Count Entry.
#scripting??​

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 06-11-2019 08:52
From: Phil McIntosh
Subject: Calculated UDF

I would suggest recording the counts in a spreadsheet, do the calcs there, and import from that with VI.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5