2,395
Is there a report or an easy way to relate a general ledger entry to a Production order? I haven't found anything.
Manufacturing creates 2 inventory transactions end then two general ledger entries, we want to know wich general ledger entry corresponds to wich production order entry.
Thanks in advance
*This post is locked for comments
Hi Harry Lee,
It's good view
now i already add to my Smartlist View Design
here is my blogs
Thanks redbear!
Alvaro,
Here is a script, which links the Journal Entry for Inventory transactions from the MOP10213 table from the HITB Table. Of course this requires that HITB be deployed.
SELECT A.MANUFACTUREORDER_I MO_Number,
CASE A.MO_ACTIVITY_REASON_I
WHEN 34 THEN 'Issue'
WHEN 38 THEN 'Raw Material Relief'
WHEN 39 THEN 'Finished Good Post'
ELSE convert(Varchar(2),a.MO_ACTIVITY_REASON_I,1)
END AS Reason_Code,
CASE A.DOCTYPE
WHEN 1 THEN 'IV Transaction'
ELSE ' '
END AS Document_Type,
B.DOCNUMBR Document_Number,
convert(varchar(10),B.DOCDATE,101) Document_Date,
B.ITEMNMBR Item_Number,
B.QTYBSUOM*B.TRXQTY AS Quantity,
C.JRNENTRY,
C.GLPOSTDT,
C.TRXREFERENCE
FROM [MOP10213] AS A
LEFT OUTER JOIN IV30300 AS B
ON A.IVDOCNBR = B.DOCNUMBR
Left Join SEE30303 as C
on B.DOCNUMBR = C.DOCNUMBR
WHERE A.DOCTYPE = 1
ORDER BY A.MANUFACTUREORDER_I, A.IVDOCNBR
If you don't see Journal Entries in the Activity View - then the financial Journal Entries have not been posted.
(Transactions > Financial > Series Post or Batches - lookup)
You should definitely see the JE's in the window if they have been posted. I tried to insert an image on this post - but was not able to - if you send me an email at: btamulis@hotmail.com - I'll be happy to send you a screen shot of what a completed or partially received MO should look like in the activity window.
Account Transactions standard smartlist; add the reference column which should contain the Manufacturing order reference if the journal came from an inventory trx from an MO source. Filter down the list on the reference field to include whatever common text you have on your production orders (in our case they all start imaginatively with "MO" !)
Cheers, Al
Thanks Bron, I checked both tables you mentioned, on GL20000 under reference I only hace Trasaction entry. and on table MOP10213 I can just find the Inventory adjustment number, also on the inquiry window it only shows the inventory adj.
Care to point me in the right direction about the other two tables you mentioned so I can build a smartlist?
Thanks again.
GP Manufacturing kind of does this.
First - Inquiry > Manufacturing > Manufacturing Orders > Order Activity - is a great screen that an end user can 'drill back to the JE that was created by the transaction that is listed on this window. Highlight the transaction and click the blue arrow on top tool bar of scrolling window.
If you are handy in SQL/Smartlist Builder - you can review the MOP10213 table - it actually stores the Journal Entry Number and the actual Inventory Adjustment number.
The GL20000 table will also have the MFG Order Number under REFRENCE column.
If you have some SQL skills putting together the MOP10213 - the GL20000 and a couple of other tables - you can get the information in a report or smartlist pretty easy.
Share
Report
All responses (
Answers (
