1,262
Hello Community,
Would it be possible to tell me when records are inserted into InventTrans Table during Confirmation and posting Of a purchase order?
and which classes, tables are involved during this process?
Thanks a lot for your help
Kind regards
Jihane
Hi jihane,
Records are inserted into InventTrans when a PO Line is created. I cannot think of a reason that would cause PO Confirmation to create records in InventTrans, since PO Confirmation does not affect inventory.
Posting subsequent statuses of a PO could cause extra records to be created in InventTrans if, for example, the quantity being posted was not for the full quantity on the PO Line. For example, if you've a PO Line for a quantity of 3, posting the Product receipt for a quantity of 2 would result in one record in InventTrans with the receipt status Received, and another with a quantity of 1 with a different status.
Sorry, I do not know which classes are responsible for the creation of records in InventTrans.
apologies, let me correct my wording.
InventTrans is created, only once for each PO Line
there is also an index on PO Lines Table for it
InventJournalTrans is created only once at time of PO creation.
in later stages (confirmation, receiving, invoicing) only status of InventTrans is changed. It is not recreated again.
what you want to do actually?
Set a breakpoint in the insert() method of the table and execute the logic (confirmation, posting). You can then see the classes involved in the debugger. It's a really vague question though. There are tons of classes involved in posting the main one probably being PurchFormLetter (and it's derived classes).
You might want to read up on the parmTable framework.
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...
290,353
Super User 2024 Season 2
#2
Martin Dráb
228,251
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (