You’re offline. This is a read only version of the page.
1,175
We manage our inventory in EA as base UofM. However, we purchase in INN (Inner) for most of our items. Qty in INN can be different per item.
<For example>
Item A: 1 INN is equivalent to 10 EA
Item B: 1 INN is equivalent to 12 EA
Item C: 1 INN is equivalent to 24 EA
We'd like to show the qty order both in INN and EA as well, also for unit cost, we'd like to show as unit cost in INN and unit cost in EA as well. When we enter purchase qty, we enter in INN for most of orders. Therefore, default order qty on the PO shows in INN qty.
One of items is set up its U of M schedule as above. When unit cost in INN is $10.00 and order qty is 1 in INN, how could we display unit cost in EA $1.00 and order qty 10 in EA?
Please advise us.
*This post is locked for comments
and on these situation we say, when there is a will there is a way. thumbs up. :)
jbserp please mark Justin reply as verified answer.
Almas...I hope you enjoy the tea :)
I believe I have found better way to accomplish the task at hand.
1.) Make a table relationship between popPOLineRollupTemp and Purchase Order Line, using the POP_POLineIdxItemID key, and matching all 3 fields.
2.) Link the Purchase Order Line to the report (1:1 Relationship :) )
3.) The Purchase Order Line table has the following field: U Of M QTY In Base
This U Of M QTY In Base is essentially the "Factor" I was attempting to get in my previous post...
Therefore you can use this "POP_POLine.U Of M QTY In Base" in other calculations.
=============================================
So now it should be a relatively simple matter of making 2 calculated fields:
1.) cyQTYOrdered * POP_POLine.U Of M QTY In Base
2.) cyUnitCost / POP_POLine.U Of M QTY In Base
Lastly, drag those 2 calc fields onto the layout of the report and assign them a "Format Field" of nDecimalQty and nItemCurrencyIndex respectively.
Ok, I'm all "Report Writered Out" for today.
Thanks,
Justin
Wow.long but decent answer.
What I think it could not be done alone by report writer.will give it a look when have time.Rightnow I am enjoyingy tea after whole day fasting.
Hi,
I didn't have time to test this last night, and unfortunately, as you mention Almas, this isn't returning the desired figure.
However, I believe the desired result can potentially be achieved using just Report Writer (no VBA or Dex).
==============================
I'm assuming that you have 3 U of M Schedules:
U OF M SCHEDULE: INN10
BASE U OF M = EACH
EQUIVALENTS:
EACH = 1 EACH
INN = 10 EACH
U OF M SCHEDULE: INN12
BASE U OF M = EACH
EQUIVALENTS:
EACH = 1 EACH
INN = 12 EACH
U OF M SCHEDULE: INN24
BASE U OF M = EACH
EQUIVALENTS:
EACH = 1 EACH
INN = 24 EACH
=========================================
So the "IDEA" is...
1.) Create table relationship from popPOLineRollupTemp to the Item Master, using Key 1 and "Item Number".
2.) Link the Item Master to the Report (The reason we do this is to get the U of M Schedule of the Item)
3.) Create a series of Conditional Expressions to get the "factor" (10, 12 or 24).
Conditional Expression 1:
Condition: IV_Item_MSTR.U Of M Schedule = "INN10" AND popPOLineRollupTemp.U Of M = "Inn"
T: 10
F: Conditional Expression 2
Conditional Expression 2:
Condition: IV_Item_MSTR.U Of M Schedule = "INN12" AND popPOLineRollupTemp.U Of M = "Inn"
T: 12
F: Conditional Expression 3
Conditional Expression 3:
Condition: IV_Item_MSTR.U Of M Schedule = "INN24" AND popPOLineRollupTemp.U Of M = "Inn"
T: 24
F: 0 (Or 1 or another condition depending on requirements)
(Note: You create the conditional fields in reverse order. So created Conditional Expression 3 first, then 2, etc...)
==========
Once you have the "Factor" which is returned by Conditional Expression 1, you can then use this in other calculated fields, etc...
So, this is a pretty long winded way of doing things...but I just wanted to throw the idea out there as it might work (again depends on exact business requirements, etc...).
Thanks,
Justin
unfortunately this temp table is giving 0.0 value for the filed U of M QTY In Base. Is it giving you values on your report Justin Thorp?
Hi,
Can you pull out the following onto the layout of your PO:
Purchase Order Line TEMP.U of M QTY In Base
Thanks,
Justin
Hi,
I agree with Almas, you need customization to achieve your requirement.
This could not be done by just report writer, but yes can be done through custom RW function, so what you need is customization.
Hi Babu, Thank you for your reply.
Yes. We are aware that we can set multiple U of M based on the base U of M. In our case, base UofM is always EA and other measurement we use is in INN which could have vary qty equivalent in EA. When we print PO, by default, qty order can only show in what we entered in PO line which is in INN in our case. However, we'd like to show how many qty in EA for the line order as well. We appreciate how we can work the report writer to display in different UofM.
Hi,
An item can be linked to one unit of measurement schedule and each schedule can have multiple unit of measurement. Please click here to have a look at very good post by Mr.Mahmoud about unit of measurement.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,104
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (