76
Hello,
I'm trying to create a report sales order - production and I need to get from somewhere field like confirmed quantity, confirmed date.
Anyone know in which table should I look for fields like this ? I think it should be somewhere in journals but can't find it.
Hi RadekM,
You can find header level information from CustConfirmJour table and line level details for each line of sales order from CustConfirmTrans table. As mentioned in above reply from Christoph, it might be little tricky to find the latest version of confirmed qty.
Thanks,
Jay
If you go from the prod table to the sales area with just the sales id you will get problems like you mentioned. The production order (not process industry = batch order) is for a given item. so you have to keep this in mind as well. the salesid itself is not enough. In addition you have to think about the possibility to have the same item inside the sales order multiple times. so linking with salesid and itemid is also not correct.
There are several options inside the system and it depends how your system is configured. You can check if you have a direct connection from the production order to the sales order via the references.
But this might be tricky as well. I`m not sure if it is the best idea to start your query from the production order. What if you have splitted the production due to capacity issues? So you will have one sales order line with 100 pcs but you produce in two production orders with 30 pcs and 70 pcs?
I connected prodtable with salesline and custconfirmjour all with salesid since I need to see what production are confirmed and actually going on.
It looks like this but the confirmed one is just too high..
ZS00004258 - ZS
MICKE - product
16 - 2020 -date
3360 - QTY
16752 CONFIRMED QTY
4,00 produceed
Hi RadekM,
sorry I do not understand your problem. Inside the CustConfirmTrans you will find one line for one confirmed sales order line. Or do you struggle with multiple confirmations? Technically you can confirm one sales order multiple times.
Example 1 Sales order with 3 lines:
First order confirmation print with all lines ==> 1 record in CustConfirmJour and 3 lines in CustConfirmTrans
after a modification in the sales order like adding an additional line you create a new sales order confirmation. Because of this you will get another record in CustConfirmJour and 4 lines in CustConfirmTrans
It might happen that you confirm the one additional line in the example above in a sales order confirmation without the already confirmed lines.
So it might be tricky to get the latest version of confirmed quantity. Especially because it is not mandatory to always confirm all sales order lines on the sales order confirmation.
Okay that sounds good. One more thing. I need to get to every piece of the sale order. Simply speaking I need QTY for every product separate of this order and now it i think it shows me total QTY of this order.
It should show me like:
Chair 50pcs
Bed 50pcs....
Not Chair 1600pcs
Hi,
if you are looking for the confirmed quantity you have to use the field QTY.
Okay thanks. Can you tell me one more thing? In CustConfirmTrans, confirmAmount or QTY is what I do search for ? Confirmationamount is not really looking good here.
And second thing I need to get Worker name but its an int64 how can i display the correct name not numbers ?
Hi RadekM,
When the sales order is confirmed you will find the necessary information in the table CustConfirmTrans, header related information is available in CustConfirmJour.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (