Set up a UDF to flow the PL into the transaction table and use this (pre-write on the detail table)... nothing to it. We typically use a checkbox item by item, but it's the same concept.
sValueToCheck = "" : retVal = 0
retVal = oBusObj.GetValue("UDF_PRODUCT_LINE$", sValueToCheck)
if sValueToCheck = "ZZZZ" then
retVal = oBusObj.SetValue("DropShip$", "Y")
end if
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------
Original Message:
Sent: 04-06-2021 16:57
From: Michele Herzog
Subject: Customer Pricing for Miscellaneous Items
That's a good idea! Is your script generic enough that I could purchase from you and maybe just have to change the name of the product line line in the script or tell you the product line name, you could make the change and send me the script. I know how to bring a script into custom office, I just need a screen shot of the user-defined script maintenance to know the priority and then compile and test.
------------------------------
[Michele] [Herzog] [CPA,CITP, CGMA]
[Overland Park] [KS]
[816-520-1365]
------------------------------
Original Message:
Sent: 04-06-2021 16:46
From: Kevin Moyes
Subject: Customer Pricing for Miscellaneous Items
We use a little script to enable the DropShip flag when we use that strategy... then the inventory doesn't have to go negative.
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
Original Message:
Sent: 04-06-2021 16:41
From: Jeff Schwenk
Subject: Customer Pricing for Miscellaneous Items
What about setting up these misc items are a regular inventory item. Create a misc product line to handle the necessary offsets. Set costing to standard. Every now and then do a physical inventory count/adjustment to bring the negative on hands back to zero. This will enable the customer pricing functionality.
------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
Original Message:
Sent: 04-06-2021 15:59
From: Kevin Moyes
Subject: Customer Pricing for Miscellaneous Items
I'm sure we can figure something out if you need help.
Just reach out to @Robert White (who would handle the business side of things).
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
Original Message:
Sent: 04-06-2021 15:22
From: Michele Herzog
Subject: Customer Pricing for Miscellaneous Items
Unfortunately, I do not know how to write scripts. I will reach out to @Steve Iwanowski who has helped me in the past. If he is not available, can you take on extra work to assist me in this?
------------------------------
[Michele] [Herzog] [CPA,CITP, CGMA]
[Overland Park] [KS]
[816-520-1365]
Original Message:
Sent: 04-06-2021 15:15
From: Kevin Moyes
Subject: Customer Pricing for Miscellaneous Items
UDT and script lookup.
Set the UDT key to be something like Division^CustomerNo^ItemCode for the lookup to be the most efficient.
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON